Databases & Storage Roadmap

Everything you need to know about storing, querying, and managing data at scale.

3 stages · 12 topics 0% done
Databases & Storage
✓ Database Design
✓ Advanced SQL
✓ Relational
✓ Indexing
✓ Document Stores
✓ NoSQL
✓ Key-Value
✓ Graph Databases
✓ Replication
✓ Sharding
✓ Operations
✓ Backup & Recovery
Text version of this roadmap

1. Relational

  • Database Design: Normalization, ER diagrams, schemas
  • Advanced SQL: Joins, subqueries, window functions, CTEs
  • Indexing: B-trees, hash indexes, query plans

2. NoSQL

  • Document Stores: MongoDB, Couchbase, Firestore
  • Key-Value: Redis, DynamoDB, etcd, memcached
  • Graph Databases: Neo4j, Cypher, graph traversals

3. Operations

  • Replication: Master-slave, multi-master, consensus
  • Sharding: Horizontal partitioning, hash sharding
  • Backup & Recovery: Point-in-time, WAL archiving, replicas