Databases & Caching

Core Concepts

• SQL vs NoSQL
• Indexing
• Transactions

Optimization

• Query plans
• Index tuning
• Caching strategies

Trade-offs

• Consistency vs performance

Interview Focus

• Schema design
• Slow query debugging