MySQL workbench : data modeling and development

McLaughlin, Michael

MySQL workbench : data modeling and development - New York : McGraw-Hill Education, [2013] ©2013 - xvii, 456 pages : illustrations ; - Oracle .

Machine generated contents note: pt. I Configuration --
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 --
2. Creating and Managing Connections --
Fedora --
Mac OS X --
Windows 7 --
Configuring MySQL Workbench Connections --
Configuring Server Administration --
Summary --
Mastery Check --
pt. II Data Modeling --
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 --
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 --
5. Creating and Managing Routines --
Adding a Routine --
Editing a Routine --
Removing a Routine --
Summary --
Mastery Check --
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 --
pt. III SQL Development --
7. Editing Data --
Connecting to Edit Data --
Insert Data --
Update Data --
Delete Data --
Multiple Data Edits --
Summary --
Mastery Check --
8. Managing SQL Scripts --
Opening a SQL File --
Running a SQL File --
Summary --
Mastery Check --
pt. IV^ Server Administration --
9. Instances --
Create a Local Instance Manager Note continued: Create a Remote Instance Manager --
Manage an Existing Instance --
Maintain Existing Instance Managers --
Summary --
Mastery Check --
10. Creating and Managing Users and Roles --
Adding a User --
Adding Schema Privileges --
Summary --
Mastery Check --
11. Imports and Exports --
Exporting a Database --
Importing a Database --
Summary --
Mastery Check --
12. Migrating Databases --
Exporting a Database --
Summary --
Mastery Check --
pt. V Appendixes and Glossary --
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 --
B. Extending MySQL Workbench --
Scripts --
Modules --
Shell --
Summary --
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.

The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.

9780071791885 0071791884


MySQL (Electronic resource)
Databases

005.7565 / MAC

© University of Vavuniya

---