Learning MySQL
Whether you are a beginner or an experienced database programmer, this book has something for you. If you only get one book on mySQL then get this one because it has everything you need.
My Rating: 
Pros
- Covers all of the mySQL calls from the simplest to the most advanced.
- Includes how to install on all the common operating systems.
- Logical order from basics through to advanced.
- Considers security aspects.
- Includes some info on how to use it with PHP or PERL
Cons
- The one area that this book only touches on briefly is how to properly design your database.
Description
- First Edition: Copyright November 2006
- 598 page paperback
- Published by O'Reilly Media
- ISBN 0-596-00864-3
- Authors Seyed M M Tahaghoghi and Hugh E Williams
Review
It is not often that you find a technical book that has the depth of coverage and logical structure that can be found in this one.
For the newcomer to mySQL databases it introduces the basic SQL (Structured Query language - pronounced "sequel") commands and demonstrates how to use them. It even covers some of the basics of how to design your database although detailed information on how to "normalize" a database is missing.
For those who already have some basic SQL knowledge the book also covers the more advanced areas such as how to manage users and privileges, backup/recovery, and database tuning. By applying this information you can make even the largest database secure with fast response times.
As an added bonus the book also demonstrates the correct way to use mySQL with either PHP or PERL and even includes a complete working example script that shows exactly how it all fits together.
