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.
In short, it\'s a must-have guide for anyone who works with MySQL, beginning and experienced developers alike..
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.
It shows how to design a database, including how to use MySQL Workbench to create and implement the design.
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 use classic MySQL features such as summary queries, subqueries, functions, views, transactions, stored procedures, triggers, and security.
You\'ll use these statements every day to have MySQL do more of your work for you.
It shows how to code all the essential SQL statements for working with a MySQL database.
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