Murach's MySQL. 4 Ed

Table of Contents
Introduction
An introduction to MySQL
An introduction to relational databases
How to use MySQL Workbench and other development tools
How to retrieve data from a single table
How to retrieve data from two or more tables
How to insert, update, and delete data
More SQL skills as you need them
How to code summary queries
How to code subqueries
How to work with data types
How to use functions
Database design and implementation
How to design a database
How to create databases, tables, and indexes
How to create views
Stored program development
Language skills for writing stored programs
How to use transactions and locking
How to create stored procedures and functions
How to create triggers and events
Database administration
An introduction to database administration
How to secure a database
How to back up and restore a database
How to host a database with AWS
Appendix A
Appendix B
Index

The latest edition of Murach’s classic MySQL book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips.

To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the most important SQL statements because developers use them every day. Then, it shows how to design a database, how to implement that design, and how to work with views, transactions, stored procedures, functions, triggers, and events. Finally, it presents a starting set of skills for a database administrator (DBA) including how to manage security, how to backup and restore a database, and how to host a MySQL database with Amazon Web Services (AWS).

The result? You’ll be able to use SQL to work with a MySQL database in a way that’s thoroughly professional.

Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive “paired-pages” format is ideal for learning and reference.