Murach's MySQL, 3/e (Paperback)

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.

這是全球應用程式開發人員用來精通MySQL的最新版本書籍...現已更新至MySQL 8.0及更高版本。

- 本書展示了如何編寫所有與MySQL資料庫一起使用的基本SQL語句。您將每天使用這些語句，讓MySQL為您完成更多工作。

- 本書展示了如何使用傳統的MySQL功能，例如摘要查詢、子查詢、函數、視圖、事務、儲存過程、觸發器和安全性。

- 本書展示了如何利用較新的MySQL功能，例如窗口函數、通用表達式（CTE）和資料庫安全性角色。

- 本書展示了如何設計資料庫，包括如何使用MySQL Workbench來創建和實施設計。

- 本書為有興趣從事資料庫管理員（DBA）職業道路或需要成為自己的DBA的人提供了一組起始技能。

總之，對於任何與MySQL一起工作的人來說，這是一本必備指南，無論是初學者還是有經驗的開發人員。