π Table of Contents
7 Chapters
π οΈ
Completed
Chapter 1: Environment Setup
Install MySQL 8, configure client tools, create your first database
MySQL 8
Workbench
CLI
Read Chapter
π
Completed
Chapter 2: Basic Queries
SELECT statements, WHERE conditions, sorting & pagination
SELECT
WHERE
ORDER BY
Read Chapter
βοΈ
Completed
Chapter 3: Data Manipulation
INSERT, UPDATE, DELETE & batch operations
INSERT
UPDATE
DELETE
Read Chapter
π
Completed
Chapter 4: Table Design
Data types, constraints, primary/foreign keys & ALTER TABLE
CREATE TABLE
Constraints
Foreign Keys
Read Chapter
π
Completed
Chapter 5: Joins
INNER JOIN, LEFT JOIN, subqueries & UNION
JOIN
Subqueries
UNION
Read Chapter
π
Completed
Chapter 6: Aggregation
GROUP BY, aggregate functions & window functions
GROUP BY
SUM/AVG
Window Functions
Read Chapter
β‘
Completed
Chapter 7: Advanced Features
Index optimization, views, transactions & stored procedures
Indexes
Transactions
Stored Procedures
Read Chapter
β¨ 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