Phase 3 · weeks 25-29 · 5 weeks
Databases
- Relational DB concepts: keys, relationships, normalization
- SQL: joins, subqueries, aggregates, window functions
- Indexing, transactions, ACID
- PostgreSQL/MySQL hands-on
- NoSQL: document/key-value/column/graph concepts
- MongoDB: CRUD, aggregation pipeline, schema design
- Redis: caching, pub/sub, sessions
- Schema design for a social/chat app
- ORMs: SQLAlchemy, Prisma/Mongoose
- Distributed database concepts (sharding — conceptual, revisited later)
Project: Full DB schema for a WhatsApp-like + Instagram-like app