Database Management Systems

A book-shaped table of contents for DBMS: relational foundations through SQL mastery, storage internals, transactions, distributed databases, NoSQL, and MAANG interview prep — cross-linking existing system-design/patterns notes instead of duplicating them.

1 — Transaction Fundamentals

Covers the transaction lifecycle, its states, and the atomicity guarantee that ties them together.

3 — Concurrency Problems

Covers the concurrency anomalies isolation levels exist to prevent — dirty reads, non-repeatable reads, phantom reads, lost updates, and write skew.

4 — Concurrency Control

Covers lock-based concurrency control — shared and exclusive locks, lock granularity, and intention locks.

5 — Two-Phase Locking

Covers basic, strict, and rigorous two-phase locking and the serializability guarantees each provides.