Sign in  |  Register
Advanced search
Publication Cover

CITATION

McLaughlin, Michael. MySQL Workbench: Data Modeling & Development. US: McGraw-Hill Osborne Media, 2013.

MySQL Workbench: Data Modeling & Development

Authors: Michael McLaughlin

Published:  April 2013

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