MySQL Workbench: Data Modeling & Development

AvMichael McLaughlin

Häftad, Engelska, 2013

483 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

E-bok

687 kr

Beskrivning

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Produktinformation

Utgivningsdatum:2013-05-16
Mått:188 x 228 x 25 mm
Vikt:771 g
Format:Häftad
Språk:Engelska
Antal sidor:480
Förlag:McGraw-Hill Education
ISBN:9780071791885

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

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.

Innehållsförteckning

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