This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling "Java Servlets and JSP" and "PHP and MySQL" books, this is exactly the database book that web developers should have on their desks.
As you would expect, this book shows how to code all of the
essential SQL statements for creating and working with a MySQL
database. But beyond that, this book also shows how to design a
database, including how to use the graphical MySQL Workbench to
create an EER model. It shows how to take advantage of the MySQL
enhancements that aren't covered in older books, such as foreign
keys, transactions, stored procedures, stored functions, triggers,
and events. It even presents a whole section on database
administrator (DBA) skills, including how to secure and back up
databases. And like all Murach books, it uses the distinctive
"paired pages" format, which breaks the material into manageable
skills to speed up both learning and reference. A great help for
MySQL users at any level.