Course Highlights
  • Analyze user behavior
  • Find actionable customer/business insights
  • Make data-driven decisions
  • Measure and track marketing efforts
  • Discover sexy marketing stats (e.g. 1 in 4 people love toast!)
Skills you will learn!
Curriculum

4 Topics
DON'T SKIP THIS LECTURE!
Getting Started (Downloading a Text Editor!) - All OS
Grand Tour of Your SQL Editor + How to Preview Data
POP QUIZ

5 Topics
What the heck is a relational database?
[QUIZ] What the heck is a relational database?
Da SQL Basics: Skeleton of a Query
SQL Query Skeleton
[Brainbuster] Build Your First Query!

22 Topics
COUNT() and GROUP BY
Brainbuster TWEAK
COUNT() and GROUP BY
[Brainbuster] Organize movies by rating!
Connecting Tables
Connecting Tables (Warm-up for Brainbuster)
[Brainbuster] Connect Tables
[Brainbuster] Finding your best selling products (Rental Count by Movie)
Having trouble understanding "connecting tables"?
Arithmetic & Order By
[Brainbuster] Finding Your Top-Performing Store
LEFT() MIN() AND MAX()
[Brainbuster] Finding Your Active Users - Last Rental Time by Customer
[Brainbuster] Finding Month over Month Revenue Growth
DISTINCT
[Brainbuster] Find Distinct Films Rented Each Month
IN()
Comparison Operators and HAVING
[Brainbuster] Breaking Down Revenue by Store and Rating
Nested Queries
PSA: Temporary Tables on SQLSnack
Nested Queries vs. Temporary Tables

7 Topics
JOINs
[Brainbuster] JOINs
What is a Cohort Analysis?
Cohort Analysis Query: Setting the Stage
Cohort Analysis Query: SQL Fanciness
Cohort Analysis Query: Finishing Touches
Add your new skills to LinkedIn!

  Write a Review

SQL for NEWBS: Weekender Crash Course

Go to Paid Course