Relational, NoSQL, database design and optimization — books, the foundational distributed-DB papers, engine source, and tuning guides. Links open in a new tab.
Books
| Resource | What | Link |
|---|
| High Performance MySQL — Schwartz et al. | Optimization + replication. | book |
| Designing Data-Intensive Applications — Kleppmann | Data systems bible. | book |
| PostgreSQL: Up and Running — Obe & Hsu | Practical Postgres. | book |
| MongoDB: The Definitive Guide | Document DB guide. | book |
| SQL Performance Explained — Winand | Indexing, made clear. | site |
Research Papers
| Resource | What | Link |
|---|
| Google Spanner | Globally-distributed DB. | site |
| Amazon Dynamo | NoSQL key-value design. | pdf |
| CAP Theorem | Consistency/availability/partition. | site |
| Architecture of a Database System | Hellerstein et al, classic. | pdf |
GitHub Repositories
| Resource | What | Link |
|---|
| Awesome Databases | Curated collection. | repo |
| db-readings | Academic DB papers. | repo |
| PostgreSQL | Source code. | repo |
| Redis | In-memory store source. | repo |
Videos & Courses
| Resource | What | Link |
|---|
| CMU 15-445 — Database Systems | The classic course. | video |
| SQL for Beginners (freeCodeCamp) | SQL intro. | video |
| MongoDB University | Official training. | course |
| PostgreSQL Tutorial | Postgres learning. | site |
Articles & Blogs
| Resource | What | Link |
|---|
| Percona Blog | MySQL optimization. | site |
| PostgreSQL Performance Tips | Official tuning docs. | site |
| Use The Index, Luke! | SQL indexing guide. | site |
| MongoDB Production Notes | Operational guidance. | site |
Recommended Reading
| Resource | What | Link |
|---|
| Database Design Fundamentals | Design methodology. | site |
| SQL Style Guide | Coding conventions. | site |
| Database Sharding | Horizontal partitioning. | site |
| ACID Properties | Transaction characteristics. | site |
where to start
Read DDIA + High Performance MySQL, take CMU 15-445, and keep Use-The-Index-Luke handy for query tuning.