MySQL workbench data modeling and development
'MySQL Workbench Data Modeling and Development' helps developers learn how to effectively use this powerful product for database modelling, reverse engineering, and interaction with the database without writing SQL statements.
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill Education
2013.
|
| Edición: | 1st edition |
| Colección: | Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628239506719 |
Tabla de Contenidos:
- Cover
- About the Author
- About the Technical Editor
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- Who Should Read This Book
- What This Book Covers
- How to Use This Book
- How This Book Is Organized
- Part I: Configuration
- Part II: Data Modeling
- Part III: SQL Development
- Part IV: Server Administration
- Part V: Appendixes and Glossary
- Example Code with This Book
- 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.
