sql-practice

🗄️ SQL Practice

A structured and practical SQL learning and practice repository designed for beginners, students, self-learners, developers, data analysts, and anyone preparing for SQL interviews.

This repository takes you from SQL fundamentals to advanced concepts, with explanations, examples, practice problems, solutions, challenges, interview questions, and real-world projects.

🎯 Repository Goals

The goal of this repository is to provide a complete, hands-on SQL learning path that helps you:

🛠️ SQL Dialect

This repository primarily uses:

MySQL 8.0+

Examples and exercises are written using MySQL-compatible SQL syntax.

Some SQL features differ between MySQL, PostgreSQL, SQL Server, and other database systems. When relevant, those differences will be mentioned in the notes.

📚 Learning Roadmap

The repository is organized into progressive modules.

🟢 Beginner SQL

Module Topic
01 SQL Basics
02 Databases & Tables
03 INSERT, UPDATE & DELETE
04 SELECT
05 WHERE
06 ORDER BY
07 DISTINCT & LIMIT
08 Aggregate Functions
09 GROUP BY
10 HAVING

🟡 Intermediate SQL

Module Topic
11 JOINs
12 Subqueries
13 Set Operations
14 String Functions
15 Date & Time Functions
16 CASE Expressions
17 NULL Handling
18 Constraints
19 Primary & Foreign Keys
20 Views

🔴 Advanced SQL

Module Topic
21 Indexes
22 Common Table Expressions (CTEs)
23 Window Functions
24 Stored Procedures
25 Triggers
26 Transactions
27 Database Normalization

💼 Interview Preparation

Module Topic
28 SQL Interview Questions

📊 Real-World Projects

Module Project
29 SQL Projects

📁 Repository Structure

sql-practice/
│
├── README.md
├── LICENSE
├── CONTRIBUTING.md
├── CODE_OF_CONDUCT.md
├── .gitignore
│
├── 01_sql_basics/
├── 02_databases_and_tables/
├── 03_insert_update_delete/
├── 04_select/
├── 05_where/
├── 06_order_by/
├── 07_limit_distinct/
├── 08_aggregate_functions/
├── 09_group_by/
├── 10_having/
│
├── 11_joins/
├── 12_subqueries/
├── 13_set_operations/
├── 14_string_functions/
├── 15_date_functions/
├── 16_case/
├── 17_null_handling/
├── 18_constraints/
├── 19_keys/
├── 20_views/
│
├── 21_indexes/
├── 22_ctes/
├── 23_window_functions/
├── 24_stored_procedures/
├── 25_triggers/
├── 26_transactions/
├── 27_normalization/
│
├── 28_interview_questions/
│
└── 29_projects/

📂 Module Structure

Most learning modules follow the same structure:

01_sql_basics/
│
├── notes.md
├── examples.sql
├── practice.sql
├── solutions.sql
└── challenge.sql

📘 notes.md

Contains explanations of the topic, syntax, important concepts, and common mistakes.

💻 examples.sql

Contains commented SQL examples demonstrating the concepts.

📝 practice.sql

Contains exercises for practicing the topic.

✅ solutions.sql

Contains solutions to the practice exercises.

Try solving the questions yourself before looking at the solutions.

🚀 challenge.sql

Contains more challenging problems designed to improve SQL problem-solving skills.

📊 Practice Difficulty

Exercises are organized by difficulty.

🟢 Easy

Focuses on understanding basic syntax and individual concepts.

🟡 Medium

Combines multiple SQL concepts and requires more reasoning.

🔴 Hard

Requires advanced query logic and problem-solving.

🏆 Challenge

Interview-style or real-world problems designed to test your understanding.

🗃️ Practice Database

The repository will use realistic datasets throughout the learning process.

Example tables may include:

students
courses
employees
departments
customers
orders
products

Using consistent datasets makes it easier to practice increasingly advanced SQL concepts without constantly learning a new database structure.

📈 Learning Progress

Track your progress as you work through the repository.

Beginner

Intermediate

Advanced

Interview Preparation

Projects

🧠 What You Will Learn

By completing this repository, you will practice:

💻 Getting Started

1. Clone the Repository

git clone https://github.com/your-username/sql-practice.git

2. Navigate to the Repository

cd sql-practice

3. Install MySQL

Install MySQL 8.0 or later on your computer.

4. Open MySQL

You can use MySQL through:

5. Start Practicing

Navigate to any module:

01_sql_basics/

Read the notes, study the examples, solve the practice problems, and then check your answers against the solutions.

🧪 Recommended Learning Method

For the best results, follow this cycle:

Learn
  ↓
Read the Notes
  ↓
Study the Examples
  ↓
Write Queries Yourself
  ↓
Solve Practice Problems
  ↓
Check Solutions
  ↓
Attempt the Challenge
  ↓
Build Projects

Avoid simply copying the solutions.

The goal is to develop the ability to think in SQL and solve problems independently.

💼 SQL Interview Preparation

The repository will gradually include SQL interview questions covering:

The interview section will focus on both conceptual questions and practical query-writing problems.

📊 Projects

The project section will apply the concepts learned throughout the repository to realistic scenarios.

Planned projects include:

🎓 Student Database

Practice:

📚 Library Database

Practice:

🛒 E-commerce Database

Practice:

👨‍💼 Employee Database

Practice:

📈 Sales Analysis

Practice:

🌟 Repository Features

This repository aims to provide:

🤝 Contributing

Contributions are welcome!

If you find an error, have a useful SQL exercise, or want to improve the learning material, please read the Contributing Guidelines.

📜 Code of Conduct

Please read the Code of Conduct before contributing to this repository.

📄 License

This project is licensed under the MIT License.

See the LICENSE file for more information.

⭐ Support the Project

If you find this repository useful for learning SQL or preparing for interviews, consider giving it a ⭐ on GitHub.

Your support helps the project grow and encourages the creation of more learning resources.

👩‍💻 Author

Shreya Pathak

GitHub: @shreyaapaathakk

Learn SQL. Practice consistently. Solve real problems. Build projects.

This site is open source. Improve this page.