Programming Books C Java PHP Python Learn more Browse Programming Books
MySQL Workbench: Data Modeling & Development and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $12.36 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading MySQL Workbench on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL Workbench: Data Modeling & Development (Oracle Press) [Paperback]

by Michael McLaughlin
3.8 out of 5 stars  See all reviews (6 customer reviews)

List Price: $45.00
Price: $31.66 & FREE Shipping on orders over $35. Details
You Save: $13.34 (30%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 5 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $30.08  
Paperback $31.66  
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

April 9, 2013 0071791884 978-0071791885 1

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


Frequently Bought Together

MySQL Workbench: Data Modeling & Development (Oracle Press) + Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press)
Price for both: $66.65

Buy the selected items together


Editorial Reviews

About the Author

Michael McLaughlin, Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 10g Express Edition PHP Web Programming, and Oracle Database 11g & MySQL 5.6 Developer Handbook. He is the co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. Michael worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.


Product Details

  • Series: Oracle Press
  • Paperback: 480 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (April 9, 2013)
  • Language: English
  • ISBN-10: 0071791884
  • ISBN-13: 978-0071791885
  • Product Dimensions: 9 x 7.3 x 1.1 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #63,468 in Books (See Top 100 in Books)

More About the Author

I finished writing the Oracle Database 12c PL/SQL Programming book, and it's available for purchase. I also recently finished a book on how to use MySQL Workbench, a great design tool. I'm an Oracle ACE and veteran of Oracle technologies (20+ years). I'm the author of five and co-author of four Oracle Press books.

I teach database technology and systems analysis and design in the Computer Information Technology Department at BYU - Idaho. I also worked at Oracle Corporation in consulting, development, and support. I'm the inventor of the ATOMS transaction architecture (U.S. Patents #7,206,805 and #7,290,056). The patents are assigned to Oracle.

Customer Reviews

3.8 out of 5 stars
(6)
3.8 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
9 of 10 people found the following review helpful
Format:Paperback
MySQL Workbench:
Data Modeling & Development
Michael McLaughlin
Oracle Press
ISBN 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).
Read more ›
Comment | 
Was this review helpful to you?
5 of 6 people found the following review helpful
2.0 out of 5 stars MySQL Workbench is out of date November 27, 2013
Format:Kindle Edition|Verified Purchase
Because it does not address the current version of MySQL Workbench so is little value. Needs to be updated & I need the update for free
Comment | 
Was this review helpful to you?
3 of 4 people found the following review helpful
5.0 out of 5 stars Excellent resource for Data Modeling concepts August 8, 2013
Format:Paperback
This book was impressive to me from the start. It explains how to setup the needed programs to get the best use out of the book in simple easy to understand instructions that my grandmother could use. I was able to use the material in this book to help a family member effectively understand data modeling and how to develop it as part of his transition to an economic analyst. The book is of use to folks starting at the raw novice level all the way to experienced DBA's looking to speed up daily tasks. The data modeling and development concepts translate across database platforms to make things easier which every database you decide to use.
Comment | 
Was this review helpful to you?
ARRAY(0x9e5bc4f8)

What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 



Look for Similar Items by Category