Intro to SQL
Learn to query a real dataset in SQL — 15 short lessons against the Chinook digital music store.
15 lessons 3 phases beginner
Get started
Signed in as your account.
why this workshop
who it's for.
Total beginners to SQL — you've never written a query and aren't sure what a table is yet.
what you'll build
what you walk away with.
- 01 Fluency in single-table SQL — projection, filter, sort, dedupe, pattern match.
- 02 Summarization queries with aggregates, GROUP BY, and HAVING.
- 03 Multi-table joins (INNER, LEFT) and subqueries to answer cross-table questions.
- 04 A capstone set of business-question queries against the full Chinook schema.
curriculum
15 lessons across 3 phases.
phase A · Reading data 7 lessons
- 01 Setup + first SELECT
- 02 Picking columns + aliases
- 03 WHERE filtering
- 04 NULL handling
- 05 ORDER BY + LIMIT
- 06 DISTINCT
- 07 Pattern matching with LIKE
phase B · Summarizing data 3 lessons
- 08 Aggregates
- 09 GROUP BY
- 10 HAVING
phase C · Combining + capstone 5 lessons
- 11 Two-table INNER JOIN
- 12 LEFT JOIN — finding what's missing
- 13 Multi-table JOIN
- 14 Subqueries
- 15 Capstone
prerequisites
what you need before you start.
- Terminal comfort
- You can cd into a directory, run commands, and edit a file in an editor.
- Node 22+ and pnpm
- Installed by the workshop entry skill if missing. No prior Node experience needed.
- SQLite CLI
- Preinstalled on macOS. One-line install on Linux/Windows; the workshop walks you through it.
start
how to start.
Once Claude Code is set up, tell it “set up the sql intro workshop” and it clones the project and queues the first lesson.
New here? The
getting-started guide
walks you through installing the lwc CLI and the Claude Code
plugin once — everything you need before that line works.