Modern SQL

A personal project for learning SQL in depth — covering fundamentals, advanced queries, performance tuning, and real-world patterns.

Goals

• Build strong foundational SQL skills
• Explore advanced topics (window functions, CTEs, recursive queries, etc.)
• Practice query optimization and indexing strategies
• Work with real-world data modeling scenarios

Structure

01-fundamentals/        SELECT, WHERE, ORDER BY, LIMIT, INSERT, UPDATE, DELETE
02-joins/               INNER, LEFT, RIGHT, FULL, CROSS, self joins
03-aggregations/        GROUP BY, HAVING, COUNT, SUM, AVG, MIN, MAX
04-subqueries/          Scalar, correlated, EXISTS, IN, ANY, ALL
05-window-functions/    ROW_NUMBER, RANK, LEAD, LAG, PARTITION BY, frames
06-ctes/                Common Table Expressions, recursive CTEs
07-indexing-performance/ EXPLAIN, indexes, query plans, optimization
08-data-modeling/       Normalization, relationships, schema design
09-advanced-topics/     Transactions, views, stored procedures, triggers
practice/               Freeform exercises and challenges