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

BLACK FRIDAY DEALSāš”

00

DAYS

00

HOURS

00

MINS

00

SECS

Beginner SQL Course āš”ļø

$87

40% OFF from $147

Perfect for newbies who are ready toĀ take a next step in theirĀ data journey but not ready to fully commit.

BUY NOW!

Intermediate SQL Course āš”ļø

$647

$150 off from $797

Perfect for those who know the basics and are ready to master window functions, CTEs, subqueries, self joins, views,Ā & moreĀ by building 2 complete real-life projectsĀ & a portfolio for their job search.

BUY NOW!

Full BDE Bundle āš”ļø

$1197

20% OFF from $1497

Complete Path From Newbie to Data Job w/ ultimate support from me!šŸŽ‰

Perfect for those who are ready to go ALL IN on their data career in 2026. Includes:

- Beginner + Intermediate SQL Courses

- Brand NewĀ SQL Interview Crash Course

- Personalized Resume, LinkedIn, & Portfolio Reviews

- Access to Discord + Events

BUY NOW!

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:

A Peek 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 from $147

Perfect for newbies who are ready toĀ take a next step in theirĀ data journey but not ready to fully commit.

BUY NOW!

Intermediate SQL Course āš”ļø

$647

$150 off from $797

Perfect for those who know the basics and are ready to master window functions, CTEs, subqueries, self joins, views,Ā & moreĀ by building 2 complete real-life projectsĀ & a portfolio for their job search.

BUY NOW!

Full BDE Bundle āš”ļø

$1197

20% OFF from $1497

Complete Path From Newbie to Data Job w/ ultimate support from me!šŸŽ‰

Perfect for those who are ready to go ALL IN on their data career in 2026. Includes:

- Beginner + Intermediate SQL Courses

- Brand NewĀ SQL Interview Crash Course

- Personalized Resume, LinkedIn, & Portfolio Reviews

- Access to Discord + Events

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