Beginning MySQL Database Design and Optimization: From Novice to Professional
Chad Russell, Jon Stephens
With the help of this book, you'll learn how to identify, overcome, and avoid gross inefficiencies in MySQL. Further, you will see how to maximize built-in data manipulation features. And you'll discover the benefits of incorporating tests and branches within your queries.
You will also learn about normalizing your database, and issuing simultaneous queries to boost performance—along with numerous other design and optimization topics. So if you’re building or maintaining any significant application with MySQL, then this book is your one-stop for training and preparing!
Table of Contents:
Chapter 1 – Review of MySQL Basics
Chapter 2 – MySQL Column and Table Types
Chapter 3 – Keys, Indexes, and Normalization
Chapter 4 – Optimizing Queries with Operators, Branching, and Functions
Chapter 5 – Joins, Temporary Tables, and Transactions
Chapter 6 – Finding the Bottlenecks
Chapter 7 – MySQL Programming
Chapter 8 – Looking Ahead