← Back to Roadmap
✅ Master Level
Database Design
Complete Beginner → Advanced Syllabus (Pin-to-Pin)
🟢 LEVEL 1 — Database Fundamentals
1. What is a Database
- Definition & purpose
- Data persistence
- Query capabilities
- Transaction support
2. Database Types
- Relational databases
- NoSQL databases
- Key-value stores
- Document databases
🟢 LEVEL 2 — SQL Basics
3. Relational Databases
- Tables & rows
- Columns & data types
- Primary keys
- Foreign keys
4. Normalization
- 1NF (First Normal Form)
- 2NF (Second Normal Form)
- 3NF (Third Normal Form)
- BCNF & higher forms
🟡 LEVEL 3 — Indexing
5. Index Types
- B-tree indexes
- Hash indexes
- Bitmap indexes
- Full-text indexes
6. Query Optimization
- Execution plans
- Index selection
- Query analysis
- Performance tuning
🟡 LEVEL 4 — NoSQL Design
7. Document Databases
- MongoDB fundamentals
- Document structure
- Flexible schema
- BSON format
8. NoSQL Trade-offs
- Schema flexibility
- Horizontal scaling
- Denormalization benefits
- Query limitations
🟠 LEVEL 5 — Sharding
9. Horizontal Scaling
- Sharding fundamentals
- Shard key selection
- Data distribution
- Hot shard handling
10. Resharding Strategies
- Splitting shards
- Merging shards
- Migration flows
- Consistency during migration
🟠 LEVEL 6 — Replication
11. Replication Patterns
- Master-slave replication
- Master-master replication
- Replica lag
- Write concern levels
12. Consistency Models
- Strong consistency
- Eventual consistency
- Read your writes consistency
- Causal consistency
🔵 LEVEL 7 — Advanced Querying
13. Join Operations
- INNER joins
- LEFT/RIGHT joins
- FULL joins
- Join performance
14. Aggregations
- GROUP BY operations
- Aggregate functions
- Window functions
- Aggregation pipelines
🔵 LEVEL 8 — Transactions
15. ACID Properties
- Atomicity
- Consistency
- Isolation levels
- Durability
16. Distributed Transactions
- Two-phase commit
- Saga pattern
- Event sourcing
- Compensating transactions
🔴 LEVEL 9 — Governance & Monitoring
17. Performance Monitoring
- Query logs analysis
- Slow query detection
- Index usage analysis
- Storage monitoring
18. Database Governance
- Schema migrations
- Backup strategies
- Disaster recovery
- Data retention policies
⭐ Senior Frontend Focus (Must Master)
- Understanding data requirements from frontend
- API query optimization impact
- N+1 query problems from frontend perspective
- Pagination design for large datasets
- Data consistency requirements for UX
- Cache invalidation strategies
- Communicating frontend performance needs