If you are already certified for MySQL 4 (Core or Professional certification), you can upgrade your certification by taking a single exam:
- 007-001: Core to Certified 5.0 Developer Upgrade
- 008-001: Professional to 5.0 Certified DBA Upgrade
For each upgrade exam, also read the notes earlier in this guide for the certification that you are upgrading to.
Основные разделы экзамена Core to Certified 5.0 Developer 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
Основные разделы экзамена Professional to 5.0 Certified DBA Upgrade
- 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