Intro to SQL for Marketers
  • Welcome to SQL for Marketers!
  • First Assignment
  • What Is SQL?
  • Example SQL Query
Writing SQL Queries
  • Introduction to Writing SQL Queries
  • Challenge: Using Select, From and Where
  • Answer: Using Select, From and Where
  • The Join Statement
  • Challenge: Using Join!
  • Answer: Using Join
  • Sorting and Limiting
  • Sorting and Limiting Challenge
  • Answer: Sorting and Grouping Challenge
  • Questions?
  • Count and Other Functions
  • Test Database
  • SQL Structure Questions
Setting up SQL Tools
  • Setting Up SQL Tools
  • Before moving on...
  • Using SQL Pro
Using SQL
  • Exercise 1: How Many Orders Has Each Customer Placed?
  • Exercise 1 Answer
  • Exercise 2: Where Does Your Best Customer Live?
  • Exercise 2 Answer
  • Exercise 3: Find the World's Most Popular Language
  • Exercise 3 Answer
  • Exercise 4: Find the Most Populous Cities in the World
  • Exercise 4 Answer
  • Exercise 5: Use SQL to Understand User Demographics
  • Exercise 5 Answer: How to Use SQL to Understand your User Demographics
  • Using SQL for Cohort Analysis
  • Examples of Cohort Analysis
  • SQL Scripting and Reporting
  • What Other Marketers Have Done With SQL
  • Finding Table and Column Names
  • Conclusion
  • What did you think of the course?
Bonus Content
  • Bonuses
  • How to Query a Database
  • Lecture Slides
  • SQL Cheat Sheet
  • Free eBook: Become a Technical Marketer