// the find
WebDevSimplified/Learn-SQL
Exercises for beginners to learn SQL
A companion exercise set for a Web Dev Simplified YouTube SQL tutorial, covering basic to intermediate MySQL queries against a music database (bands, albums, songs). Aimed squarely at beginners who just watched the video and want to practice. Not a standalone learning resource.
The exercise progression is sensible — DDL first, then SELECT, JOIN, aggregate functions, UPDATE, DELETE. Having expected output tables in the README lets learners self-check without running solutions. The dual-join problem (#12) is a genuine step up in difficulty that forces understanding rather than pattern-matching. Solutions are all provided so there's no dead end.
MySQL-only with MySQL Workbench assumed throughout; learners on Postgres or SQLite are left to figure out dialect differences themselves. The dataset is tiny (music industry demo data) so there's no exposure to performance considerations or NULL-heavy real-world schemas. No exercises covering subqueries, CTEs, window functions, or indexes — stops exactly where things get interesting. The repo hasn't been touched since mid-2024 and is essentially a static artifact tied to a video, not a maintained curriculum.