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 — Database Architecture

Covers the three-schema architecture (external, conceptual, internal), data independence, and the core components inside a DBMS.

3 — Database Models

Surveys the hierarchical, network, relational, object-oriented, object-relational, and NoSQL data models and how each represents data.

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.

3 — Joins

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