Series: Oracle Press
Paperback: 480 pages
Publisher: McGraw-Hill Education; 1 edition (April 30, 2013)
Product Dimensions: 7.4 x 1 x 9 inches
Shipping Weight: 1.6 pounds (View shipping rates and policies)
Average Customer Review: 3.2 out of 5 stars See all reviews (15 customer reviews)
Best Sellers Rank: #680,218 in Books (See Top 100 in Books) #91 in Books > Computers & Technology > Databases & Big Data > MySQL #170 in Books > Computers & Technology > Databases & Big Data > Oracle #228 in Books > Computers & Technology > Databases & Big Data > Data Warehousing
MySQL Workbench:Data Modeling & DevelopmentMichael McLaughlinOracle PressISBN 978-0-07-178188-5 MySQL Workbench is one of those tools that quickly becomes invaluable. It is a SQL query tool, a data modeler, and an admin tool all in one. As such a complicated tool, there is a bit of a learning curve before one can move beyond the basic functionality. Now there is a book that not only is a guided tour of MySQL Workbench but it contains little snippets full of DBA and system admin tricks that make this a must have for anyone using Workbench. The book is divided into six sections that starts with configuration. This part of the book assumes now previous database or MySQL background as it gently guides you through the installation of the key components on mac OS X, Windows, and Linux. The author's teaching background is very evident here as the material is 'undergraduate proof' and very clearly written. The illustrations are large, clear, and informative. The second section covers data modeling including creating tables, reverse engineering schemas, and creating routines. This section covers it all from the theory of data modeling through building complex schemas with foreign keys. The discussion on the choice of keys in tables should be mandatory reading for any DBA. The third section delves into using Workbench for query development and the management of SQL scripts. This section is short and to the point. Many folks use Workbench as an admin tool and the fourth section covers setting up connections, user management (MySQL has no predefined user roles but Workbench allows the set of users with privileges for various task like DBA, backup administrator, and such).