✨Stay Tuned BDEs!✨
The countdown is ON! 🚀 Get ready to step into your next level because the full course launch is dropping right here on 11/27! Mark your calendars, clear your schedules, and stay tuned for a launch that’ll bring you everything you’ve been waiting for… and maybe a few bonus gifts to make it even sweeter.
Leveling up SQL Skills, Slaying Live Interviews, and Making Portfolios?
That's. What. I. Do!
And you will, too with a little practice and Big Data Energy! 😉
From Newbie to SQL Expert
💻 Hands-On Coding
Interactive coding sessions —you code alongside me! Apply your previous SQL skills and learn new ones to answer advanced business problems!
🏆Guided Portfolio Project
You’ll create a comprehensive portfolio project that highlights your readiness to take on the industry— which you can add to your resume and talk about in interviews with hiring managers.
🔧 Modern Tech Stack
Get ahead of the curve with modern technologies like HEX data science notebooks and a Snowflake data warehouse— the tools that today’s employers demand, bridging the gap between academic learning and the professional landscape. Say goodbye to old and clunky IDEs!
🌟 Proprietary SaaS Tech Data Model
Immerse yourself in real-world problem solving! You’ll solve realistic problems Software-as-a-Service technology companies face, giving you the business acumen knowledge you need. My proprietary data model will get you used to realistic data— so go ahead and throw out your Titanic and Iris datasets!
Check Out The Syllabus!
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Full Time Senior Data Analyst
Unconfident Math Nerd turned Passionate Data Techie, Hired as a Data Analyst in SaaS Tech, Negotiated $70K to over $150K base salary in 1 year, Promoted to Senior Level & Manager, Expert in SQL & SaaS Product Analytics.
Has Taught 50K+ Students
Has taught Data Analysts hoping to land a Senior role, Aspiring Data Analysts & Career Transitions, Managers & Execs, and so many more people JUST LIKE YOU!
Community of 300K+
Just a bunch of friends sharing, teaching, confiding in and even complaining to each other, sharing industry news, relatable experiences, and tips to make tech fun and inclusive. We focus on challenging stereotypes in the data and tech industry- making BIG noise along the way!
