Murach's MySQL (4th Edition) - by Joel Murach (Paperback)

About the Book

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.

Book Synopsis

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.

Review Quotes

"This is a fantastic book! It has more info than books at twice the cost, but it presents that info in a concise, digestible manner. I wish I had a resource like this when I was first starting with MySQL."
Eric Chernoff, Team Leader, Cisco Systems

About the Author

Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 30 years now. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. He has had best-selling books in all of those categories! In his books, you can see his clear approach to teaching any subject.