Murach’s MySQL

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.

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 atabase 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 tored 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