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.
Who this book is for
This is the ideal book for application developers who need to work with a MySQL database.
- If you’re new to MySQL, it will teach you everything from coding SQL statements to designing databases to using stored programs that save you time and effort.
- If you have MySQL experience, the “paired-pages” format will make it easy for you to focus on the MySQL features and coding skills that are new to you. (If our format is new to you, please download a sample chapter to see how it works.)
This book is also a good choice for anyone who wants to learn standard SQL. In fact, 90% of what you learn here can be transferred to another database management system such as Oracle or SQL Server.
Finally, this is the right first book for anyone who wants to become a database administrator. Although it doesn’t cover all the issues that DBAs have to deal with, it gives you the solid foundation in database design and management that you need to build on.
Table of Contents
Section 1: An introduction to MySQL
Chapter 1. An introduction to relational databases and SQL
Chapter 2. How to use MySQL Workbench and other development tools
Section 2: The essential SQL skills
Chapter 3. How to retrieve data from a single table
Chapter 4. How to retrieve data from two or more tables
Chapter 5. How to code summary queries
Chapter 6. How to code subqueries
Chapter 7. How to insert, update, and delete data
Chapter 8. How to work with data types
Chapter 9. How to use functions
Section 3: Database design and implementation
Chapter 10. How to design a database
Chapter 11. How to create databases, tables, and indexes
Chapter 12. How to create views
Section 4: Stored program development
Chapter 13. Language skills for writing stored programs
Chapter 14. How to use transactions and locking
Chapter 15. How to create stored procedures and functions
Chapter 16. How to create triggers and events
Section 5: Database administration
Chapter 17. An introduction to database administration
Chapter 18. How to secure a database
Chapter 19. How to back up and restore a database
- Paperback: 612 pages
- Publisher: Mike Murach & Associates (May 2012)
- Language: English
- ISBN-10: 1890774685
- ISBN-13: 978-1890774684