intermediate~10h

Fundamentals of Database Systems & Modern SQL

An exhaustive 10-part engineering curriculum covering ANSI-SPARC 3-schema architecture, data models (Relational, Document, Key-Value, Graph), relational algebra and procedural calculus, 1NF to BCNF normalization, advanced SQL window functions and recursive CTEs, slotted-page storage engines and B+ trees, Volcano iterator query processing and cost-based optimization, ACID transactions and MVCC, Write-Ahead Logging (WAL) and ARIES recovery, and distributed database sharding, 2PC, and CAP theorem.

Start reading

Posts in this series

1Part 1: Database Systems Overview & The ANSI-SPARC 3-Schema Architecture
2Part 2: Data Models: Relational, Document, Key-Value & Graph Databases
3Part 3: Relational Algebra: Selection, Projection, Joins & Set Operations
4Part 4: Database Normalization: From 1NF to BCNF and De-normalization Rules
5Part 5: Advanced SQL: Window Functions, Common Table Expressions & Recursion
6Part 6: Storage Engines: Slotted Pages, B+ Trees, Buffer Pools & Indexing
7Part 7: Query Execution Engines: Volcano Iterators & Cost-Based Optimization
8Part 8: Transactions: ACID Guarantees, Isolation Levels & MVCC Concurrency
9Part 9: Database Recovery: Write-Ahead Logging (WAL) & The ARIES Protocol
10Part 10: Distributed Databases: Partitioning, Sharding, 2PC & CAP Theorem