This is the latest edition of the book that application developers worldwide have used to master MySQL...now updated for MySQL 8.0 and beyond.

• It shows how to code all the essential SQL statements for working with a MySQL database. You'll use these statements every day to have MySQL do more of your work for you.

• It shows how to use classic MySQL features such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security.

• It shows how to take advantage of newer MySQL features such as window functions, Common Table Expressions (CTE), and roles for database security.

• It shows how to design a database, including how to use MySQL Workbench to create and implement the design.

• It presents a starting set of skills for a database administrator (DBA) if you're interested in that career path or if you need to be your own DBA.

In short, it's a must-have guide for anyone who works with MySQL, beginning and experienced developers alike.

Author: Joel Murach
Binding Type: Paperback
Publisher: Mike Murach and Associates, Inc.
Published: 05/01/2019
Pages: 650
Weight: 2.9lbs
Size: 9.80h x 7.90w x 1.50d
ISBN: 9781943872367
3rd Edition

About the Author
Murach, Joel: - Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 20 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.