Series · 4 parts
Databases under the hood
What production databases actually do: how a query runs, indexes, isolation levels, MVCC, locks, pooling, replication, sharding, migrations, backups, analytics stores and distributed SQL, each with the real incidents behind it.
- Parts
- 4
- Free
- 1
- Level
- Beginner → Senior
- 01Databases for System Design Interviews
- 02Database Indexes in Practice: Clustered vs Secondary, Composite, Covering, and Why Your Index Is Ignored
- 03Transaction Isolation Levels Explained: Dirty Reads, Lost Updates, Write Skew and What Postgres and MySQL Really Do
- 04Sharding a Relational Database: Shard Keys, Routing, IDs, Hot Shards and Resharding