Welcome to my structured SQL learning journey! This repository is divided into Beginner, Intermediate, and Advanced levels, followed by Project-based applications. Each topic includes hands-on SQL scripts, examples, and reference notes to deepen your understanding.
| No. | Topic | File/Folder |
|---|---|---|
| 1 | Introduction to SQL | beginner/01_intro_to_sql.sql |
| 2 | Setup Your Environment | beginner/02_setup_environment.md |
| 3 | Query Data (SELECT) | beginner/03_select_queries.sql |
| 4 | DDL Commands | beginner/04_ddl_commands.sql |
| 5 | DML Commands | beginner/05_dml_commands.sql |
| No. | Topic | File/Folder |
|---|---|---|
| 1 | Filtering Data | intermediate/01_filtering_data.sql |
| 2 | SQL Joins (Basics) | intermediate/02_joins_basics.sql |
| 3 | SQL Joins (Advanced) | intermediate/03_joins_advanced.sql |
| 4 | Set Operators | intermediate/04_set_operators.sql |
| 5 | SQL Functions | intermediate/05_sql_functions/ |
| 6 | CASE Statement | intermediate/06_case_statement.sql |
| 7 | Aggregate Functions | intermediate/07_aggregate_functions.sql |
| 8 | Window Functions | intermediate/08_window_functions/ |
| No. | Topic | File/Folder |
|---|---|---|
| 1 | Advanced SQL Techniques | advanced/01_advanced_techniques.sql |
| 2 | Subqueries | advanced/02_subqueries.sql |
| 3 | Common Table Expressions (CTE) | advanced/03_cte.sql |
| 4 | Views | advanced/04_views.sql |
| 5 | CTAS and Temp Tables | advanced/05_ctas_temp_tables.sql |
| 6 | Compare Techniques | advanced/06_compare_advanced_techniques.md |
| 7 | Stored Procedures | advanced/07_stored_procedures.sql |
| 8 | Triggers | advanced/08_triggers.sql |
| 9 | Indexes | advanced/09_indexes.sql |
| 10 | Execution Plan | advanced/10_execution_plan.md |
| 11 | Partitions | advanced/11_partitions.sql |
| 12 | 30x Performance Tips | advanced/12_performance_tips.md |
| 13 | AI and SQL | advanced/13_ai_and_sql.md |
| No. | Project Title | File/Folder |
|---|---|---|
| 1 | SQL Data Warehouse | projects/01_sql_data_warehouse/ |
| 2 | Exploratory Data Analysis (EDA) Project | projects/02_eda_project.sql |
| 3 | Advanced Data Analytics Project | projects/03_advanced_analytics_project.sql |
- Clone this repository.
- Navigate to any level of interest.
- Open
.sqlfiles with any SQL client or code editor like VS Code. - Follow along with comments and queries.
- Practice, modify, and experiment!
- SQL (PostgreSQL / MySQL syntax)
- VS Code or DB tools like DBeaver
- Optional: Docker setup for local SQL testing
I’m currently mastering SQL as part of my journey to become a Data Engineer / AI Engineer / ML Engineer / Data Scientist. This repo documents my learning path.
Feel free to star ⭐ this repo if you find it helpful!