1Z0-882: MySQL 5.6 Developer

Full Name: MySQL 5.6 Developer

Exam Code: 1Z0-882

Try Sample Exam »

Oracle 1Z0-882 Exam Details:

Exam Name	MySQL 5.6 Developer
Exam Code	1Z0-882
Exam Product Version	Oracle Database 12c
Exam Price	USD $245 (Price may vary by country or by localized currency)
Duration	150 minutes
Number of Questions	86
Passing Score	61%
Recommended Training	MySQL for Developers MySQL Learning Subscription Unlimited Product Learning Subscription
Recommended Training	Oracle Certified Professional MySQL 5.6 Developer (OCP)
Recommended Practice	1Z0-882 Online Practice Exam

Oracle 1Z0-882 Syllabus Topics:

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