MySQL 5.6 Developer
MySQL 5.6 Developer
Exam Material
You need to register for free or login to access certification guide and references:
- Mysql 5.6 Reference Manual.
Exam Info
MySQL Architecture
- Use MySQL client programs to interface with the MySQL Server interactively and in batch
- Describe SQL Modes and their impact on behavior of MySQL
- Identify characteristics which have session scope
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
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
Joins, subqueries and UNION
- Identify, describe and use JOINs in MySQL commands
- Describe and utilize subqueries in MySQL commands
- Perform operations using UNION clause
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
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, 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
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
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
Exam Skills
Certification Exam: MySQL 5.6 Developer
| Exam Type | Certification |
|---|---|
| Exam Code | 1Z0-882 |
| Duration | 2 hours, 30 minutes |
| Number Of Question | 86 |
| Success Score | 61% |
| Price | 150$ |
Evaluation Exam: MySQL 5.6 Developer
| Exam Type | Evaluation |
|---|---|
| Exam Code | 1Z0-882-eval |
| Duration | 1 hour |
| Number Of Question | 40 |
| Success Score | 61% |
| Price | 40$ |