MySQL Workbench: Data Modeling & Development

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

• Part 1: ConfigurationChapter 1: Installing and ConfiguringChapter 2: Creating and Managing ConnectionsPart 2: Data ModelingChapter 3: Data Modeling ConceptsChapter 4: Creating an ERDChapter 5: Defining the Physical SchemataChapter 6: Creating and Managing TablesChapter 7: Creating and Managing RelationshipsChapter 8: Creating and Managing ViewsChapter 9: Creating and Managing RoutinesChapter 10: Creating and Managing Routine GroupsChapter 11: Creating and Managing User & GroupsChapter 12: Creating and Managing SQL ScriptsChapter 13: Generating SQL ScriptsChapter 14: Forward Engineering a Data ModelChapter 15: Synchronize a Model with a DatabaseChapter 16: Reverse Engineering a DatabaseChapter 17: Managing Differences in the Data CatalogChapter 18: Creating and Managing Model NotesPart 3: SQL DevelopmentChapter 19: Editing Table DataChapter 20: Editing Generated ScriptsPart 4: Server AdministrationChapter 21: Creating New InstancesChapter 22: Managing Import and ExportChapter 23: Managing SecurityChapter 24: Managing Server Instances