ACID Properties
Atomicity, consistency, isolation, durability.
Normalization
When to normalize vs denormalize.
Indexing Strategies
B-tree, hash, composite indexes.
Query Optimization
EXPLAIN, indexes, query rewriting.
Database Sharding
Horizontal partitioning strategies.
Replication
Master-slave, multi-master replication.
CAP Theorem
Consistency, availability, partition tolerance.
SQL vs NoSQL
Choosing the right database.