Thank you! 

Your free resource is on its way!

**One-Time Offer: Get 20% Off**

Build your first portfolio project! 🎉

From Newbie to Intermediate in Only 5 Hours!

  

SQL is the foundation of MOST technical, high-paying data science & analytics roles. Plus, you'll likely see it in interviews and might even have to code live... But don't worry, I'll teach you allllll the basics and help you build your first project in only a few hours.  All you have to do is commit now and say you're IN! After this course, you'll be more confident than ever, so don't doubt yourself ❤️

Full Beginner Course!

Join 25k+ Students

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

Get 20% Off Now ⚡️

Why this course? ⚡️

Jumpstart SQL Skills Quickly ⚡️

Learn foundational SQL in under 5 hours-- enough to start writing useful queries, feel confident, and move on to the intermediate level.

Real-World Learning & Modern Tools ⚡️

Get hands-on with the essentials: string and date manipulation, filtering, wildcards, joins, GROUP BY, aggregate functions, and more-- all in a modern data science notebook environment!

Build your 1st portfolio project ⚡️

At the end, you'll do your very first project combining multiple skills and learn one of the most important ones: working through challenges until you get an answer and succeed!

"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

Video Poster Image

Does this sound like you? ⚡️

You...

want a high-paying tech job (w/ potential remote work) but don't want to go back to school or expensive bootcamps.

You...

want to be a data analyst but have NO IDEA where to start and feel overwhelmed by all the noise.

You...

already have experience as an analyst or semi-technical corporate role and want to level up to a more senior-level position.

You...

 

want to make changes FAST, and you're dedicated & determined!

What's in this course? ⚡️

Chapter 1: Intro & The Basics

Chapter 2: Filtering Datasets & Wildcards

Chapter 3: Functions, Dates, & Grouping

Chapter 4: Bridging the Gap to Intermediate SQL

Chapter 5: Case Studies & Final Portfolio Project

Get 20% Off 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 😉

Video Poster Image

FAQs

Big SQL Energy⚡️ Beginner

Beginner Course that prepares you for the intermediate level in only 5 hours.

Add Code: BDE20 for 20% off

Learn the beginner skills used in most SQL queries in less than 5 hours! This will prepare you for the intermediate level to tackle more complex business problems. And at the end, you'll build your first big project!

What's Inside?

  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! 🧠