Skip to content

A work-in-progress open-source SQL practice project featuring a realistic sample database, sample data, and practical SQL exercises for hands-on learning and

Notifications You must be signed in to change notification settings

pvm-harshavardhan/sql-practice

Repository files navigation

SQL Practice Database

This is a work-in-progress open-source SQL practice project.

What This Project Will Include

  • 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.

Set Up the Database

  • Open your preferred MySQL client (e.g., MySQL Workbench, DBeaver, or MySQL command line).
  • Execute the SQL scripts in 000.sql to create the sql_practice database, define all the tables, and populate them with sample data.

Database Schema & ER Diagram

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.


🤝 Contributing, Collaboration & Feedback

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.


About

A work-in-progress open-source SQL practice project featuring a realistic sample database, sample data, and practical SQL exercises for hands-on learning and

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published