Best Practices for Optimizing Database Projects
summary
Covers practical best practices for optimizing database projects and data environments, drawing on experience scaling systems exponentially and handling failure points. Discusses how to avoid common failures and the trade-offs in database design, with a focus on transactional relational databases but advice applicable to dimensional and object-relational stores.
AI-written summary · about
chapters (11)
- 0:00Introduction to topic
- 3:58Know project from start
- 7:32Good documentation practices
- 13:00Modular model design
- 20:07Diagnose before optimize
- 23:35Analyze SQL execution plan
- 26:47Efficient query structuring
- 31:58Correct index usage
- 35:32Leverage cache and parallelism
- 39:26Test and validate optimizations
- 42:18Final modeling best practices
related talks
51mThe Lost Art of Database Design
17mTop 10 transactional database mistakes, and how to avoid them
42mHow to Become a Great Database Specialist
41mWant to turbocharge your database? Ask me how!
28mSmall Data: Databases in the real world
35m10 things a developer should know about databases
17mEmpowering Engineers With a Database DevOps Strategy
46mThe Lost Art of Database Design