Beschreibung:
* 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.
MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you're building or maintaining any significant application and are using MySQL, this book is for you.
A table of contents is not available for this title.