Course Map

Complete lessons in order to unlock the next ones.

🔍

Reading the Database

Learn to retrieve data with SELECT, FROM, and WHERE.

0/4
🎯
Your First Query
SELECT & FROM
30 XP
2 challenges
🔎
Filter Your Data
WHERE, AND, OR
🔒
🧩
IN, NOT, and NULL
IN, NOT IN, IS NULL, LIKE
🔒
✂️
Sort & Slice
ORDER BY, LIMIT, DISTINCT
🔒
📊

Counting & Grouping

Summarize data with COUNT, GROUP BY, CASE, and HAVING.

0/3
🔢
Count Everything
COUNT, GROUP BY
50 XP
3 challenges
🔀
Conditional Columns
CASE Statements
🔒
🎛️
Filter Groups
HAVING
🔒
🔗

Combining Tables

Join tables together and use subqueries.

0/3
🔗
Connect Tables
INNER JOIN
60 XP
2 challenges
⬅️
Keep All Rows
LEFT JOIN
🔒
🪆
Queries within Queries
Subqueries
🔒
☁️

BigQuery Basics🔒 Complete SQL track first

Transition to BigQuery with dates, arrays, and window functions.

0/3
☁️
Welcome to BigQuery
Standard SQL vs BigQuery
🔒
🪟
Window Functions
ROW_NUMBER, RANK, LAG
🔒
⚡
BigQuery Optimization
Partitioning, Cost & Best Practices
🔒