
MySQL Workbench
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Cover
- About the Author
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- Part I: Configuration
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 5: Creating and Managing Routines
- Adding a Routine
- Editing a Routine
- Removing a Routine
- Summary
- Mastery Check
- Chapter 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
- Chapter 7: Editing Data
- Connecting to Edit Data
- Insert Data
- Update Data
- Delete Data
- Multiple Data Edits
- Summary
- Mastery Check
- Chapter 8: Managing SQL Scripts
- Opening a SQL File
- Running a SQL File
- Summary
- Mastery Check
- Part IV: Server Administration
- Chapter 9: Instances
- Create a Local Instance Manager
- Create a Remote Instance Manager
- Manage an Existing Instance
- Maintain Existing Instance Managers
- Summary
- Mastery Check
- Chapter 10: Creating and Managing Users and Roles
- Adding a User
- Adding Schema Privileges
- Summary
- Mastery Check
- Chapter 11: Imports and Exports
- Exporting a Database
- Importing a Database
- Summary
- Mastery Check
- Chapter 12: Migrating Databases
- Exporting a Database
- Summary
- Mastery Check
- Part V: Appendixes and Glossary
- Appendix 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
- Appendix B: Extending MySQL Workbench
- Scripts
- Modules
- Shell
- Summary
- Appendix 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: Database Modeling Terms
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.