A collection of practical SQL exercises with real-world schemas, questions, and solutions for hands-on learning.
SQL-exercise is a curated collection of SQL practice problems with complete database schemas, questions, and solutions. It helps developers improve their SQL query skills through realistic exercises based on both educational resources and practical real-world scenarios. The project provides structured learning materials that bridge theoretical knowledge and practical application.
Database developers, data analysts, and students looking to practice SQL with realistic problems and verified solutions. It's particularly useful for those preparing for technical interviews or seeking to strengthen their practical SQL skills.
Developers choose SQL-exercise because it offers immediately usable practice materials with complete schemas and solutions, saving time compared to creating exercises from scratch. The combination of established educational problems and original practical scenarios provides balanced learning coverage.
Practice with "Real" SQL Problems
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Includes schema diagrams and build scripts that mimic practical data structures, as shown in the repository structure with files like *_schema_figure.png and *_build_schema.sql.
Each exercise has SQL solutions from both Wikibook and the author, providing immediate feedback and learning opportunities, as mentioned in the introduction.
Problems range from foundational to advanced, with exercises 1-8 from educational resources and 9-10 from practical scenarios, offering balanced learning coverage.
Every exercise folder contains all necessary files—schema figures, build scripts, and question/solution SQL files—making setup straightforward without external dependencies.
No online platform or interactive elements; users must manually set up databases to run queries, which can be cumbersome compared to web-based practice tools.
Exercises use standard SQL without covering database-specific syntax or optimizations, which might not prepare users for real-world system nuances or advanced features.
The README is minimal, lacking detailed explanations of concepts or guidance on approaching exercises, assuming prior SQL knowledge and offering limited educational context.