Four paths, three datasets and 28 exercises. Start at your level. Hints, answers and checks are available inside the playground; drafts and solved progress stay in this browser.
Learn selection, filtering, ordering and aggregation with the sample shop. Work through these in order, then return to any exercise for revision.
Combine tables, handle missing values and build reports. Finish the remaining shop exercises with hints and local answer checks.
Find shortages and missing stock, then calculate running balances with a window function.
Measure daily activity, extract JSON properties, find inactive users and rank event types within each country.
Checks compare results on a clean fixture, including row order. Passing does not prove your query works for every dataset. Experiment with edge cases such as NULLs and missing relationships.
Continue with Python SQLite lessons, or start with the installation and first-query guide.
Clear answers to common questions about this topic.
Begin with SELECT, WHERE, ORDER BY and LIMIT on a small sample database. Add INSERT, UPDATE, joins, grouping and indexes once you can predict each query’s result. Use the learning paths and practice exercises here to run queries and inspect feedback, then consult the SQLite reference for precise behavior and retry with your own data.