Library catalogue
Create a small books database and answer ten questions about authors, years and genres.
Ask questions of databases: query, combine, summarise and change data with confidence.
You have reached the end of the beginner stages. Prove what you learned with a project.
You have reached the end of the intermediate stages. Prove what you learned with a project.
You have reached the end of the advanced stages. Prove what you learned with a project.
Create a small books database and answer ten questions about authors, years and genres.
From a sample orders table, report revenue by month, product and customer.
Model companies, jobs and applications with keys and constraints, then load sample data.
Rank customers by spending and show each customer's change from last month.
Generate a million rows, find a slow query with EXPLAIN and fix it with an index.
Answer five business questions from a public dataset in a cloud warehouse.
The same roadmap as a reading list: every stage, what each topic covers, and which ones are optional.
Tables, rows, columns and keys, and why data is split across tables.
Install PostgreSQL or start with SQLite, which needs no server.
Pick columns, filter rows and sort results.
Short exercises in the browser that build the habit.
Combine rows from related tables with inner and outer joins.
Count, sum and average by group, and filter groups with HAVING.
Missing values behave differently. Learn the rules to avoid wrong totals.
Clean text, extract parts of dates and format results.
Change data safely, always with a WHERE clause you have tested.
Primary keys, foreign keys and checks that stop bad data.
Organise tables so each fact is stored once.
Group changes so they all succeed or all fail together.
Break complex questions into readable steps with WITH.
Rankings, running totals and comparisons with previous rows.
Add if-then logic inside a query to group or label rows.
Save a query as a virtual table others can reuse.
Make lookups fast and understand what an index costs.
Use EXPLAIN to see how the database runs your query.
Never paste user input into SQL. Use parameters.
Give each user and app only the access it needs.
Query large datasets in cloud data warehouses.
A very common database for websites, with small syntax differences.
Microsoft's database, common in large organisations.
Run parameterised queries from Python or another language.
Almost every organisation stores data in databases. SQL lets you get answers yourself, and it appears in job posts for analysts, developers, marketers and product managers.
Start with PostgreSQL or SQLite. The core SQL is the same everywhere, and switching to MySQL or SQL Server later takes days, not months.
The basics take a few weeks. Joins, aggregates and window functions, which most jobs need, take a couple of months of practice.
© 2026 KamerLink. All rights reserved.