You are previewing MySQL Workbench: Data Modeling & Development.
O'Reilly logo
MySQL Workbench: Data Modeling & Development

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.

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