webdevsimplified/learn-sql — explained in plain English
Analysis updated 2026-07-24 · repo last pushed 2024-05-13
Practice writing SQL queries by solving twelve exercises that start simple and get progressively harder.
Learn how to connect multiple database tables using foreign keys by working with a record company database.
Check your SQL skills by comparing your answers against provided solutions in a separate folder.
Follow along with free video tutorials to learn SQL basics and then test yourself with hands-on exercises.
| webdevsimplified/learn-sql | facebookresearch/tensorcomprehensions | trystan-sa/claude-design-system-prompt | |
|---|---|---|---|
| Stars | 1,766 | 1,766 | 1,767 |
| Language | — | C++ | — |
| Last pushed | 2024-05-13 | 2023-04-28 | — |
| Maintenance | Dormant | Dormant | — |
| Setup difficulty | easy | hard | easy |
| Complexity | 1/5 | 5/5 | 1/5 |
| Audience | general | researcher | designer |
Figures from each repo's GitHub metadata at analysis time.
Requires installing MySQL Workbench and running a provided SQL setup file to create the practice database.
Learn SQL is a hands-on practice set designed to help beginners learn how to write SQL database queries. Instead of just reading about database concepts, you work through twelve specific exercises that test and build your ability to retrieve, organize, and manipulate data. The project pairs with a free one-hour video tutorial that covers all the basics of SQL. After watching the video, you use a free tool called MySQL Workbench to run a provided setup file that creates a practice database about record companies, bands, albums, and songs. You then work through the exercises, trying to write the correct database commands to do things like find the oldest album, calculate the average length of songs, or find the longest track on each album. Solutions are provided in a separate folder so you can check your work, and a second video walks through all the answers. This is built for people who are just starting to learn how databases work and want a structured way to practice what they have learned. A product manager learning to pull their own data, a founder who wants to understand what their engineering team is doing, or a beginner developer adding database skills to their toolkit would all find this useful. The exercises start simple and gradually get harder, ending with multi-step queries that require chaining several database tables together. One notable thing about this project is its focus on practical application rather than theory. The exercises are designed to mimic the kinds of questions you would actually need to answer when working with a real database, like updating a missing value or deleting a record without breaking related data. The database structure uses foreign keys, which means the exercises teach you how different tables connect to each other, a concept that is essential for working with any real-world database.
A beginner-friendly SQL practice set with twelve hands-on exercises that teach you how to write real database queries, paired with free video tutorials and a ready-to-use practice database.
Dormant — no commits in 2+ years (last push 2024-05-13).
No license information is provided in the explanation, so usage rights are unclear.
Setup difficulty is rated easy, with roughly 5min to a first successful run.
Mainly general.
This repo across BitVibe Labs
Don't trust strangers blindly. Verify against the repo.