Sharpen your SQL skills with this interactive playground!
This repository is designed for SQL enthusiasts, especially beginners and intermediates, to learn and practice essential SQL concepts. It provides a structured learning path with exercises, a sample database schema, and pre-populated data.
The Entity-Relationship Diagram.
What You'll Find:
- Well-Structured Database Schema: Explore a well-defined database schema representing real-world entities.
- Curated SQL Exercises: Practice a variety of SQL queries, including:
- Data Retrieval: JOINs, Subqueries, Window Functions
- Data Manipulation: INSERT, UPDATE, DELETE
- Data Analysis: Explore customer behavior, product trends, and more!
- Sample Data: Dive right in with pre-populated tables ready for your SQL queries.
Project Structure:
SQL_Playground/
├── ERD.png
├── schema.sql
├── operations-analysis.sql
├── README.md
└── HackerRank/
├── Easy/
│ └── easy.sql
├── Medium/
└── Hard/This structure clearly shows the files included in your project:
ERD.png: The Entity-Relationship Diagram.
schema.sql: The script for creating the database schema and inserting data.
operations-analysis.sql: The file containing your SQL exercises and data analysis queries.
HackerRank/: Contains subdirectories categorized by difficulty level for SQL challenges from HackerRank.
Easy/: Basic level questions, with solutions in `easy.sql`.
Medium/: Placeholder for medium-level SQL questions.
Hard/: Placeholder for advanced-level SQL questions.
README.md: The project's documentation file.
This structure is easy to understand and maintain. You can further organize the exercises by adding comments and separating different types of challenges into sections.
Get Started:
-
Clone the Repository:
git clone https://github.com/coder-akram-khan/SQL_Playground.git
-
Create the Database: Execute the schema.sql script to create the database tables.
-
Explore & Experiment: Run the queries in operations-analysis.sql, solve HackerRank challenges, and craft your own!
Contribute: Feel free to add new exercises, improve existing ones, or share your SQL knowledge!
Join the SQL Playground Community!
This repository is a collaborative space for learning and growing together. Let's share our SQL expertise and unlock the power of data analysis!
Visit https://github.com/coder-akram-khan/SQL_Playground to begin your SQL journey!