MySQL
Keyword Tree (click to open each child page)
Overview (What is MySQL?)
Install & Tools (mysql, mysqld, client)
SQL Basics
DDL (CREATE/ALTER/DROP)
DML (SELECT/INSERT/UPDATE/DELETE)
DCL (GRANT/REVOKE)
TCL (COMMIT/ROLLBACK)
Data Types
String types
Numeric types
Date & Time types
JSON
Schema & Table Design
Normalization
Constraints (PK/FK/UNIQUE/CHECK)
Relationships (1-1, 1-N, N-N)
Indexing
B-Tree index
FULLTEXT index
Composite index
Joins & Query Patterns
INNER JOIN
LEFT JOIN
Subquery
CTE (WITH)
Transactions & Concurrency
ACID
Isolation Levels
Locking
Deadlock
Storage Engines
InnoDB
Charset & Collation (utf8mb4)
EXPLAIN & Query Optimization
Backup & Restore
mysqldump
Replication
Security (Users, Privileges)
Configuration (my.cnf)
Monitoring (slow log, metrics)