Practice
Mock interviews
Weekly practice interviews filmed for class. Each one covers database concepts, design decisions, and the kind of technical questions you'd encounter in real interviews.
Week 1
Database Fundamentals
Data Integrity and foundational infrastructure concepts
Week 2
Schema Design and Decisions
Architectural decisions, normalization vs denormalization, and designing for scale.
Week 3
Postgres Instances, Vertical Scaling, and Concurrency
Scale Tipping Point, Production Safety, and Data Cleanup Strategies.
Week 4
Storage Flexibility, Data Accuracy, Consistency, and Indexing
Exploring different storage options, ensuring data accuracy, maintaining consistency, and optimizing indexing strategies.
Week 5
Selection, Architecture, and Search Complexity
Resource Management, Deployment Constraints, Embedded Databases, Cost-Based Optimization, I/O Efficiency, and Search Complexity Awareness.
Week 6
Developer Velocity, NoSQL, CAP Theorem, and Scalable Architectures
Architectural Judgement, Performance Tradeoffs, and Vertical vs. Horizontal Scaling.