Databases: Zero to Hero
From "what is a database?" to production-grade design — complete guide
36
Chapters
10
Parts
8
Quizzes
Part I — Foundations: What & Why
- 01What is a Database and Why Do We Need One?
- 02Types of Databases: The Landscape
- 03How Data Lives on Disk: Files, Pages, and Blocks
- 04The Relational Model: Tables, Rows, and Math
Part II — SQL: The Language of Databases
- 05SQL Basics: SELECT, INSERT, UPDATE, DELETE
- 06Filtering, Sorting, and Aggregation
- 07JOINs: Combining Tables
- 08Subqueries, CTEs, and Window Functions
Part III — Schema Design
- 09Data Types: Choosing the Right One
- 10Normalization: 1NF through BCNF
- 11Keys, Constraints, and Referential Integrity
- 12Schema Design Patterns for Real Applications
Part IV — Indexing & Performance
- 13Indexes: What They Are and How They Work
- 14B-Tree Internals: The Data Structure Behind Indexes
- 15The Query Planner: How Databases Execute Queries
- 16EXPLAIN ANALYZE: Reading Query Plans
Part V — Transactions & Concurrency
- 17ACID: The Four Guarantees
- 18Isolation Levels: Read Committed to Serializable
- 19Locks, MVCC, and Concurrency Control
- 20Deadlocks: Detection, Prevention, and Recovery
Part VI — Database Internals
- 21Storage Engines: InnoDB, RocksDB, WiredTiger
- 22Write-Ahead Log and Crash Recovery
- 23Buffer Pool and Memory Management
Part VII — NoSQL & Beyond Relational
- 24Why NoSQL? CAP Theorem and Trade-offs
- 25Key-Value and Document Stores (Redis, MongoDB)
- 26Column-Family and Graph Databases
Part VIII — Distributed Databases
- 27Replication: Leader-Follower, Multi-Leader, Leaderless
- 28Partitioning (Sharding): Splitting Data Across Nodes
- 29Consistency and Consensus (Raft, Paxos)
Part IX — Production Operations
- 30Backup, Restore, and Point-in-Time Recovery
- 31Monitoring and Performance Tuning
- 32Schema Migrations Without Downtime
- 33Database Security: Auth, Encryption, Injection
Part X — Architecture Patterns
- 34Connection Pooling and Application Integration
- 35Caching Patterns: Read-Through, Write-Behind
- 36Choosing the Right Database for Your System
Start with Chapter 1: What is a Database?