🗄️ Database Architecture & Storage Engines: Sub-Curriculum Index
Welcome to the Database Architecture & Storage Engines curriculum. This track covers relational and non-relational database design, ACID guarantees, concurrency and lock contention, isolation levels, sharding, replication topologies, and deep-dive comparisons of modern database engines.
Every guide in this series strictly follows a two-part learning format:
- ⚡ Quick Dive: Syntax cheat sheets, isolation level comparison matrices, and engine feature scorecards.
- 📖 Extended Guide: Deep internal architectures (B-Trees, LSM-Trees, WAL, Raft consensus), query optimization, and scalability patterns.
📚 Complete Curriculum Roadmap
Part 1: Theory, Transactions & Concurrency
| # | Guide | Primary Topics Covered |
|---|---|---|
| 01 | Guide to Database Models | Relational, Document, Key-Value, Columnar, Graph, Time-Series, and Vector databases. |
| 02 | SQL vs. NoSQL Architecture | Structured schemas vs. dynamic documents, ACID vs. BASE, and scaling paradigms. |
| 03 | Relational DB Design & Normalization | ER diagrams, 1NF, 2NF, 3NF, BCNF, denormalization, primary/foreign keys, and composite indexes. |
| 04 | SQL Language Components | DDL, DML, DQL, DCL, TCL commands, CTEs, Window functions, and indexing strategies. |
| 05 | ACID Properties & Transactions | Atomicity, Consistency, Isolation, Durability, Write-Ahead Logs (WAL), and Two-Phase Commit (2PC). |
| 06 | Transactions, Concurrency & Locking | Dirty reads, non-repeatable reads, phantom reads, and concurrency phenomena. |
| 07 | Database Locks & Isolation Levels | Read Uncommitted, Read Committed, Repeatable Read, Serializable, Snapshot Isolation, and MVCC. |
| 08 | Deadlocks Detection & Prevention | Wait-for graphs, deadlock detection timeouts, lock ordering conventions, and optimistic locking. |
| 09 | Data Consistency Models | Strict, Linearizable, Sequential, Causal, Read-After-Write, and Eventual consistency. |
| 10 | Data Management Patterns | CQRS, Event Sourcing, Saga Pattern, Outbox Pattern, and Change Data Capture (CDC / Debezium). |
| 11 | Proven Strategies to Scale Databases | Read replicas, connection pooling (PgBouncer), indexing, table partitioning, and caching. |
| 12 | Database Sharding & Partitioning | Range, Hash, and Directory-based horizontal sharding, partition routing, and re-sharding. |
Part 2: Database Engines Deep Dives
| # | Guide | Primary Topics Covered |
|---|---|---|
| 13 | PostgreSQL Essentials | MVCC internals, JSONB indexing (GIN/GiST), EXPLAIN ANALYZE, WAL archiving, and replication. |
| 14 | MySQL Essentials | InnoDB storage engine, Clustered vs. Secondary B+Tree indexes, undo logs, and binlog replication. |
| 15 | Redis Essentials | In-memory data structures (Strings, Hashes, Lists, Sets, Sorted Sets, Bitmaps, HyperLogLog), RDB/AOF, and Sentinel/Cluster. |
| 16 | Memcached Essentials | Slab allocation, multithreaded LRU caching, consistent hashing clients, and Memcached vs. Redis. |
| 17 | MongoDB Essentials | BSON document model, WiredTiger storage engine, replica sets (Oplog), and horizontal sharding. |
| 18 | DynamoDB Essentials | Single-Table Design, Partition (PK) & Sort (SK) keys, GSIs/LSIs, DynamoDB Streams, and DAX caching. |
| 19 | Apache Cassandra Essentials | Wide-column store, Peer-to-peer ring topology, Gossip protocol, Memtables/SSTables/Compaction, and Tunable Consistency (QUORUM). |
| 20 | CockroachDB Essentials | Distributed SQL, Raft multi-region consensus, Serializable isolation (MVCC + HLC clocks), and zero-downtime schema migrations. |