SQL Tutorial for Data Scientists & Data Analysts
Learn enough SQL to ace FAANG SQL interviews. No coding experience necessary.
Basic SQL
Lesson 101
TUTORIAL INTRO 👋
Learn SQL. Interview Well. Get $$$.
Start Now
Lesson 102
SQL SELECT 🔦
Learn to output data with SELECT.
Start Now
Lesson 103
SQL WHERE 📍
Select rows based on a condition.
Start Now
Lesson 104
AND, OR, NOT ❌
Filter data on multiple conditions.
Start Now
Lesson 105
SQL BETWEEN 🖖
Filter based on a range of values.
Start Now
Lesson 106
SQL IN 🔎
Use IN instead of multiple OR conditions.
Start Now
Lesson 107
SQL LIKE ❤️
Use patterns to filter strings.
Start Now
Lesson 108
FILTERING REVIEW 🔁
Review the different ways to filter data.
Start Now
Lesson 109
SQL ORDER BY ↕️
Learn how to sort data in SQL.
Start Now
Intermediate SQL
Lesson 201
INTERMEDIATE SQL 😎
Buckle up: shit's about to get real.
Start Now
Lesson 202
SUM, AVG, COUNT ⚙️
Overview of aggregate functions.
Start Now
Lesson 203
SQL GROUP BY 📊
Analyze data, by category.
Start Now
Lesson 204
SQL HAVING 🤏
Filter on groups with HAVING.
Start Now
Lesson 205
SQL DISTINCT ⭐
Remove duplicates with DISTINCT.
Start Now
Lesson 206
SQL ARITHMETIC 🔢
Do math with +, *, and %.
Start Now
Lesson 207
MATH FUNCTIONS 📈
Use ABS(), CEIL(), FLOOR(), and more!
Start Now
Lesson 208
SQL DIVISION ➗
Divide & round numbers the right way.
Start Now
Lesson 209
SQL NULL 🚫
Find and fix pesky NULLs.
Start Now
Lesson 210
SQL CASE 💼
Catch a CASE.
Start Now
Lesson 211
SQL JOINS 🤝
Analyze two tables in one go.
Start Now
Lesson 212
DATE FUNCTIONS 📅
Learn to handle dates and timestamps.
Start Now
Advanced SQL
Lesson 301
ADVANCED INTRO 🥵
Let's go from good to great at SQL.
Start Now
Lesson 302
CTE vs. SUBQUERY 🥊
Use temp tables to write cleaner SQL.
Start Now
Lesson 303
WINDOW FUNCTION🪟
Use aggregate functions on a window.
Start Now
Lesson 304
SQL RANKING 🥇
Learn to rank rows, and break ties.
Start Now
Lesson 305
SQL LEAD LAG 🐢
Learn to use LEAD() and LAG().
Start Now
Lesson 306
SQL SELF-JOINS 🤝
Join a table with itself to get pairs.
Start Now
Lesson 307
SQL UNION 🙏
Combine tables without JOINs.
Start Now
Lesson 308
WRITE CLEAN SQL 🧼
Best practices to write maintainable SQL.
Start Now
Lesson 309
EXECUTION ORDER ↕️
A quintessential SQL interview topic.
Start Now
Lesson 310
SQL PIVOTING 🔨
Excel's PIVOT function but in SQL.
Start Now
Lesson 311
STRING FUNCTIONS 🔤
Use string functions to clean text data.
Start Now
Lesson 312
INSTACART SQL CASE 🥕
Find business trends in Instacart data!
Start Now