The Oracle Certified Associate, MySQL 5 credential offers entry-level certification for MySQL database professionals. The program, formerly known as the Certified MySQL Administrator (CMA) program, provides potential and current employers with confidence that candidates have demonstrated a base level of knowledge about the MySQL database platform.
Earning the OCA MySQL 5 Credential
Earning the OCA MySQL 5 certification requires passing a single, 50-question exam with a score of 60 percent (or 30 correct answers). Oracle recommends that candidates attend the
MySQL for Beginners (SQL-4401) training program prior to taking the exam, but hands-on experience combined with a suitable reference book will likely be sufficient to pass the exam for practicing database professionals.
Exam 1Z0-870: MySQL 5 Certified Associate Exam Topics
The MySQL 5 certified associate exam is broken into six sections, each containing questions on a number of database administration topics. The compostition of the exam is as follows:
-
Theory, Terminology and Concepts (10% of the exam)
- Client/Server Concepts
- Database and Database Objects
- Data Definition using SQL (25% of the exam)
- Databases
- Data Types
- Tables
- Constraints and Indexes
- Views
- Basic Data Manipulation using SQL (25% of the exam)
- Recurring SQL Constructs
- Adding data
- Modifying data
- Removing data
- Searching data
- Advanced Data Manipulation using SQL (20% of the exam)
- Expressions
- Grouping and Aggregate Functions
- Joining Tables
- Transactions (10% of the exam)
- Transaction Concepts
- SQL for working with Transaction
- Import/Export (10% of the exam)
- Tools for Import/Export
- SQL for Import/Export
Registering for the Exam
Taking the MySQL 5 Certified Associate exam requires payment of a $195 examination fee and completing the
online registration process. The exam may be taken at any Pearson VUE testing center worldwide.
Advanced MySQL Certifications
Once you've earned the Oracle Certified Associate, MySQL5 credential, you may wish to move on to the more advanced MySQL certifications. These include:
