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.

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.