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.

2 — ACID Properties

Covers the four ACID properties — atomicity, consistency, isolation, durability — and what each guarantees.

3 — Concurrency Problems

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

5 — Two-Phase Locking

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