MySQL workbench : data modeling and development (Record no. 44883)

MARC details
000 -LEADER
fixed length control field 03445nam a22001937i 4500
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
ISBN 9780071791885
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
ISBN 0071791884
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.7565
Item number MAC
100 1# - MAIN ENTRY--AUTHOR NAME
Personal name McLaughlin, Michael
245 10 - TITLE STATEMENT
Title MySQL workbench : data modeling and development
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication New York :
Name of publisher McGraw-Hill Education,
Year of publication [2013] ©2013
300 ## - PHYSICAL DESCRIPTION
Number of Pages xvii, 456 pages :
Other physical details illustrations ;
490 1# - SERIES STATEMENT
Series statement Oracle
505 ## - FORMATTED CONTENTS NOTE
Formatted contents note Machine generated contents note: pt. I Configuration --<br/>1. Installing and Configuring --<br/>Fedora Linux --<br/>Install and Configure MySQL Products --<br/>Mac OS X --<br/>Install MySQL Products --<br/>Microsoft Windows --<br/>Pre-install Microsoft Redistributable Libraries --<br/>Install MySQL Products --<br/>Summary --<br/>Mastery Check --<br/>2. Creating and Managing Connections --<br/>Fedora --<br/>Mac OS X --<br/>Windows 7 --<br/>Configuring MySQL Workbench Connections --<br/>Configuring Server Administration --<br/>Summary --<br/>Mastery Check --<br/>pt. II Data Modeling --<br/>3. Data Modeling Concepts --<br/>Data Modeling Theory --<br/>What Is Data Modeling? --<br/>Why Is Data Modeling Important? --<br/>How Do We Accomplish It? --<br/>Data Modeling Systems --<br/>Binary Relationships --<br/>N-ary Relationships --<br/>Notation Sets --<br/>Classic Normalization --<br/>First Normal Form --<br/>Second Normal Form --<br/>Third Normal Form --<br/>Summary --<br/>Mastery Check --<br/>4. Creating and Managing Tables and Relations --<br/>Opening and Saving Files --<br/>Creating Tables and Views --<br/>Add Tables --<br/>Add Columns --<br/>Add Indexes --<br/>Add Foreign Keys --<br/>Creating Views --<br/>Creating Routines --<br/>Creating Relationships --<br/>Summary --<br/>Mastery Check --<br/>5. Creating and Managing Routines --<br/>Adding a Routine --<br/>Editing a Routine --<br/>Removing a Routine --<br/>Summary --<br/>Mastery Check --<br/>6. Reverse Engineering --<br/>Reverse Engineering a Database --<br/>Forward Engineering a Database --<br/>Forward Engineering from an EER Model --<br/>Forward Engineering from a Script --<br/>Summary --<br/>Mastery Check --<br/>pt. III SQL Development --<br/>7. Editing Data --<br/>Connecting to Edit Data --<br/>Insert Data --<br/>Update Data --<br/>Delete Data --<br/>Multiple Data Edits --<br/>Summary --<br/>Mastery Check --<br/>8. Managing SQL Scripts --<br/>Opening a SQL File --<br/>Running a SQL File --<br/>Summary --<br/>Mastery Check --<br/>pt. IV^ Server Administration --<br/>9. Instances --<br/>Create a Local Instance Manager Note continued: Create a Remote Instance Manager --<br/>Manage an Existing Instance --<br/>Maintain Existing Instance Managers --<br/>Summary --<br/>Mastery Check --<br/>10. Creating and Managing Users and Roles --<br/>Adding a User --<br/>Adding Schema Privileges --<br/>Summary --<br/>Mastery Check --<br/>11. Imports and Exports --<br/>Exporting a Database --<br/>Importing a Database --<br/>Summary --<br/>Mastery Check --<br/>12. Migrating Databases --<br/>Exporting a Database --<br/>Summary --<br/>Mastery Check --<br/>pt. V Appendixes and Glossary --<br/>A. Mastery Check Answers --<br/>Chapter 1 --<br/>Chapter 2 --<br/>Chapter 3 --<br/>Chapter 4 --<br/>Chapter 5 --<br/>Chapter 6 --<br/>Chapter 7 --<br/>Chapter 8 --<br/>Chapter 9 --<br/>Chapter 10 --<br/>Chapter 11 --<br/>Chapter 12 --<br/>B. Extending MySQL Workbench --<br/>Scripts --<br/>Modules --<br/>Shell --<br/>Summary --<br/>C. Setting Up SQL Server --<br/>Installing SQL Server --<br/>Fixing the SQL Server Command-line Interface --<br/>Configuring a User Schemata --<br/>Creating and Seeding a Database --<br/>Summary.
520 ## - SUMMARY, ETC.
Summary, etc The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical Term MySQL (Electronic resource)
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical Term Databases
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Koha item type Reference Books
Holdings
Collection code Home library Current library Shelving location Date acquired Source of acquisition Cost, normal purchase price Full call number Accession Number Koha item type
Reference Main Library Main Library Reference 08/11/2021 Purchase 8415.00 005.7565 MAC 016118 Reference Books

© University of Vavuniya

---