SQLiteracy · Basic course · free with account
Your first queries: SELECT, WHERE, ORDER BY, and reading a real schema.
Everything here runs against a real table: the world's airports, all seventy-something thousand of them. By the end you'll pull filtered, sorted slices out of any table you're handed, and read a schema panel without fear. Work in order; each module leans on the last. It's free with a Data Literacy account, and your progress syncs so it follows you to any device.
This course is free with a Data Literacy account, so your progress follows you anywhere.
Module 1 · ~12 min
Reading a table
Your first SELECT, and why nobody reads all the rows
Module 2 · ~15 min
Asking questions with WHERE
Filters turn a table into answers
Module 3 · ~12 min
Putting results in order
ORDER BY, and the difference between a list and a ranking
Module 4 · ~15 min
Reading the schema
A second table, and the truth about missing values
Finished the modules? Take the final exam: five fresh questions, no hints, and the SQLiteracy Basic badge when you pass them all.
Start the examWondering what you've actually learned? Review your skills across every course.
Data: OurAirports (public domain) and U.S. Bureau of Transportation Statistics, T-100 Segment (public domain). Refreshed monthly.