MySQL 5.0 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 312
Pages: 312
- MySQL 5 Certification Study Guide
- Table of Contents
- Copyright
- Foreword
- About the Authors
- Acknowledgments
- References
- We Want to Hear from You
- Introduction
- About This Book
- Sample Exercises
- Other Required Reading
- Conventions Used in This Book
- About the Exams
- Interpreting DESCRIBE Output
- Sample Tables
- MySQL Developer Exams
- MySQL Developer I Exam
- Chapter 1. ClientServer Concepts
- 1.1. General MySQL Architecture
- 1.2. Invoking Client Programs
- 1.3. Server SQL Modes
- Chapter 2. The mysql Client Program
- 2.1. Using mysql Interactively
- 2.2. Statement Terminators
- 2.3. The mysql Prompts
- 2.4. Using Editing Keys in mysql
- 2.5. Using Script Files with mysql
- 2.6. mysql Output Formats
- 2.7. Client Commands and SQL Statements
- 2.8. Using Server-Side Help
- 2.9. Using the --safe-updates Option
- Chapter 3. MySQL Query Browser
- 3.1. MySQL Query Browser Capabilities
- 3.2. Using MySQL Query Browser
- 3.3. Using the Query Window
- 3.4. The MySQL Table Editor
- 3.5. Connection Management
- 3.6. The Options Dialog
- Chapter 4. MySQL Connectors
- 4.1. MySQL Client Interfaces
- 4.2. MySQL ConnectorODBC
- 4.3. MySQL ConnectorJ
- 4.4. MySQL ConnectorNET
- Chapter 5. Data Types
- 5.1. Data Type Overview
- 5.2. Numeric Data Types
- 5.3. The BIT Data Type
- 5.4. String Data Types
- 5.5. Temporal Data Types
- 5.6. Column Attributes
- 5.7. Using the AUTO_INCREMENT Column Attribute
- 5.8. Handling Missing or Invalid Data Values
- Chapter 6. Identifiers
- 6.1. Identifier Syntax
- 6.2. Case Sensitivity of Identifiers
- 6.3. Using Qualified Names
- 6.4. Using Reserved Words as Identifiers
- Chapter 7. Databases
- 7.1. Database Properties
- 7.2. Creating Databases
- 7.3. Altering Databases
- 7.4. Dropping Databases
- 7.5. Obtaining Database Metadata
- Chapter 8. Tables and Indexes
- 8.1. Table Properties
- 8.2. Creating Tables
- 8.3. Altering Tables
- 8.4. Dropping Tables
- 8.5. Emptying Tables
- 8.6. Indexes
- 8.7. Dropping Indexes
- 8.8. Obtaining Table and Index Metadata
- Chapter 9. Querying for Data
- 9.1. Using SELECT to Retrieve Data
- 9.2. Specifying Which Columns to Retrieve
- 9.3. Specifying Which Rows to Retrieve
- 9.4. Aggregating Results
- 9.5. Grouping Results
- 9.6. Using UNION
- Chapter 10. SQL Expressions
- 10.1. Components of SQL Expressions
- 10.2. Numeric Expressions
- 10.3. String Expressions
- 10.4. Temporal Expressions
- 10.5. NULL Values
- 10.6. Functions in SQL Expressions
- 10.7. Comments in SQL Statements
- Chapter 11. Updating Data
- 11.1. Update Operations
- 11.2. The INSERT Statement
- 11.3. The REPLACE Statement
- 11.4. The UPDATE Statement
- 11.5. The DELETE and trUNCATE TABLE Statements
- 11.6. Privileges Required for Update Statements
- MySQL Developer II Exam
- Chapter 12. Joins
- 12.1. Overview
- 12.2. Writing Inner Joins
- 12.3. Writing Outer Joins
- 12.4. Resolving Name Clashes Using Qualifiers and Aliases
- 12.5. Multiple-Table UPDATE and DELETE Statements
- Chapter 13. Subqueries
- 13.1. Types of Subqueries
- 13.2. Subqueries as Scalar Expressions
- 13.3. Correlated Subqueries
- 13.4. Comparing Subquery Results to Outer Query Columns
- 13.5. Comparison Using Row Subqueries
- 13.6. Using Subqueries in the FROM Clause
- 13.7. Converting Subqueries to Joins
- 13.8. Using Subqueries in Updates
- Chapter 14. Views
- 14.1. Reasons to Use Views
- 14.2. Creating Views
- 14.3. Altering Views
- 14.4. Dropping Views
- 14.5. Checking Views
- 14.6. Obtaining View Metadata
- 14.7. Privileges Required for Views
- Chapter 15. Importing and Exporting Data
- 15.1. Import and Export Operations
- 15.2. Importing and Exporting Using SQL
- 15.3. Importing and Exporting Data from the Command Line
- Chapter 16. User Variables
- 16.1. User Variable Syntax
- 16.2. User Variable Properties
- Chapter 17. Prepared Statements
- 17.1. Benefits of Prepared Statements
- 17.2. Using Prepared Statements from the mysql Client
- 17.3. Preparing a Statement
- 17.4. Executing a Prepared Statement
- 17.5. Deallocating Prepared Statements
- Chapter 18. Stored Procedures and Functions
- 18.1. Benefits of Stored Routines
- 18.2. Differences Between Stored Procedures and Functions
- 18.3. The Namespace for Stored Routines
- 18.4. Defining Stored Routines
- 18.5. Creating Stored Routines
- 18.6. Altering Stored Routines
- 18.7. Dropping Stored Routines
- 18.8. Invoking Stored Routines
- 18.9. Obtaining Stored Routine Metadata
- 18.10. Stored Routine Privileges and Execution Security
- Chapter 19. Triggers
- 19.1. Reasons to Use Triggers
- 19.2. Trigger Concepts
- 19.3. Creating a Trigger
- 19.4. Restrictions on Triggers
- 19.5. Referring to Old and New Column Values
- 19.6. Destroying a Trigger
- 19.7. Privileges Required for Triggers
- Chapter 20. Obtaining Database Metadata
- 20.1. Overview of Metadata Access Methods
- 20.2. Using INFORMATION_SCHEMA to Obtain Metadata
- 20.3. Using SHOW and DESCRIBE to Obtain Metadata
- 20.4. Using mysqlshow to Obtain Metadata
- Chapter 21. Debugging MySQL Applications
- 21.1. Interpreting Error Messages
- 21.2. The SHOW WARNINGS Statement
- 21.3. The SHOW ERRORS Statement
- 21.4. The perror Utility
- Chapter 22. Basic Optimizations
- 22.1. Overview of Optimization Principles
- 22.2. Using Indexes for Optimization
- 22.3. General Query Enhancement
- 22.4. Choosing Appropriate Storage Engines
- 22.5. Normalization
- MySQL DBA Exams
- MySQL DBA I Exam
- Chapter 23. MySQL Architecture
- 23.1. ClientServer Overview
- 23.2. Communication Protocols
- 23.3. The SQL Parser and Storage Engine Tiers
- 23.4. How MySQL Uses Disk Space
- 23.5. How MySQL Uses Memory
- Chapter 24. Starting, Stopping, and Configuring MySQL
- 24.1. Types of MySQL Distributions
- 24.2. Starting and Stopping MySQL Server on Windows
- 24.3. Starting and Stopping MySQL Server on Unix
- 24.4. Runtime MySQL Configuration
- 24.5. Log and Status Files
- 24.6. Loading Time Zone Tables
- 24.7. Security-Related Configuration
- 24.8. Setting the Default SQL Mode
- 24.9. Upgrading MySQL
- Chapter 25. Client Programs for DBA Work
- 25.1. Overview of Administrative Clients
- 25.2. MySQL Administrator
- 25.3. mysql
- 25.4. mysqladmin
- 25.5. mysqlimport
- 25.6. mysqldump
- 25.7. Client Program Limitations
- Chapter 26. MySQL Administrator
- 26.1. MySQL Administrator Capabilities
- 26.2. Using MySQL Administrator
- 26.3. Server Monitoring Capabilities
- 26.4. Server Configuration
- 26.5. Backup and Restore Capabilities
- 26.6. MySQL Administrator System Tray Monitor
- Chapter 27. Character Set Support
- 27.1. Performance Issues
- 27.2. Choosing Data Types for Character Columns
- Chapter 28. Locking
- 28.1. Locking Concepts
- 28.2. Explicit Table Locking
- 28.3. Advisory Locking
- Chapter 29. Storage Engines
- 29.1. MySQL Storage Engines
- 29.2. The MyISAM Engine
- 29.3. The MERGE Engine
- 29.4. The InnoDB Engine
- 29.5. The MEMORY Engine
- 29.6. The FEDERATED Engine
- 29.7. The Cluster Storage Engine
- 29.8. Other Storage Engines
- Chapter 30. Table Maintenance
- 30.1. Types of Table Maintenance Operations
- 30.2. SQL Statements for Table Maintenance
- 30.3. Client and Utility Programs for Table Maintenance
- 30.4. Repairing InnoDB Tables
- 30.5. Enabling MyISAM Auto-Repair
- Chapter 31. The INFORMATION_SCHEMA Database
- 31.1. INFORMATION_SCHEMA Access Syntax
- 31.2. INFORMATION_SCHEMA Versus SHOW
- 31.3. Limitations of INFORMATION_SCHEMA
- Chapter 32. Data Backup and Recovery Methods
- 32.1. Introduction
- 32.2. Binary Versus Textual Backups
- 32.3. Making Binary Backups
- 32.4. Making Text Backups
- 32.5. Backing Up Log and Status Files
- 32.6. Replication as an Aid to Backup
- 32.7. MySQL Cluster as Disaster Prevention
- 32.8. Data Recovery
- MySQL DBA II Exam
- Chapter 33. Using Stored Routines and Triggers for Administration
- 33.1. Using Stored Routines and Triggers for Security Purposes
- 33.2. Using Stored Routines to Enhance Performance
- Chapter 34. User Management
- 34.1. User Account Management
- 34.2. Client Access Control
- Chapter 35. Securing the MySQL Installation
- 35.1. Security Issues
- 35.2. Operating System Security
- 35.3. Filesystem Security
- 35.4. Log Files and Security
- 35.5. Network Security
- 35.6. FEDERATED Table Security
- Chapter 36. Upgrade-Related Security Issues
- 36.1. Upgrading the Privilege Tables
- 36.2. Security-Related SQL Mode Values
- Chapter 37. Optimizing Queries
- 37.1. Identifying Candidates for Query Analysis
- 37.2. Using EXPLAIN to Analyze Queries
- 37.3. Using SHOW WARNINGS for Optimization
- 37.4. MyISAM Index Caching
- Chapter 38. Optimizing Databases
- 38.1. General Table Optimizations
- 38.2. Normalization
- 38.3. MyISAM-Specific Optimizations
- 38.4. InnoDB-Specific Optimizations
- 38.5. MERGE-Specific Optimizations
- 38.6. MEMORY-Specific Optimizations
- Chapter 39. Optimizing the Server
- 39.1. Interpreting mysqld Server Information
- 39.2. Measuring Server Load
- 39.3. Tuning Memory Parameters
- 39.4. Using the Query Cache
- Chapter 40. Interpreting Diagnostic Messages
- 40.1. Sources of Diagnostic Information
- 40.2. Using the Error Log for Diagnostic Purposes
- 40.3. Using The Slow Query Log for Diagnostic Purposes
- Chapter 41. Optimizing the Environment
- 41.1. Choosing Hardware for MySQL Use
- 41.2. Configuring Disks for MySQL Use
- 41.3. Network Issues
- 41.4. Optimizing the Operating System for MySQL Use
- Chapter 42. Scaling MySQL
- 42.1. Using Multiple Servers
- 42.2. Replication
- Appendixes
- Appendix A. References
- Appendix B. Other Offers
- Index
- index_SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- index_Y
- index_Z
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 312
Pages: 312