Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Step 2: Big SQL Energy⚡️ Beginner Essentials
Chapter 1: Intro & The Basics
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
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
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
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
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 👀
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! 🧠
2: Case Study Visualizing Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock