Oracle Database Certification

Questions about Oracle database certification for developers and dbas have been popping up a lot recently, so we thought we'd answer them all in one go, Initially, Oracle certification was only available to DBAs but has now been extended to cover developers and system administrators. This article covers the certification paths for DBAs and developers.

Oracle DBA Certification

Certification for DBA  is available for Oracle 11g and Oracle 12c and has three levels:- • Oracle Database Administrator Certified Associate (OCA) • Oracle Database Administrator Certified Professional (OCP) • Oracle Database Administrator Certified Master (OCM)

Oracle 11g DBA certification

The first level of certification is as Oracle Certified Associate (OCA) which which Oracle describe as a foundation or apprentice qualification enabling you to act as a junior team member. To become an Oracle Certified Associate (OCA) you have to pass 2 exams. One of • Oracle Database 12c SQL Fundamentals  (#1Z0-061)  or • Oracle Database 11g SQL Fundamentals I (#1Z0-051)  or • Oracle Database SQL Expert  (#1Z0-047) and Oracle Database 12c Administration I (#1Z0-062). The next stage is to become an Oracle Certified Professional (OCP). This requires you to have obtained the OCA level, take at least one Oracle University Oracle 11g DBA hands-on course as well as pass another exam - Oracle Database 11g Administration II (#1Z0-053). Once you've qualified as an Oracle Certified Professional, the next stage is to become an Oracle Certified Master. To qualify for this you need to take at least 2 advanced courses from Oracle University and then pass a 2-day practical exam which test you on subjects such as database configuration, network configuration, Enterprise Manager set up and configuration, using RMAN (recovery manager), creating a standby database, recovering from errors, etc. You're not allowed to take in your own notes but you are provided with a complete set of the Oracle documentation.

Oracle 12c DBA certification

For certification on Oracle 12c starting from scratch the process is the same as for Oracle 11g. For the first level - Oracle Certified Associate (OCA) - you are required to pass 2 exams:- One of • Oracle Database 12c SQL Fundamentals  (#1Z0-061)  or • Oracle Database 11g SQL Fundamentals I (#1Z0-051)  or • Oracle Database SQL Expert  (#1Z0-047) and Oracle Database 12c Administration I (#1Z0-062). To become an Oracle Certified Professional (OCP) after you have obtained the OCA level you have to take at least one Oracle University Oracle 12c DBA hands-on course as well as pass one exam - Oracle Database 12c Advanced Administration I (#1Z0-063). The master level is not yet available for Oracle 12c. If you have certification on an earlier release (7.3 or later) it is possible to upgrade by passing one exam - Upgrade to Oracle Database 12c (#1Z0-060). That’s the mechanics of Oracle certification but if you're wondering whether or not certification is worth the trouble then see this article on Oracle certification benefits and see our resources page for links to OTN and other sites offering help with certification. ------------------------------------------------------- Need highly skilled, highly trained, highly motivated resources for your Oracle projects? With our help you can develop your systems better, faster and smarter than ever before. Ask us how we can help you, or call 0845 0031320 to talk to one of our consultants with no obligation . Oracle tips and tricks Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky-rocket productivity and make your systems better, faster and smarter. Smartsoft Computing Ltd, Bristol, England Tel: 0845 003 1320 Any questions? Contact Us View our privacy policy This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way linked to individuals. View woopra privacy policy.  Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. © Copyright Smartsoft Computing Ltd 2014. All rights reserved