The Content 🔥
Try the Preview lessons free! ⬇️
Free Course Previews
Available in
days
days
after you enroll
Chapter 0: Course Intro and Set Up
Available in
days
days
after you enroll
Chapter 1: Joins
Available in
days
days
after you enroll
- Intro to Joins (4:15)
- Inner Join (Lesson 1) (10:39)
- Using Aliases for Tables & Columns (Lesson 2) (1:55)
- Counting Basics w/ Inner Joins (Lesson 3) (5:57)
- Left Join (Lesson 4) (10:32)
- Anti Join (Lesson 5) (6:05)
- Tables without Overlap (Lesson 6) (6:11)
- Full Outer Join (Lesson 7) (4:05)
- The Diabolical Right Join (Lesson 8) (2:42)
- Multiple Join Conditions (Lesson 9) (4:10)
- Filtering Data w/ ON vs WHERE (Lesson 10) (5:02)
- Joining Multiple Tables (Lesson 11) (3:41)
- Joins Quiz
Chapter 2: CASE
Available in
days
days
after you enroll
- Intro to Case (2:24)
- Categorizing Data (Lesson 1) (7:16)
- Why Order Matters (Lesson 2) (3:59)
- Summarizing Categorical Data (Lesson 3) (5:49)
- Creating Binary Columns (Lesson 4) (10:12)
- Aggregate Functions w/ CASE (Lesson 5) (6:18)
- Case Study: Marketing Lead Scoring (Lesson 6) (18:31)
- Pivoting Data w/ CASE (Lesson 7) (11:17)
- Case Quiz
Chapter 3: Common Table Expressions (CTEs)
Available in
days
days
after you enroll
- Intro to CTEs (2:12)
- Nesting Aggregate Functions (or not!) (Lesson 1) (3:12)
- Why CTEs Are Necessary (Lesson 2) (6:00)
- Descriptive Stats w/ Aggregate Functions (Lesson 3) (12:06)
- Distribution of Variables (Lesson 4) (9:42)
- Using CTEs for Separate Steps (Lesson 5) (10:40)
- Multiple CTEs (Lesson 6) (16:15)
- CTEs Quiz
Chapter 4: Set Operations
Available in
days
days
after you enroll
Chapter 5: Subqueries
Available in
days
days
after you enroll
- Intro to Subqueries (1:51)
- Subqueries in FROM (Lesson 1) (9:46)
- Subqueries in WHERE and NOT IN (Lesson 2) (6:32)
- Subqueries in WHERE and NOT EXISTS (Lesson 3) (5:27)
- Bonus ANTI Join Solution (Lesson 4) (4:23)
- Subqueries in SELECT (Lesson 5) (8:44)
- Calculating the % of Total (Lesson 6) (8:11)
- Correlated vs. Uncorrelated (Lesson 7) (3:47)
- CTEs vs. Subqueries (Lesson 8) (2:24)
- Subqueries Quiz
Chapter 6: Self Joins
Available in
days
days
after you enroll
- Intro to Self Joins (3:00)
- Hierarchical Relationships (Lesson 1) (8:24)
- Cleaning Self Join Data (Lesson 2) (9:30)
- Self Joins w/ Subqueries (Lesson 3) (4:44)
- Aggregating Self Join Data (Lesson 4) (3:03)
- Case Study: Subscription Upgrades (Lesson 5) (10:05)
- Descriptive Stats for Subscription Upgrades (Lesson 6) (3:07)
- Comparing Rows w/ Self Joins (Lesson 7) (10:56)
- Self Joins Quiz
Chapter 7: Window Functions
Available in
days
days
after you enroll
- Intro to Window Function (3:34)
- Row Number vs. Rank vs. Dense_Rank (Lesson 1) (9:23)
- Ranking with Partition By (Lesson 2) (3:27)
- Filtering Window Functions with CTEs (Lesson 3) (9:16)
- Filtering Window Functions with Qualify (Lesson 4) (4:01)
- Running Totals & Averages (Lesson 5) (12:34)
- Rolling 30 Day Average (Lesson 6) (15:49)
- First & Last Values (Lesson 7) (12:51)
- Case Study: Status Timestamps w/ Lead (Lesson 8) (11:38)
- Alternative Solution w/ Lag (Lesson 9) (6:51)
- Window Functions Quiz
Chapter 8: Optimization
Available in
days
days
after you enroll
- Intro to Optimization (3:04)
- Reducing Rows w/ Limit (Lesson 1) (1:15)
- Reducing Columns & Avoiding Select * (Lesson 2) (1:17)
- Filtering Rows w/ WHERE (Lesson 3) (1:56)
- Inner Joins vs. Left Joins (Lesson 4) (3:15)
- Filtering in Joins vs. WHERE (Lesson 5) (4:04)
- Avoiding Distinct (Lesson 6) (2:09)
- Avoiding Sorting (Lesson 7) (1:56)
- Wildcards at beginning of string (Lesson 8) (1:58)
- EXISTS instead of COUNT(*) (Lesson 9) (3:21)
- Optimization Quiz
Chapter 9: Views & Temp Tables
Available in
days
days
after you enroll
- Intro to Views and Temp Tables (3:49)
- Last 1 Year Subscriptions View (Lesson 1) (10:40)
- Unioned Subscriptions View (Lesson 2) (6:32)
- Last 1 Year Subscriptions Temp Table (Lesson 3) (3:08)
- Unioned Subscriptions Temp Table (Lesson 4) (2:35)
- Views vs. Temp Tables (Lesson 5) (0:49)
- Views and Temp Tables Quiz
Chapter 10: Portfolio Projects
Available in
days
days
after you enroll
Bonus: Cheat Sheets, Interview Prep, & Resume Template
Available in
days
days
after you enroll
Conclusion
Available in
days
days
after you enroll
Full Time Senior Data Analyst
Senior Data Analyst in SaaS Tech, Negotiated from $70K to over $150K base salary in 1 year, Promoted to Senior Level & Manager, Expert in SQL & SaaS Product Analytics.
Has Taught 60K+ Students
Has taught Data Analysts targeting a Senior role, Aspiring Data Analysts & Career Transitions, Managers & Execs, and so many more people JUST LIKE YOU! Over 60K students on LinkedIn Learning.
Community of 350K+
Has over 350K followers on LinkedIn, Instagram, YouTube, and the Big Data Energy Newsletter.