This repository brings together all of my work in SQL, serving as:
- 🧠 Proof of language proficiency,
- 📚 An open and adaptable educational resource for all levels,
- 🔍 A wide-ranging exploration ground for the SQL language.
The aim is to offer a complete and evolving learning journey, from basic SELECT queries to advanced topics like relational modeling, views, subqueries, CTEs, and complex joins.
Some of these materials are already used in real classrooms (BTS students in France).
The content is therefore:
- Fun and progressive, especially the practice exercises based on games or mysteries (e.g. SQL Murder Mystery),
- Modular and reusable, ideal for educators and trainers,
- Accessible for all profiles: beginners, self-learners, or aspiring data analysts.
- https://www.coursera.org/learn/sql-data-science?specialization=ibm-data-science
- https://dquenton.forge.apps.education.fr/nsi-terminale-specialite/BaseDeDonnees/BaseDeDonnees00/
- https://www.lyceum.fr/tg/nsi/2-bases-de-donnees/
- https://github.com/kansiris/SQL-interview-questions
- https://leetcode.com/studyplan/top-sql-50/
- https://mystery.knightlab.com/
- https://www.kaggle.com/datasets/johnp47/sql-murder-mystery-database/
- https://qkzk.xyz/docs/nsi/cours_terminale/bdd/murder_mystery/
All illustrations were generated using ChatGPT-4.
PRs welcome if you want to:
- Add new datasets
- Improve exercises or explanations
- Translate sections