BN.com Gift Guide

MySQL Workbench: Data Modeling & Development [NOOK Book]

Overview

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 ...

See more details below
MySQL Workbench: Data Modeling & Development

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.99
BN.com price
(Save 42%)$45.00 List Price

Overview

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

Read More Show Less

Product Details

  • ISBN-13: 9780071791892
  • Publisher: McGraw-Hill Education
  • Publication date: 4/30/2013
  • Series: Oracle Press
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 480
  • File size: 33 MB
  • Note: This product may take a few minutes to download.

Meet 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.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted May 1, 2013

    MySQL Workbench: Data Modeling & Development Michael









    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).  Importing, migrating and exporting databases is extensively covered.




    The book finishes up with chapter questions (and you need to be careful; some of the questions are tougher than they look), how to extend Workbench, and setting MS SQL Server (to use the migration tools).




    Does the book lack anything?  Well, it does not cover the recent MySQL Utilities that allow the cloning of a server for replication and replication fail over.  But those are very new and no doubt will picked up for a future revision.  




    But do you need this book?   Yes, if you are new to Workbench and want to get up to speed quickly.  Yes if you are getting into data modeling.  And yes if you are not a full time DBA and want to use this free tool as your admin interface. Old, barnacle crusted DBAs my not need a copy but they should buy them for their juniors.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)