SQL (Advanced)
Query Optimization & Execution Plans
- Understanding EXPLAIN/ANALYZE to identify slow queries
Indexing Strategies
- When and how to use indexes effectively
Transactions & Locking
- ACID properties, deadlocks, isolation levels
Database Performance Testing
- Identifying bottlenecks, query profiling
Data Integrity Validation
- Constraints verification, referential integrity checks