Murach's MySQL: Training & Reference 4th Edition

"The fourth edition of our best-selling MySQL book works better than ever for teaching SQL and database design. We’ve carefully checked and updated every example to provide you the best possible learning experience. Whether you’re a complete beginner or a SQL expert, you’ll appreciate the easy-to-understand explanations, clear examples, and step-by-step instructions for efficiently using SQL to work with relational databases." •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.