Step 2: Big SQL Energy⚡️ Beginner Essentials

Take all 31 lessons for $0 💰

$147

Big SQL Energy Beginner ⚡️

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

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.

All the lessons you get for FREE ⬇️

Chapter 1: Intro & The Basics

Available in days

days after you enroll

0: Intro & Setup (7:11)
1: Limit & Top (4:23)
2: Data Types & Cast (12:10)
3: String Manipulation (11:07)
4: Arithmetic Operators (10:56)

Chapter 2: Filtering Datasets & Wildcards

Available in days

days after you enroll

1: Filtering w/ WHERE (7:17)
2: Boolean Logical Operators (7:39)
3: Between & NOT Between (5:22)
4: IN & NOT IN (5:41)
5: Is Null, If Null, & Is Not Null (6:23)
6: Wildcards (8:48)
7: Like vs. Ilike & Wildcard Variations (5:44)

Chapter 3: Functions, Dates, & Grouping

Available in days

days after you enroll

1: Aggregate Functions (16:53)
2: Count(*) vs. Count(column) (8:52)
3: Current Date & Time (6:42)
4: Basic Date Functions (8:21)
5: DateDiff() (16:46)
6: Date_Add() (13:32)
7: Date_Trunc() (7:48)
8: Group By & Aggregate Functions (15:13)
9: Having (vs. Group By) (9:59)

Chapter 4: Bridging the Gap to Intermediate SQL

Available in days

days after you enroll

1: Coalesce & Isnull() (13:57)
2: Case & Categorizing Data (20:53)
3: Data Dictionaries (10:51)
4: Data Models & Fact vs. Dimension Tables (11:15)
5: Inner Joins (20:54)

Chapter 5: Case Studies & Wrap Up

Available in days

days after you enroll

1: Case Study Calculate a Percent in SQL (15:41)
2: Case Study Visualizing Data (14:52)
3: Next Steps & Finding Data to Practice (8:02)
Enroll in Intermediate Course

Intermediate Course Sneak Preview 👀

Available in days

days after you enroll

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