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.

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.

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.