MySQL 5.6 Developer Exam Topics
Here’s a list of the topics on the MySQL 5.6 Developer Exam – 1Z0-882. As I prepare for the exam, I’ll add-in some study notes and links to online resources for each topic.
A. 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
B. 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 behaviour
C. 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
D. 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
E. 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
F. 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
G. Joins, subqueries and UNION
- Identify, describe and use JOINs in MySQL commands
- Describe and utilize subqueries in MySQL commands
- Perform operations using UNION clause
H. 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
I. 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
Leave a Reply