MySQL workbench : data modeling and development
Material type:
TextSeries: Publication details: New York : McGraw-Hill Education, [2013] ©2013Description: xvii, 456 pages : illustrationsISBN: 9780071791885; 0071791884Subject(s): MySQL (Electronic resource) | DatabasesDDC classification: 005.7565 | Item type | Current library | Collection | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
Reference Books
|
Main Library Reference | Reference | 005.7565 MAC (Browse shelf(Opens below)) | Available | 016118 |
Browsing Main Library shelves, Shelving location: Reference, Collection: Reference Close shelf browser (Hides shelf browser)
| No cover image available | ||||||||
| 005.7565 LIN Data analysis using SQL and Excel | 005.7565 LIT Access 97 developer's handbook | 005.7565 LIT Access 2000 developer's handbook | 005.7565 MAC MySQL workbench : data modeling and development | 005.7565 MAR Modern data warehousing, mining, and visualization : core concepts | 005.7565 MAT Beginning databases with MySQL | 005.7565 MEN Expert oracle JDBC programming |
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.
There are no comments on this title.