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!
Chapter 1 Review of MySQL Basics
Chapter 2 MySQL Column and Table Types
Chapter 3 Keys, Indexs, 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