Learn SQL
A complete SQL course that starts from zero. You will learn how databases store data, how to ask questions with queries, and work your way up to joins, window functions, and the patterns used in real jobs.
Progress is saved in this browser. Accounts are coming later.
- Lessons available
- 62
- In the full course
- 62
- Beginner
Start from zero. No experience needed.
- Intermediate
Combine ideas to solve real problems.
- Advanced
The techniques used in professional work.
Course syllabus
All 62 lessons are available. Start anywhere, or follow the parts in order.
Part 1 · Beginner
SQL Fundamentals
What SQL is, how databases are organised, and how to read data with your first queries.
Part 2 · Beginner
Working With Data
Create tables and add, change, and remove the rows inside them.
Part 3 · Beginner
SQL Functions
Built-in functions for counting, totals, averages, text, and dates.
Part 4 · Intermediate
SQL Aggregation
Summarise many rows into groups and filter those groups.
Part 5 · Intermediate
SQL JOINs
Combine rows from two or more tables into one result.
Part 6 · Intermediate
Intermediate SQL
Queries inside queries, conditional logic, and combining result sets.
Part 7 · Advanced
Advanced SQL
Window functions, recursive queries, and the database features used in production systems.
Part 8 · Intermediate
SQL Interview Preparation
Questions and query challenges in the style used by technical interviews.
Keep going with SQL
Become a Better Programmer
Get new tutorials, coding challenges, and cheat sheets.