* 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.
* 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.

Beginning MySQL Database Design and Optimization: From Novice to Professional
520
Beginning MySQL Database Design and Optimization: From Novice to Professional
520Paperback(Softcover reprint of the original 1st ed.)
Product Details
ISBN-13: | 9781590593325 |
---|---|
Publisher: | Apress |
Publication date: | 10/28/2004 |
Series: | Novice to Professional |
Edition description: | Softcover reprint of the original 1st ed. |
Pages: | 520 |
Product dimensions: | 7.00(w) x 10.30(h) x 1.01(d) |