Free book
Database Design and Query Optimization
Reading access
Free book
This book teaches database design and query optimization from fundamentals to production practice. It covers modeling, normalization, indexing, execution plans, transactions, migrations, analytics patterns, and how to keep database-backed systems healthy.
Level: advancedLanguage: EN EnglishRating: 0Reviews: 0
Book
Book contents
01Chapter 1: Introduction to Database Design and Data Modeling02Chapter 2: Entities, Relationships, ER Diagrams, and Business Rules03Chapter 3: Primary Keys, Foreign Keys, Constraints, and Integrity04Chapter 4: Normalization, Denormalization, and Practical Trade-Offs05Chapter 5: Writing Clear SQL for Real Applications06Chapter 6: Joins, Aggregations, and Query Rewriting07Chapter 7: Indexes, Cardinality, and Execution Plans08Chapter 8: Transactions, Isolation, Concurrency, and Locking09Chapter 9: Schema Evolution, Migrations, and Backward Compatibility10Chapter 10: Partitioning, Archiving, and Large Dataset Strategies11Chapter 11: Analytics, Materialized Views, and Reporting Workloads12Chapter 12: Monitoring, Slow Queries, and Ongoing Optimization13Chapter 13: Designing a Production Database for a Real Product14Chapter 14: Improving Query Performance with Measured Changes15Chapter 15: Handling Growth, Failures, and Operational Maintenance16Chapter 16: Capstone: Review and Optimize a Full Schema17Appendix A: Commands and Workflow Cheat Sheet18Appendix B: Reference Architectures and Patterns19Appendix C: Common Mistakes and Fixes20Appendix D: Best Practices Summary
Reviews
No approved reviews are visible yet.
Featured Books
Discussion
0 commentsNo approved comments are visible yet. New community replies may wait for moderation.