Beginner · 5 LESSONS

Learn SQL

Learn to query educational data with SELECT, filters, sorting, aggregation and joins using SQLite-compatible examples.

No SQL experience required. Use a disposable SQLite database for the examples, never a production database.

Your learning path

1
Tables and your first SELECT
Create a small practice table and ask for specific columns without changing stored data.
About 9 minutes
2
Filter rows with WHERE
Use comparisons and boolean conditions to return only the rows relevant to a question.
About 8 minutes
3
Sort and limit results
Use ORDER BY and LIMIT with deterministic tie-breakers to select the top results.
About 7 minutes
4
Summarize data with aggregates
Count rows, calculate an average and group records into meaningful summaries.
About 9 minutes
5
Join tables for a study dashboard
Connect related tables, preserve unmatched rows and build a small revision-time report.
About 12 minutes