BUNDLE

From Newbie to Job-Ready!🎉

Beginner + Intermediate SQL Courses

Brand New Interview prep course

Resume, LinkedIn, & Portfolio Reviews

Access to Discord + Events

Join Now (pun intended)⚡️

Why the bundle? ⚡️

Level Up Beyond the Basics

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.

Build a Portfolio w/ Realistic Projects

Work through SaaS tech-style datasets and real business problems, creating projects you can actually showcase in interviews to prove you know more than textbook SQL.

Community & Mentorship from Jess

Join the Discord community to meet other analysts just like you! Ask questions any time and receive personal responses from Jess. (really, I'll help you job search, negotiate, and get that job!)

Students love the courses...

Video Poster Image

Who This Is For ⚡️

You might be here because:
  • You can write basic queries (SELECT, WHERE, simple joins), but when companies test you on window functions, CTEs, or optimization, you freeze.
  • You’ve done toy exercises, but you don’t have a project portfolio that proves you can solve real business problems.
  • You trust tutorials, but feel stuck in tutorial-mode. You don’t know how to tie your SQL knowledge to REAL product metrics or business models.

In short: you want to level up from a “knows enough to survive” to someone who’s undeniably competent in data analytics, SQL, and technical interviews.

What You'll Become 

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 Jess in the course Discord. 

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!

What's in the courses? 

Step 2!

  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!

  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
Get Access Now ⚡️

"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

After the courses you'll...

Become Interview-Ready, Not Just SQL-Fluent

Move beyond basic syntax. Be able to tackle window functions, subqueries, and real business problems in your interviews.

Build Portfolio Projects That Actually Impress

Work on realistic SaaS projects (funnel analysis, subscription cancelation) you can showcase to hiring managers.

Write Cleaner, Faster, Smarter SQL

Learn performance best practices, optimization tricks, and real patterns so your queries scale beyond toy datasets.

Complete Bundle

Become Job-Ready!🎉

Learn how to be the Data Analyst hiring managers are looking for. And pass those live coding inverviews!

Investment

$1197

Installments Available

  • Beginner + Intermediate SQL
  • Brand New Interview prep course
  • Resume, LinkedIn, & Portfolio Review
  • Access to Discord + Events
Buy Now ⚡️

FAQs ⚡️

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

Start TODAY!

Ready to kick off your SQL journey with confidence, community, and momentum? Enroll now and get started.

Get Access Now ⚡️