From SELECT to Complex Joins
I documented every step of my SQL learning process. It started with simple SELECT statements and WHERE clauses, then naturally progressed into aggregations using GROUP BY and HAVING.
Advanced Querying Techniques
The real power of SQL unlocked when I mastered JOINS (Inner, Left, Right, and Self Joins). I then pushed further into Window Functions (OVER) and various types of Subqueries, including Scalar and Correlated Subqueries.
Practical Problem Solving
The repository contains dozens of practice queries and edge-case explorations, acting as a personal knowledge base for optimizing database queries.