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 — Logging

Covers write-ahead logging and the redo/undo logging schemes that make crash recovery possible.

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 — Why Databases Exist

Traces the shift from file-based storage to DBMS, the problems that shift solved, and introduces OLTP vs OLAP and the CAP perspective.

3 — Joins

Compares inner, left, right, full, self, cross, anti, and semi joins and how each changes a query's result set.