MySQL Workbench: Data Modeling & Development

MySQL Workbench: Data Modeling & Development

by Michael McLaughlin
Released May 2013
Publisher(s): Oracle Press
ISBN: 9780071791892

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book 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

  1. Cover 
  2. About the Author
  3. Title Page
  4. Copyright Page
  5. Contents at a Glance
  6. Contents 
  7. Acknowledgments
  8. Introduction
  9. Part I: Configuration
    1. Chapter 1: Installing and Configuring
      1. Fedora Linux
        1. Install and Configure MySQL Products
      2. Mac OS X
        1. Install MySQL Products
      3. Microsoft Windows
        1. Pre-install Microsoft Redistributable Libraries
        2. Install MySQL Products
      4. Summary
      5. Mastery Check
    2. Chapter 2: Creating and Managing Connections
      1. Fedora
      2. Mac OS X
      3. Windows 7
        1. Configuring MySQL Workbench Connections
        2. Configuring Server Administration
      4. Summary
      5. Mastery Check
  10. Part II: Data Modeling
    1. Chapter 3: Data Modeling Concepts
      1. Data Modeling Theory
        1. What Is Data Modeling?
        2. Why Is Data Modeling Important?
        3. How Do We Accomplish It?
      2. Data Modeling Systems
        1. Binary Relationships
        2. N-ary Relationships
        3. Notation Sets
      3. Classic Normalization
        1. First Normal Form
        2. Second Normal Form
        3. Third Normal Form
      4. Summary
      5. Mastery Check
    2. Chapter 4: Creating and Managing Tables and Relations
      1. Opening and Saving Files
      2. Creating Tables and Views
        1. Add Tables
        2. Add Columns
        3. Add Indexes
        4. Add Foreign Keys
        5. Creating Views
        6. Creating Routines
      3. Creating Relationships
      4. Summary
      5. Mastery Check
    3. Chapter 5: Creating and Managing Routines
      1. Adding a Routine
      2. Editing a Routine
      3. Removing a Routine
      4. Summary
      5. Mastery Check
    4. Chapter 6: Reverse Engineering
      1. Reverse Engineering a Database
      2. Forward Engineering a Database
        1. Forward Engineering from an EER Model
        2. Forward Engineering from a Script
      3. Summary
      4. Mastery Check
  11. Part III: SQL Development
    1. Chapter 7: Editing Data
      1. Connecting to Edit Data
      2. Insert Data
      3. Update Data
      4. Delete Data
      5. Multiple Data Edits
      6. Summary
      7. Mastery Check
    2. Chapter 8: Managing SQL Scripts
      1. Opening a SQL File
      2. Running a SQL File
      3. Summary
      4. Mastery Check
  12. Part IV: Server Administration
    1. Chapter 9: Instances
      1. Create a Local Instance Manager
      2. Create a Remote Instance Manager
      3. Manage an Existing Instance
      4. Maintain Existing Instance Managers
      5. Summary
      6. Mastery Check
    2. Chapter 10: Creating and Managing Users and Roles
      1. Adding a User
      2. Adding Schema Privileges
      3. Summary
      4. Mastery Check
    3. Chapter 11: Imports and Exports
      1. Exporting a Database
      2. Importing a Database
      3. Summary
      4. Mastery Check
    4. Chapter 12: Migrating Databases
      1. Exporting a Database
      2. Summary
      3. Mastery Check
  13. Part V: Appendixes and Glossary
    1. Appendix A: Mastery Check Answers
      1. Chapter 1
      2. Chapter 2
      3. Chapter 3
      4. Chapter 4
      5. Chapter 5
      6. Chapter 6
      7. Chapter 7
      8. Chapter 8
      9. Chapter 9
      10. Chapter 10
      11. Chapter 11
      12. Chapter 12
    2. Appendix B: Extending MySQL Workbench
      1. Scripts
      2. Modules
      3. Shell
      4. Summary
    3. Appendix C: Setting Up SQL Server
      1. Installing SQL Server
      2. Fixing the SQL Server Command-line Interface
      3. Configuring a User Schemata
      4. Creating and Seeding a Database
      5. Summary
  14. Glossary: Database Modeling Terms
  15. Index

Product information

  • Title: MySQL Workbench: Data Modeling & Development
  • Author(s): Michael McLaughlin
  • Release date: May 2013
  • Publisher(s): Oracle Press
  • ISBN: 9780071791892