π Table of Contents
Chapter 1: Environment Setup
Install MySQL 8, configure client tools, create your first database
WinGet MySQL Install
Use Oracle.MySQL to install MySQL on Windows and verify the package ID
Chapter 2: Basic Queries
SELECT statements, WHERE conditions, sorting & pagination
Chapter 3: Data Manipulation
INSERT, UPDATE, DELETE & batch operations
Chapter 4: Table Design
Data types, constraints, primary/foreign keys & ALTER TABLE
Chapter 5: Joins
INNER JOIN, LEFT JOIN, subqueries & UNION
Chapter 6: Aggregation
GROUP BY, aggregate functions & window functions
Chapter 7: Advanced Features
Index optimization, views, transactions & stored procedures
π SQL Topics
MySQL 8: ROW_NUMBER ranking by SUM
Solve row_number() over (partition by ... order by sum(...)): aggregate with GROUP BY first, then use a window function for Top N per group.
β¨ Learning Features
Comparative Learning
Cross-referencing PostgreSQL/SQLite to understand SQL standard vs dialect differences
Code-Driven
Runnable SQL examples for every concept, ready to use immediately
Practice-Oriented
From single-table queries to complex reports, covering real-world business scenarios
Performance Optimization
Index design, execution plan analysis, writing efficient SQL