Step 3: Big SQL Energy⚡️ Intermediate
Get Job-Ready!🎉
SELECT * is NOT enough to ace your Data Analyst interviews. Become the Data Analyst hiring managers are looking for, and approach interviews for your dream data job with confidence. I'll help you build a portfolio, and you can join the exclusive Big Data Energy Discord community for support.
Join Now (pun intended)⚡️Why this course? ⚡️
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 this course...
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.
- You want to FINALLY GET THE JOB 👏🏼
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 400K followers on LinkedIn, Instagram, YouTube, and the Big Data Energy Newsletter. And over 60K students on LinkedIn Learning!
What's in this course?
Chapter 0 — Course Intro & Setup
Chapter 1 — Joins
Chapter 2 — CASE & Conditional Logic
Chapter 3 — Common Table Expressions (CTEs)
Chapter 4 — Set Operations
Chapter 5 — Subqueries
Chapter 6 — Self Joins
Chapter 7 — Window Functions
Chapter 8 — Optimization
Chapter 9 — Views & Temp Tables
Chapter 10 — Portfolio Projects
"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
After this course 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.
Step 3: Big SQL Energy⚡️ Intermediate
Become Job-Ready!🎉
Learn how to be the Data Analyst hiring managers are looking for. And pass those live coding inverviews!
Investment
$797
Installments Available
- Full access to 10 hands-on chapters and deep lessons
- 2 portfolio projects you can use in interviews
- Realistic SaaS data models + business problems
- Discord community + monthly events & mentorship
- Interview prep assets: cheat sheets, resume templates, project outlines
Modern tech stack: HEX + Snowflake ❄️
FAQs ⚡️
Email [email protected] if you have any questions! I'll actually respond
Do I need to complete the beginner course first?
What if my SQL dialect (Redshift, PostgreSQL, BigQuery, etc.) is slightly different?
How long does it take to finish the course?
Do you offer international pricing?
Can I get help if I get stuck?
Do I need intermediate SQL if I already know beginner?
Start TODAY!
Ready to kick off your SQL journey with confidence, community, and momentum? Enroll now and get started.
Get Access Now ⚡️