This is a work-in-progress open-source SQL practice project.
- Database schema: Tables for departments, employees, products, customers, orders, and more.
- Sample data: Realistic data for all tables.
- Practice queries: A variety of SQL exercises, from basic SELECTs to more advanced queries.
- Learning resource: A place to experiment, learn, and share SQL knowledge.
- Open your preferred MySQL client (e.g., MySQL Workbench, DBeaver, or MySQL command line).
- Execute the SQL scripts in
000.sqlto create thesql_practicedatabase, define all the tables, and populate them with sample data.
The detailed database schema and entity-relationship diagram are now available in DATABASE_SCHEMA.md.
Please refer to that file for a full description of tables, columns, relationships, and the ER diagram.
Your ideas and participation are welcome!
-
🐛 Report Issues:
Found a bug or have a suggestion? Open an issue and let's discuss it. -
🔧 Submit Pull Requests:
Have improvements, new queries, or documentation fixes? Fork the repo and submit a PR. -
❓ Ask Questions:
Stuck on a query or want to learn about a specific SQL topic? Start a discussion—your question might help others too! -
💡 Share Ideas:
Have ideas for new practice scenarios, additional tables, or database features? We'd love to hear them!
📋 For technical contribution guidelines and advanced schema ideas, see
DATABASE_SCHEMA.md.
⭐ Star this repo if you find it helpful!
Thank you for your interest and support! Every bit of feedback and contribution helps this project grow.