00

DAYS

00

HOURS

00

MINS

00

SECS

Black Friday Data Deals Are Here 🖤

 
Every step of your data journey,  from learning SQL to landing interviews, is on sale THIS WEEK only.
Don’t wait another year to chase the job you keep saying you want.
 

Your Data Career Starts NOW⚡

CLAIM MY DEALS!

Don't just take it from me...here is what my students have to say!⤵️

Video Poster Image

Hi, I'm Jess

Senior Data Analyst in tech turned full-time entrepreneur at Big Data Energy ⚡. I teach SQL and data analytics in a way that’s practical, approachable, and (dare I say) actually fun! After growing my own corporate salary from $71K to $153K, I'm helping others land their FIRST data analytics job and grow into more senior & technical roles.  My students are landing their dream jobs with $25K-31K salary increases in only a few months through my real-world courses, portfolio blueprint, and personal mentorship 😉

Senior Data Analyst

Senior Data Analyst in SaaS Tech, Negotiated from $70K to $153K base salary in 1 year, Promoted to Manager level, 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!

Community of 350K+

Has over 350K followers on LinkedIn, Instagram, YouTube, and the Big Data Energy Newsletter. And over 60K students on LinkedIn Learning!

CLAIM MY DEALS!

Your Opportunity⚡

From Struggling to Confident💪

Stop freezing up when interviewers ask about CTEs, window functions, or self joins. You’ll learn how to confidently write queries that hiring managers respect!

From Slow Queries to Smart SQL🤓

No more brute-force, messy queries that barely run. You’ll learn optimization patterns and cleaner SQL habits so your code is faster, scalable, and interview-ready!

From Silly Exercises to Real Projects📋

Leave behind copy & pasted tutorials that don’t translate to the real world. Build a portfolio w/ projects on SaaS data that prove you can solve REAL business problems, not just classroom examples.

From Lonely to Mentorship💼

Stop being lonely and feeling overwhelmed and lost. Expedite your success and next job with the power of community and mentorship from me, Jess, in the course Discord. 

"I'm soooooo glad I met you. 
First data job over six figures, I wish I had done this sooner. That's a $31k hike from what I was making."  - Kelly Smith

Video Poster Image

What MORE Students are saying:

FAQs⚡

  Email [email protected] if you have any questions! I'll actually respond 

A Peak into the Courses

Step 2: Big SQL Energy⚡️ Beginner

  1. Chapter 1: Intro & The Basics

    8 lessons
    1. 0: Intro & Setup
    2. 1: Select, From, & *
    3. 2: Order By
    4. 3: Primary vs. Foreign Keys & Distinct
    5. 4: Limit & Top
    6. 5: Data Types & Cast
    7. 6: String Manipulation
    8. 7: Arithmetic Operators

  2. Chapter 2: Filtering Datasets & Wildcards

    7 lessons
    1. 1: Filtering w/ WHERE
    2. 2: Boolean Logical Operators
    3. 3: Between & NOT Between
    4. 4: IN & NOT IN
    5. 5: Is Null, If Null, & Is Not Null
    6. 6: Wildcards
    7. 7: Like vs. Ilike & Wildcard Variations

  3. Chapter 3: Functions, Dates, & Grouping

    9 lessons
    1. 1: Aggregate Functions
    2. 2: Count(*) vs. Count(column)
    3. 3: Current Date & Time
    4. 4: Basic Date Functions
    5. 5: DateDiff()
    6. 6: Date_Add()
    7. 7: Date_Trunc()
    8. 8: Group By & Aggregate Functions
    9. 9: Having (vs. Group By)

  4. Chapter 4: Bridging the Gap to Intermediate SQL

    5 lessons
    1. 1: Coalesce & Isnull()
    2. 2: Case & Categorizing Data
    3. 3: Data Dictionaries
    4. 4: Data Models & Fact vs. Dimension Tables
    5. 5: Inner Joins

  5. Chapter 5: Case Studies & Wrap Up

    3 lessons
    1. 1: Case Study Calculate a Percent in SQL
    2. 2: Case Study Visualizing Data
    3. 3: Next Steps & Finding Data to Practice

  6. Build your first portfolio project 🎉

    1 lesson
    1. Build your first portfolio project 🎉

  7. Intermediate Course Sneak Preview 👀

    5 lessons
    1. Big SQL Energy Intermediate Course Intro
    2. Chapter 1: Intro to Joins
    3. Chapter 1: Inner Join (Lesson 1)
    4. Chapter 10: The Importance of Projects
    5. It's time to get serious now w/ Intermediate SQL! 🧠

Step 3: Big SQL Energy⚡️ Intermediate

  1. Chapter 0: Course Intro and Set Up

    5 lessons
    1. Big SQL Energy Intro
    2. Join the Big Data Energy Discord Community
    3. Data Science Notebook Demo
    4. Proprietary SaaS Tech Data Models
    5. Community Live Event Recordings

  2. Chapter 1: Joins

    14 lessons
    1. Intro to Joins
    2. Inner Join
    3. Using Aliases for Tables & Columns
    4. Counting Basics w/ Inner Joins
    5. Left Join
    6. Anti Join
    7. Tables without Overlap
    8. Full Outer Join
    9. The Diabolical Right Join
    10. Multiple Join Conditions
    11. Filtering Data w/ ON vs WHERE
    12. Joining Multiple Tables
    13. Joins Quiz
    14. Refresh Beginner Skills?

  3. Chapter 2: CASE

    9 lessons
    1. Intro to Case
    2. Categorizing Data
    3. Why Order Matters
    4. Summarizing Categorical Data
    5. Creating Binary Columns
    6. Aggregate Functions w/ CASE
    7. Case Study: Marketing Lead Scoring
    8. Pivoting Data w/ CASE
    9. Case Quiz

  4. Chapter 3: Common Table Expressions (CTEs)

    9 lessons
    1. Need to Review Beginner Skills?
    2. Intro to CTEs
    3. Nesting Aggregate Functions (or not!)
    4. Why CTEs Are Necessary
    5. Descriptive Stats w/ Aggregate Functions
    6. Distribution of Variables
    7. Using CTEs for Separate Steps
    8. Multiple CTEs
    9. CTEs Quiz

  5. Chapter 4: Set Operations

    8 lessons
    1. Intro to Set Operations
    2. Union & Union All
    3. Except / Minus
    4. Intersect
    5. Combining Decentralized Data
    6. Unpivoting With Union
    7. Case Study: Subscription Cancelation
    8. Set Operations Quiz

  6. Chapter 5: Subqueries

    10 lessons
    1. Intro to Subqueries
    2. Subqueries in FROM
    3. Subqueries in WHERE and NOT IN
    4. Subqueries in WHERE and NOT EXISTS
    5. Bonus ANTI Join Solution
    6. Subqueries in SELECT
    7. Calculating the % of Total
    8. Correlated vs. Uncorrelated
    9. CTEs vs. Subqueries
    10. Subqueries Quiz

  7. Chapter 6: Self Joins

    9 lessons
    1. Intro to Self Joins
    2. Hierarchical Relationships
    3. Cleaning Self Join Data
    4. Self Joins w/ Subqueries
    5. Aggregating Self Join Data
    6. Case Study: Subscription Upgrades
    7. Descriptive Stats for Subscription Upgrades
    8. Comparing Rows w/ Self Joins
    9. Self Joins Quiz

  8. Chapter 7: Window Functions

    11 lessons
    1. Intro to Window Function
    2. Row Number vs. Rank vs. Dense_Rank
    3. Ranking with Partition By
    4. Filtering Window Functions with CTEs
    5. Filtering Window Functions with Qualify
    6. Running Totals & Averages
    7. Rolling 30 Day Average
    8. First & Last Values
    9. Case Study: Status Timestamps w/ Lead
    10. Alternative Solution w/ Lag
    11. Window Functions Quiz

  9. Chapter 8: Optimization

    11 lessons
    1. Intro to Optimization
    2. Reducing Rows w/ Limit
    3. Reducing Columns & Avoiding Select *
    4. Filtering Rows w/ WHERE
    5. Inner Joins vs. Left Joins
    6. Filtering in Joins vs. WHERE
    7. Avoiding Distinct
    8. Avoiding Sorting
    9. Wildcards at beginning of string
    10. EXISTS instead of COUNT(*)
    11. Optimization Quiz

  10. Chapter 9: Views & Temp Tables

    7 lessons
    1. Intro to Views and Temp Tables
    2. Last 1 Year Subscriptions View
    3. Unioned Subscriptions View
    4. Last 1 Year Subscriptions Temp Table
    5. Unioned Subscriptions Temp Table
    6. Views vs. Temp Tables
    7. Views and Temp Tables Quiz

  11. Chapter 10: Portfolio Projects

    6 lessons
    1. The Importance of Projects
    2. How to Add Projects to your Portfolio
    3. Project Quiz
    4. Payment Funnel Analysis (Project 1)
    5. Payment Funnel Bonus Solution
    6. Subscription Cancelation Analysis (Project 2)

  12. Bonus: Cheat Sheets, Interview Prep, & Resume Template

    6 lessons
    1. Tech & Data Resume Template
    2. Data Analytics Project Ideas
    3. Portfolio Project Outline
    4. Live SQL Coding Interview Cheat Sheet
    5. SQL Cheat Sheet
    6. How to Build a Data Analytics Portfolio

  13. Conclusion

    2 lessons
    1. Wrap up & Next Steps
    2. Demographic Survey

BLACK FRIDAY DEALS⚡

00

DAYS

00

HOURS

00

MINS

00

SECS

Beginner SQL Course

$87

40% OFF!

Join 25k+ Students

This course is perfect for newbies who are ready to take an easy step in their data journey! 

BUY NOW!

Intermediate SQL Course

$647

Get $150 off!

Move from beginner SELECT * queries to mastering window functions, CTEs, subqueries, and self joins, views, and more-- the exact skills that separate dabblers from professionals.

BUY NOW!

Full BDE Bundle

$1197

20% OFF!

From Newbie to Job-Ready!🎉

Beginner + Intermediate SQL Courses

Brand New Interview prep course

Resume, LinkedIn, & Portfolio Reviews

Access to Discord + Events

BUY NOW!