SQL
Beginner Practice Queries
Twenty graded exercises on SELECT, filtering, sorting and simple functions, each with a worked solution and the reason it is written that way.
Practical SQL
Graded practice queries from first SELECT to analytical reporting.
4 notes
Notes
SQL
Intermediate Practice: Joins and Aggregation
Fifteen exercises combining joins, grouping and having, each with the solution and a note on the trap it was designed to expose.
SQL
Advanced Practice: Subqueries, CTEs and Window Functions
Twelve harder exercises - correlated subqueries, recursive CTEs, ranking, running totals and top N per group - with solutions and the reasoning behind...
SQL
Realistic Scenarios: Analysis and Optimisation
Six end to end problems of the kind real work produces - a sales report, a retention table, a data quality audit, a duplicate cleanup and two optimisa...