"MySQL Workbench Data Modeling and development"

the MySQL Workbench modeling and development of data

Basic information

Original title: MySQL workbench:data Modeling & Development

Original publishing house: Mcgraw-hill Osborne Media

(Mei) McLaughlin (McLaughlin, M.)

Translator: Zhang June Wen

Publishing house: Tsinghua University Press

isbn:9787302363712

Last Date: 2014-6-5

Publication date: June 2014

Folio: 16 Open

Page: 368

Edition: 1-1

Category: Computers > Databases > MySQL

more about the "" "MySQL Workbench Data Modeling and development"

Content Introduction

Books

Computer Books

Build and maintain a world-class MySQL database, execute effective queries and gain insight into enterprise data

MySQL Workbench Data modeling and development provides some proven strategies, best practices, and detailed examples. These include installing MySQL Workbench, creating a database model, configuring and deploying databases, authenticating users, visualizing design scripts, and optimizing system performance. In this book, reverse engineering, database migration and security are all involved.

Main content

Installing MySQL Workbench

Build and configure MySQL database

Establish, test, and manage connections

involves a precise relational data model

Creating functions, procedures, and triggers

Reverse-engineer The database and capture the definition

Writing, debugging, and deploying user scripts

Maintaining local and remote instance managers

Granting user rights at the system or mode level

Migration and integration of older versions of databases

Directory

"MySQL Workbench Data modeling and development"

Section Ⅰ Configuration

1th Chapter Installation and Configuration 3

1.1 Fedora Linux 4

1.2 Mac OS X 13

1.3 Microsoft Windows 25

1.3.1 Pre-Installing the Microsoft Redistributable Library 28

1.3.2 Installing MySQL Products 32

1.4 Summary of this chapter 53

1.5 This chapter examines the contents of 53

2nd Chapter Creating and Managing Connections 55

2.1 Fedora 56

2.2 Mac OS X 63

2.3 Windows 7 68

2.3.1 Configuring MySQL Workbench Connection 68

2.3.2 Configuring server Administration 75

2.4 Summary of this chapter 80

2.5 This chapter examines the contents of 80

Section Ⅱ Data Modeling

3rd Concept of Data Modeling 85

3.1 Data Modeling Theory 86

3.1.1 What is Data modeling 86

3.1.2 Why is data modeling important 88

3.1.3 How to implement it 93

3.2 Data Modeling System 95

3.2.12 Yuan Relationship 97

3.2.2 N-ary Relationship 100

3.2.3 Symbol SET 100

3.3 Classic Normalization 103

3.3.1 First Paradigm 104

3.3.2 Second Paradigm 107

3.3.3 Third Paradigm 108

3.4 Summary of this chapter 110

3.5 This chapter examines the contents of 110

4th chapter Creating and Managing Tables and relationships 113

4.1 Opening and saving a file 114

4.2 Creating tables and views 116

4.2.1 Adding a table 117

4.2.2 Adding Columns 118

4.2.3 Adding an index 121

4.2.4 Adding a foreign key 123

4.2.5 Creating a View 126

4.2.6 Creating a routine 127

4.3 Creating a Relationship 128

4.4 Summary of this chapter 132

4.5 This chapter examines the contents of 132

Chapter 5th Creating and Managing routines 135

5.1 Adding a routine 136

5.2 Editing Routines 144

5.3 Deleting Routines 145

5.4 Summary of this chapter 145

5.5 This chapter examines the contents of 145

The 6th Chapter Reverse engineering 147

6.1 Reverse engineer a database 148

6.2 Forward Engineering One database 157

6.2.1 starting from EER model forward Engineering 158

6.2.2 Forward Engineering by script 165

6.3 Summary of this chapter 171

6.4 This chapter examines the contents of 171

Section Ⅲ SQL Development

7th. Edit Data 175

7.1 Connecting to edit data 176

7.2 Inserting Data 180

7.3 Update Data 185

7.4 Deleting Data 187

7.5 Multi-Data editing 190

7.6 Summary of this chapter 192

7.7 This chapter examines the contents of 192

Chapter 8th Managing SQL Scripts 195

8.1 Open SQL File 196

8.2 Running SQL file 200

8.3 Summary of this chapter 203

8.4 This chapter examines the contents of 203

Section Ⅳ Server Management

Chapter 9th Example 207

9.1 Creating an on-premises instance manager 208

9.2 Creating a remote instance Manager 214

9.3 Managing existing Instances 220

9.4 Maintaining the existing instance Manager 224

9.5 Summary of this chapter 225

9.6 This chapter examines the contents of 225

10th chapter Creating and Managing Users and Roles 229

10.1 Adding users 230

10.2 Add mode Privilege 238

10.3 Summary of this chapter 243

10.4 This chapter examines the contents of 243

Chapter 11th Import and Export 247

11.1 Exporting a database 248

11.2 Importing a database 254

11.3 Summary of this chapter 259

11.4 This chapter examines the contents of 259

12th. Database Migration 261

12.1 Migrating a Database 262

12.2 Summary of this chapter 277

12.3 This chapter examines the contents of 277

Section Ⅴ Appendices and Glossary

Appendix A content Examination Answer 281

Appendix B MySQL Workbench Extension 305

Appendix C Installing SQL Server 319

Glossary Database Modeling Terminology 343

the source of this book information: Interactive Publishing Network