MySQL Workbench: Data Modeling & Development (Paperback)

The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.

MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually.

Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step.

Complete coverage
Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances

這本唯一的Oracle Press指南《MySQL Workbench資料建模與開發》解釋了如何設計和建模MySQL資料庫。這本書幫助開發人員學習如何有效地使用這個強大的產品進行資料庫建模、反向工程和與資料庫的互動，而無需編寫SQL語句。MySQL Workbench是一個圖形化用戶界面，可以用於創建和維護MySQL資料庫，無需編碼。本書涵蓋了界面並通過視覺方式展示最佳實踐，解釋了如何完成每個步驟。清晰的示例、說明和解釋在一本書中展示了資料庫建模的藝術。這本Oracle Press指南向您展示如何讓工具按照您的要求工作。註釋的螢幕截圖展示了與工具的所有互動，並且文字解釋了每個步驟的如何、為什麼和什麼。完整的內容包括：安裝和配置；創建和管理連接；資料建模概念；創建ERD；定義物理模式；創建和管理表；創建和管理關係；創建和管理視圖；創建和管理程序；創建和管理程序組；創建和管理使用者和群組；創建和管理SQL腳本；生成SQL腳本；正向工程資料模型；將模型與資料庫同步；反向工程資料庫；管理資料目錄中的差異；創建和管理模型註釋；編輯表格資料；編輯生成的腳本；創建新實例；管理導入和導出；管理安全性；管理伺服器實例。