Your ultimate structured journey to SQL expertise—from foundational concepts to advanced techniques. Hands-on examples, exercises, and MySQL-ready scripts in every file.
- Logical Progression: Build skills step-by-step.
- Practical & Clear: Explanations, code, outputs, and challenges.
- Real-World Ready: Best practices and scenarios.
- Instant Practice: Copy-paste and run.
| Topic | File |
|---|---|
| Data Types | SQL_Data_Types.sql |
| Table Operations | SQL_Tables_Operations.sql |
| Constraints | SQL_Constraints.sql |
| Topic | File |
|---|---|
| INSERT | SQL_INSERT_Operations.sql |
| SELECT | SQL_SELECT_Operations.sql |
| UPDATE | SQL_UPDATE_Operations.sql |
| DELETE | SQL_DELETE_Operations.sql |
| Sorting & LIMIT | SQL_Sorting_and_Limits.sql |
| Topic | File |
|---|---|
| Conditional Logic | SQL_Conditional_Logic.sql |
| Aggregations | SQL_Aggregations_Operations.sql |
| Joins | SQL_Joins_Operations.sql |
| Subqueries | SQL_Subqueries.sql |
| Set Operations | SQL_Set_Operations.sql |
| CTEs & Recursive Queries | SQL_CTEs_and_Recursive_Queries.sql |
| Window Functions | SQL_Functions_and_Window_Functions.sql |
| Topic | File |
|---|---|
| Views | SQL_Views_Operations.sql |
| Indexing | SQL_Indexing.sql |
| Stored Procedures | SQL_Stored_Procedures.sql |
| Triggers | SQL_Triggers.sql |
| Cursors | SQL_Cursors.sql |
| Topic | File |
|---|---|
| Transaction Control (TCL) | SQL_Transaction_Control_Language.sql |
| GRANT | SQL_GRANT_Operations.sql |
| REVOKE | SQL_REVOKE_Operations.sql |
| Topic | File |
|---|---|
| Partitioning | SQL_Partitioning.sql |
- Clone the repo.
- Navigate folders.
- Run .sql files in MySQL.
Contributions welcome! ⭐ if useful.