Database Internals
Under-the-hood mechanics — storage engines, write-ahead logs, LSM trees, B-trees, compaction, and the internal machinery that makes databases fast and reliable.
Indexing
Master database indexing — B-tree indexes, LSM trees & SSTables, composite indexes, partial indexes, and covering indexes. Understand the trade-offs that make queries fast.
B-Tree IndexesLSM Trees & SSTablesComposite IndexesPartial & Covering Indexes
Replication
Master data replication strategies — leader-follower, multi-leader, and leaderless replication. Understand replication lag, read-your-writes consistency, and how to keep data in sync across distributed nodes.
Leader-Follower ReplicationMulti-Leader ReplicationLeaderless ReplicationReplication Lag & Read-Your-Writes
Advanced Data Structures
Understand specialized databases — time-series databases for metrics and IoT, and vector databases for AI-powered similarity search. Learn why general-purpose databases aren't always enough.
Time-Series DatabasesVector DatabasesSimilarity Search & ANNWorkload-Driven Design