MySQL AB :: MySQL 5.0 Certification Candidate Guide

MySQL AB :: MySQL 5.0 Certification Candidate Guide

Upgrade Exams

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

Only these two upgrade paths are available. If you wish to upgrade a MySQL 4 Core exam to MySQL 5.0 DBA, you must either first pass the MySQL 4 Professional exam, then take the upgrade exam. Alternatively, you can choose to take the two MySQL 5.0 DBA exams instead.

For each upgrade exam, also read the notes above for the certification that you are upgrading to.

The upgrade exams have the following content:
Exam Contents - Core to Certified 5.0 Developer Upgrade

* Triggers (10%)
o Referring to Old and New Column Values
o Destroying
o Reasons to Use Triggers
o Creating
o Trigger Concepts
* Stored Routines (20%)
o Creating Stored Routines
o Differences Between Stored Procedures and Function
o Benefits of Stored Routines
o Obtaining Stored Routine Metadata
* Client/Server Concepts (5%)
o Server SQL modes
* The mysql Client Program (5%)
o Using server-side help
* Data Types (10%)
o Numeric Data Types
o String Data Types
o Handling Missing or Invalid Data Values
o Temporal Data Types
o The BIT Data Type
* SQL expressions (5%)
o Functions in SQL expressions
o String Expressions
o Numeric Expressions
* User Variables (5%)
o User Variable Syntax
o User Variable Properties
* Prepared Statements (5%)
o Preparing
o Executing
o Deallocating Prepared Statements
o Benefits of Prepared Statements
* Subqueries (10%)
o Types of Subqueries
o Comparing Subquery Results to Outer Query Columns
o Subqueries as Scalar Expressions
o Using Subqueries in Updates
o Using Subqueries in the FROM Clause
o Correlated Subqueries
o Comparison Using Row Subqueries
o Converting Subqueries to Joins
* Views (15%)
o Creating views
o Reasons to use views
o Altering views
o Checking views
o Privileges for views
o Dropping a view
o Displaying information about views
* Obtaining Database Metadata (10%)
o Overview of Metadata Access Methods
o Using INFORMATION_SCHEMA to Obtain Metadata
o Using mysqlshow to Obtain Metadata
o Using SHOW and DESCRIBE to Obtain Metadata
* Databases (5%)
o Database properties
o Creating Databases
o Obtaining Database Metatdata