Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
ACKNOWLEDGMENTS
INTRODUCTION
PART 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
PART 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
PART 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
PART IV
Server Administration
9 Instances
Create a Local Instance Manager
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
PART 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
Glossary
Index
← Prev
Back
Next →
← Prev
Back
Next →