MySQL Workbench: Data Modeling & Development

Michael McLaughlin

květen 2013 · McGraw Hill Professional

E‑kniha

480

Stránky

Podrobnosti o e‑knize

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

O autorovi

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.

Ohodnotit e‑knihu

Sdělte nám, co si myslíte.

Informace o čtení

Telefony a tablety

Nainstalujte si aplikaci Knihy Google Play pro Android a iPad/iPhone. Aplikace se automaticky synchronizuje s vaším účtem a umožní vám číst v režimu online nebo offline, ať jste kdekoliv.

Notebooky a počítače

Audioknihy zakoupené na Google Play můžete poslouchat pomocí webového prohlížeče v počítači.

Čtečky a další zařízení

Pokud chcete číst knihy ve čtečkách elektronických knih, jako např. Kobo, je třeba soubor stáhnout a přenést do zařízení. Při přenášení souborů do podporovaných čteček elektronických knih postupujte podle podrobných pokynů v centru nápovědy.