Free book
MySQL and MariaDB from Beginner to Production
Reading access
Free book
A practical book about relational database development with MySQL and MariaDB. It covers schema design, indexes, joins, transactions, locking, migrations, replication, backups, query tuning, and production operations. Read with a project in mind. Each chapter gives enough detail to build a small slice, test it, and understand how it behaves in production.
Level: beginnerLanguage: EN EnglishRating: 0Reviews: 0
Book
Book contents
01Chapter 1: Relational Database Fundamentals02Chapter 2: Tables Columns and Data Types03Chapter 3: Primary Keys Foreign Keys and Constraints04Chapter 4: Normalization and Practical Denormalization05Chapter 5: Select Joins and Aggregations06Chapter 6: Index Design for Real Queries07Chapter 7: Explain Plans and Query Optimization08Chapter 8: Views Stored Procedures and Generated Columns09Chapter 9: Transactions Isolation and Locking10Chapter 10: Migrations Without Downtime11Chapter 11: Data Integrity and Cleanup Jobs12Chapter 12: Security Users and Permissions13Chapter 13: Backups Restore and Disaster Recovery14Chapter 14: Replication Read Replicas and Failover15Chapter 15: Monitoring Slow Queries and Capacity16Chapter 16: Capstone Production Order Database17Appendix A: Implementation Checklist18Appendix B: Production Readiness Review19Appendix C: Common Mistakes and Fixes20Appendix D: Capstone Project Guide
Reviews
No approved reviews are visible yet.
Featured Books
Discussion
0 commentsNo approved comments are visible yet. New community replies may wait for moderation.