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
Michael McLaughlin, Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 10g Express Edition PHP Web Programming, and Oracle Database 11g & MySQL 5.6 Developer Handbook. He is the co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. Michael worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.
Keywords: MYSQL, WORKBENCH, DATA MODELING, DEVELOPMENT, MY SQL WORKBENCH DATA MODELING AND DEVELOPMENT, BOOK, GUIDE, HOW TO, INSTALLATION, CONFIGURATION, SUBQUERIES, TRANSACTIONS, TRIGGERS, STORED PROCEDURES, FUNCTIONS, VIEWS, EVENTS, LOCALIZATION, ADMINISTRATION, SECURITY, PRIVILEGES, MAINTENANCE, BACKUP, RECOVERY, OPTIMIZATION, REPLICATION, CLUSTERING, DEVELOPMENT, MANAGE, CONNECTIONS, ERD, PHYSICAL SCHEMATA, TABLES, RELATIONSHIPS, ROUTINES, ROUTINE GROUPS, USER, GROUPS, SQL SCRIPTS, GENERATING, FORWARD ENGINEERING, SYNCHRONIZE, REVERSE ENGINEERING, DIFFERENCES, DATA CATALOG, MODEL NOTES, EDIT, TABLE DATA, GENERATED SCRIPTS, NEW INSTANCES, IMPORT, EXPORT, SECURITY, SERVER INSTANCES, C, PERL, PHP, API, XML, PHP PROGRAMMING SOLUTIONS, MYSQL THE COMPLETE REFERENCE, HTML & XHTML: THE COMPLETE REFERENCE, PHP 6 A BEGINNER'S GUIDE, PHP THE COMPLETE REFERENCE, HOW TO DO EVERYTHING WITH PHP AND MYSQL, CSS XHTML COMPLETE REFERENCE, AJAX THE COMPLETE REFERENCE, AJAX BEGINNER'S GUIDE, JAVASERVER FACES THE COMPLETE REFERENCE, STRUTS 2 THE COMPLETE REFERENCE, JAVASCRIPT THE COMPLETE REFERENCE, SQL A BEGINNER'S GUIDE, ORACLE JDEVELOPER 11G HANDBOOK, ORACLE JDEVELOPER 10G FOR FORMS & PL/SQL DEVELOPERS, ORACLE DATABASE 10G EXPRESS EDITION PHP WEB PROGRAMMING, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G SQL, ORACLE DATABASE AJAX & PHP WEB APPLICATION DEVELOPMENT, ORACLE SQL DEVELOPER HANDBOOK, ORACLE APPLICATION SERVER 10G WEB DEVELOPMENT, ORACLE HTML DB HANDBOOK, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, ORACLE DATABASE 11G AND MYSQL 5.5 DEVELOPER HANDBOOK, JAVA 7 PROGRAMMING, JAVA SE 7 PROGRAMMER STUDY GUIDE, EFFECTIVE MYSQL BACKUP AND RECOVERY, EFFECTIVE MYSQL OPTIMIZING SQL STATEMENTS, EFFECTIVE MYSQL ADVANCED REPLICATION TECHNIQUES, ORACLE DATABASE 11G THE COMPLETE REFERENCE, ORACLE DATABASE 11G A BEGINNER'S GUIDE, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G NEW FEATURES, ORACLE DATABASE 11G DBA HANDBOOK, ORACLE DATABASE 11G SQL, OCA ORACLE DATABASE 11G ADMINISTRATION I EXAM GUIDE, OCA ORACLE DATABASE 11G SQL FUNDAMENTALS I EXAM GUIDE, OCP ORACLE DATABASE 11G NEW FEATURES FOR ADMINISTRATORS EXAM GUIDE, OCP ORACLE DATABASE 11G ADMINISTRATION II EXAM GUIDE, ORACLE DATABASE 11G RMAN BACKUP & RECOVERY, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, OCA/OCP ORACLE DATABASE 11G ALL-IN-ONE EXAM GUIDE, MICROSOFT SQL SERVER 2008 ADMINISTRATION FOR ORACLE DBAS, ORACLE DATABASE ADMINISTRATION FOR SQL SERVER DBAS, ORACLE STREAMS 11G DATA REPLICATION, ORACLE DATABASE 11G RELEASE 2 HIGH AVAILABILITY, MAXIMIZE YOUR AVAILABILITY WITH GRID INFRASTRUCTURE, RAC AND DATA GUARD, ORACLE REAL APPLICATION CLUSTERS TESTING AND TUNING, OCP, EFFECTIVE MYSQL BACKUP AND RECOVERY, EFFECTIVE MYSQL OPTIMIZING SQL STATEMENTS, ORACLE DATABASE 11G PERFORMANCE TUNING TIPS AND TECHNIQUES, ORACLE CRM ON DEMAND REPORTING, PEOPLESOFT DEVELOPER'S GUIDE FOR PEOPLETOOLS & PEOPLECODE, ORACLE E-BUSINESS SUITE FINANCIALS HANDBOOK, ORACLE E-BUSINESS SUITE MANUFACTURING & SUPPLY CHAIN MANAGEMENT, EFFECTIVE ORACLE BY DESIGN, ENTERPRISE GRID COMPUTING WITH ORACLE, ORACLE APPLICATION SERVER PORTAL HANDBOOK, ORACLE DATABASE 10G HIGH AVAILABILITY WITH RAC, FLASHBACK & DATA GUARD, ORACLE COLLABORATION SUITE HANDBOOK, ORACLE DATABASE 10G RMAN BACKUP & RECOVERY, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL IMPLEMENTATION GUIDE, ORACLE E-BUSINESS SUITE SECURITY, TRANSFORMING INFOGLUT!, ORACLE CRM ON DEMAND REPORTING, ORACLE AUTOMATIC STORAGE MANAGEMENT, ORACLE DATABASE 11G DATA GUARD HANDBOOK, ORACLE GENERAL LEDGER GUIDE, ORACLE PROCURE-TO-PAY GUIDE, ORACLE ESSBASE & ORACLE OLAP, ORACLE DISCOVERER 10G HANDBOOK, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL HANDBOOK, ORACLE FUSION DEVELOPER GUIDE, ORACLE E-BUSINESS SUITE DEVELOPMENT & EXTENSIBILITY HANDBOOK
