Сертификат MySQL 5.0 Developer (CMDEV)

• Client/Server Concepts (5%)
• General MySQL Architecture
• Invoking Client Programs
• Server SQL Modes
• The mysql Client Program (10%)
• Using mysql Interactively
• Statement Terminators
• The mysql Prompts
• Editing Keys in mysql
• Using Script Files with MySQL
• mysql Output Formats
• Client Commands and SQL Statements
• Using Server-Side Help
• Using the --safe-updates Option
• Connectors (5%)
• MySQL Client Interfaces
• Connector/ODBC
• Connector/J
• Connector/NET
• Data Types (15%)
• Numeric Data Types
• The BIT Data Type
• String Data Types
• Temporal Data Types
• Column Attributes
• Using the AUTO_INCREMENT Column Attribute
• Handling Missing or Invalid Data Values
• Identifiers (5%)
• Identifier Syntax
• Case Sensitivity
• Using Qualifed Names
• Reserved Words as Identifiers
• Databases (5%)
• Database Properties
• Creating Databases
• Altering Databases
• Dropping Databases
• Obtaining Database Metatdata
• Tables and Indexes (15%)
• Table Properties
• Creating Tables
• Altering Tables
• Emptying Tables
• Dropping Tables
• Indexes
• Dropping Indexes
• Obtaining Table and Index Metadata
• Querying for Data (15%)
• Using SELECT to Retrieve Data
• Specifying Which Columns to Retrieve
• Specifying Which Rows to Retrieve
• Aggregating Results
• Grouping Results
• Using UNION
• SQL Expressions (15%)
• Components of SQL Expressions
• Numeric Expressions
• String Expressions
• Temporal Expressions
• NULL Values
• Functions in SQL Expressions
• Comments in SQL Statements
• Updating Data (10%)
• Update Operations
• The INSERT Statement
• The REPLACE Statement
• The UPDATE Statement
• The DELETE and TRUNCATE TABLE Statements
• Privileges Required for Update Statements

• Joins (10%)
• Overview
• Writing Inner Joins
• Writing Outer Joins
• Resolving Name Clashes Using Qualifiers and Aliases
• Multiple-Table UPDATE and DELETE Statements
• Subqueries (10%)
• Types of Subqueries
• Subqueries as Scalar Expressions
• Correlated Subqueries
• Comparing Subquery Results to Outer Query Columns
• Comparison Using Row Subqueries
• Using Subqueries in the FROM Clause
• Converting Subqueries to Joins
• Using Subqueries in Updates
• Views (15%)
• Reasons to Use Views
• Creating Views
• Altering Views
• Dropping Views
• Checking Views
• Displaying Information About Views
• Privileges for Views
• Importing and Exporting Data (5%)
• Import and Export Operations
• Importing and Exporting Using SQL
• Importing and Exporting Data from the Command Line
• User Variables (5%)
• User Variable Syntax
• User Variable Properties
• Prepared Statements (5%)
• Benefits of Prepared Statements
• Using Prepared Statements from the mysql Client
• Preparing a Statement
• Executing a Prepared Statement
• Deallocating a Prepared Statement
• Stored Routines (20%)
• Benefits of Stored Routines
• Differences Between Stored Procedures and Functions
• The Namespace for Stored Routines
• Defining Stored Routines
• Creating Stored Routines
• Altering Stored Routines
• Dropping Stored Routines
• Invoking Stored Routines
• Obtaining Stored Routine Metadata
• Stored Routine Privileges and Execution Security
• Triggers (5%)
• Reasons to Use Triggers
• Trigger Concepts
• Creating a Trigger
• Restrictions on Triggers
• Referring to Old and New Column Values
• Destroying a Trigger
• Privileges Required for Triggers
• Obtaining Database Metadata (10%)
• Overview of Metadata Access Methods
• Using INFORMATION_SCHEMA to Obtain Metadata
• Using SHOW and DESCRIBE to Obtain Metadata
• Using mysqlshow to Obtain Metadata
• Debugging MySQL Applications (5%)
• Interpreting Error Messages
• The SHOW WARNINGS Statement
• The SHOW ERRORS Statement
• The perror Utility
• Basic Optimizations (10%)
• Overview of Optimization Principles
• Using Indexes for Optimization
• General Query Enhancement
• Choosing Appropriate Storage Engines
• Normalization