MySQL Certifications Oracle Exams
MySQL Certifications Oracle currently offers two certification exams. Exam 1Z0-883 is for the Oracle Certified
Professional, MySQL 5.6 Database Administrator certification and exam 1Z0-882 is for Oracle Certified
Professional, MySQL 5.6 Developer certiciation. As of September 2015 there is a 20% discount for those taking both exams that includes one free retake. See https://www.mysql.com/certification/
MySQL 5.6 Database Administrator
Exam price is $245 Exam length is 150 minutes Number of questions is 100 multiple choice format Passing score is 64 percent Subject matter is based on General Availability (GA) versions of MySQL 5.6.
Exam topics
MySQL Architecture
- Use MySQL client programs to interface with the MySQL Server interactively and in batch
- Describe how MySQL uses disk and memory resources
- List and describe key characteristics of standard MySQL storage engines including
InnoDB, NDB, MyISAM, MEMORY, FEDERATED
MySQL Server Installation, Configuration and Maintenance
- Configure MySQL Server deployments using options files, command-line options and server variables.
- Identify, configure, locate and describe appropriate use cases for MySQL the error, binary, general query and slow query log.
MySQL Security
- Describe appropriate steps to secure a MySQL deployment at the operating system, filesystem and network levels.
- Create and maintain user accounts with appropriate privileges and configuration.
- Deploy and configure MySQL Enterprise Audit
Diagnostic Data and Metadata Sources in MySQL
- Configure and leverage PERFORMANCE_SCHEMA tables to identify and diagnose performance problems.
- Obtain MySQL metadata from INFORMATION_SCHEMA tables
Optimizing MySQL Performance
- Demonstrate ability to diagnose and optimize poorly-performing queries.
Tune MySQL Server configuration for best performance.
- Apply best practices in optimizing schema objects Demonstrate understanding of locking concepts as applied to MySQL Server and storage engines.
- Create and utilize table PARTITIONING
Backups and Recovery in MySQL
- Create and restore logical backups using mysqldump
- Create and restore binary backups
High Availability Techniques for MySQL
- Describe, configure, deploy and troubleshoot MySQL replication
- Describe and contrast characteristics of common MySQL high availability solutions (MySQL Cluster, DRBD, Windows Failover Clustering, Solaris Cluster, OVM Template for MySQL Enterprise)
MySQL 5.6 Developer
Exam price is $245 Exam length is 150 minutes Number of questions is 100 multiple choice format Passing score is 64 percent Subject matter is based on General Availability (GA) versions of MySQL 5.6.
Exam Topics
MySQL Architecture
General MySQL Syntax
- Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
- Identify MySQL data type properties and appropriate usage
- Recognize and use common functions and expressions for all MySQL data types
- Identify and use comment syntax
- Describe and utilize prepared statements
- Describe transactions and transaction isolation levels and the impact they have on database behavior
Creation and Design of MySQL Schema Objects
- Design and create normalized databases
- Create and modify tables using appropriate data types and indexing
- Describe and create table constraints enforcing data integrity
- Creating and modifying views
- Identify and use various methods to obtain metadata for MySQL database objects
Creation, Design and Use of MySQL Stored Programs
Describe and use triggers
- Create and execute stored procedures
- Create and use stored functions
- Implement error handling within stored procedures
Querying for Data
- Execute a basic SELECT statement
- Limit rows returned by a SELECT statement
- Limit columns returned by a SELECT statement
- Apply sorting to SELECT statement results
- Execute SELECT statements which aggregate and group data
Modifying Data
- Describe and execute INSERT statements
- Describe and execute REPLACE statements
- Describe and execute UPDATE statements
- Describe and execute TRUNCATE statements
- Describe and execute LOAD DATA statements
- Describe and execute DELETE statements
Joins, subqueries and UNION
- Identify, describe and use JOINs in MySQL commands
- Describe and utilize subqueries in MySQL commands
- Perform operations using UNION clause
MySQL Application Development
- Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
- Write a basic Java application that uses MySQL
- Write a basic PHP application that uses MySQL
- Write a basic .NET application that uses MySQL
- Interpret MySQL error messages
- Collect available diagnostic information
- Describe and use NoSQL and memcached API
Basic Optimizations
- Identify statements requiring optimization
- Recognize and create optimal indexes for query optimization
- Recognize and fix sub-optimal SQL commands
- Identify appropriate optimization strategies for InnoDB usage
- Optimize performance through data normalization