Экзамены по переходу с MySQL 4.0 на MySQL 5.0

• 007-001: Core to Certified 5.0 Developer Upgrade
• 008-001: Professional to 5.0 Certified DBA Upgrade

• Triggers (10%)
  
  
  • Reasons to Use Triggers
  • Trigger Concepts
  • Creating a Trigger
  • Referring to Old and New Column Values
  • Destroying a Trigger
• Stored Routines (20%)
  
  
  • Benefits of Stored Routines
  • Differences Between Stored Procedures and Functions
  • Creating Stored Routines
  • Obtaining Stored Routine Metadata
• Client/Server Concepts (5%)
  
  
  • Server SQL modes
• The mysql Client Program (5%)
  
  
  • Using Server-Side Help
• Data Types (10%)
  
  
  • Numeric Data Types
  • The BIT Data Type
  • String Data Types
  • Temporal Data Types
  • Handling Missing or Invalid Data Values
• SQL Expressions (5%)
  
  
  • Numeric Expressions
  • String Expressions
  • Functions in SQL Expressions
• User Variables (5%)
  
  
  • User Variable Syntax
  • User Variable Properties
• Prepared Statements (5%)
  
  
  • Benefits of Prepared Statements
  • Preparing a Statement
  • Executing a Prepared Statement
  • Deallocating a Prepared Statement
• 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
• 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
• Databases (5%)
  
  
  • Database Properties
  • Creating Databases
  • Obtaining Database Metatdata

• Triggers (10%)
  • Reasons to Use Triggers
  • Trigger Concepts
  • Destroying a Trigger
• Stored Routines (20%)
  • Benefits of Stored Routines
  • Creating Stored Routines
  • Obtaining Stored Routine Metadata
  • Using Stored Routines and Triggers for Security Purposes
  • Using Stored Routines to Enhance Performance
• Data Types (5%)
  • Numeric Data Types
  • String Data Types
  • Handling Missing or Invalid Data Values
• SQL Expressions (5%)
  • Numeric Expressions
  • String Expressions
• Views (10%)
  • Reasons to Use Views
  • Creating Views
  • Dropping Views
  • Displaying Information About Views
• Obtaining Database Metadata (15%)
  • Using INFORMATION_SCHEMA to Obtain Metadata
  • INFORMATION_SCHEMA Access Syntax
  • INFORMATION_SCHEMA Versus SHOW
  • Limitations of INFORMATION_SCHEMA
• Starting, Stopping, and Configuring MySQL (5%)
  • Loading Time Zone Tables
  • Setting the Default SQL Mode
  • Upgrading MySQL
• Storage Engines (15%)
  • MySQL Storage Engines
  • The InnoDB Engine
  • The MEMORY Engine
  • The FEDERATED Engine
• Character Set Support (5%)
  • Performance Issues
  • Choosing Data Types for Character Columns
• User Management (5%)
  • User Account Management
• Upgrade-Related Security Issues (5%)
  • Upgrading the Privilege Tables
  • Security-Related SQL Mode Values

• • Creating a Trigger
  • Referring to Old and New Column Values
  • Destroying a Trigger
• Stored Routines (20%)
  • Benefits of Stored Routines
  • Differences Between Stored Procedures and Functions
  • Creating Stored Routines
  • Obtaining Stored Routine Metadata
• Client/Server Concepts (5%)
  • Server SQL modes
• The mysql Client Program (5%)
  • Using Server-Side Help
• Data Types (10%)
  • Numeric Data Types
  • The BIT Data Type
  • String Data Types
  • Temporal Data Types
  • Handling Missing or Invalid Data Values
• SQL Expressions (5%)
  • Numeric Expressions
  • String Expressions
  • Functions in SQL Expressions
• User Variables (5%)
  • User Variable Syntax
  • User Variable Properties
• Prepared Statements (5%)
  • Benefits of Prepared Statements
  • Preparing a Statement
  • Executing a Prepared Statement
  • Deallocating a Prepared Statement
• 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
• 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
• Databases (5%)
  • Database Properties
  • Creating Databases
  • Obtaining Database Metatdata