MySQL Workbench: Data Modeling & Development

MySQL Workbench: Data Modeling & Development
By:McLaughlin, Michael;
Pub Date:April 30th 2013
Format:Paperback 480 pages
eBook Available: View eBook Details
ISBN:0071791884 / 9780071791885
Your Price:$45.00 ADD TO CART
More Information




Main description

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


Table of contents

Part 1: Configuration
Chapter 1: Installing and Configuring
Chapter 2: Creating and Managing Connections

Part 2: Data Modeling
Chapter 3: Data Modeling Concepts
Chapter 4: Creating an ERD
Chapter 5: Defining the Physical Schemata
Chapter 6: Creating and Managing Tables
Chapter 7: Creating and Managing Relationships
Chapter 8: Creating and Managing Views
Chapter 9: Creating and Managing Routines
Chapter 10: Creating and Managing Routine Groups
Chapter 11: Creating and Managing User & Groups
Chapter 12: Creating and Managing SQL Scripts
Chapter 13: Generating SQL Scripts
Chapter 14: Forward Engineering a Data Model
Chapter 15: Synchronize a Model with a Database
Chapter 16: Reverse Engineering a Database
Chapter 17: Managing Differences in the Data Catalog
Chapter 18: Creating and Managing Model Notes

Part 3: SQL Development
Chapter 19: Editing Table Data
Chapter 20: Editing Generated Scripts

Part 4: Server Administration
Chapter 21: Creating New Instances
Chapter 22: Managing Import and Export
Chapter 23: Managing Security
Chapter 24: Managing Server Instances


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Mar 5th, 2015
Your Price: $203.41
Owl Image

Date: May 6th, 2014
Your Price: $50.00
Owl Image

Date: May 2nd, 2014
Your Price: $123.25
Owl Image

Date: Feb 4th, 2014
Your Price: $182.33
Owl Image

Date: Oct 28th, 2013
Your Price: $189.33
Owl Image

Date: Sep 10th, 2013
Your Price: $50.00
Owl Image

Date: Jul 11th, 2013
Your Price: $189.33
Owl Image

Date: Jul 8th, 2013
Your Price: $165.00
Owl Image

Date: Jul 2nd, 2013
Your Price: $23.75
Owl Image

Date: Jul 2nd, 2013
Your Price: $123.25
Owl Image

Date: Jul 2nd, 2013
Your Price: $123.25
Owl Image

Date: Jun 27th, 2013
Your Price: $118.00
Owl Image

Date: May 7th, 2013
Your Price: $60.00
Owl Image

Date: May 2nd, 2013
Your Price: $189.33
Owl Image

Date: Jan 10th, 2013
Your Price: $150.00