Beginning MySQL Database Design and Optimization: From Novice to Professional

by Chad Russell, Jon Stephens

* Shows how to take advantage of MySQL's built-in functions, minimizing the need to process data once it's been retrieved from the database. * Demonstrates how to write and use advanced and complex queries to cut down on (middleware) application logic, including nested sub-queries and virtual tables (added since MySQL 4.1). * Points out database design do's and don'ts, including many real-world examples of bad database designs and how the databases were subsequently improved. * Includes a review of MySQL fundamentals and essential theory, such as naming conventions and connections, for quick reference purposes.

540 pages, Paperback

First published October 18, 2004

Reviews

[Pete Aven · Rating 4 out of 5]

This book is a great intro and reference for learning how to configure a MySql DB , index your tables, find bottlenecks, and optimize queries. There are certain chapters I'd find myself going back to at first as reference. Now I pretty much loan the book out and advise which chapters to reference whenever a colleague comes to me with certain questions. Colleagues have found the book very helpful as well.