Certification insights, news and tips
from the Oracle Certification Program.

Top Oracle Certifications and How to Earn Them

Eva Chase
Global, Sr. Marketing Manager

We are always asked how to earn an Oracle Certification. Most of these questions are grouped to certification in one of 3 areas - Oracle Database, Oracle Database SQL, PL/SQL, or Java.

Everyone agrees there are very tangible benefits of being certified.  Possibly the most important benefit is the skills you gain while preparing for your certification exam.  The understanding you gain from your study brings confidence when you are faced with tackling the most challenging situations or solving problems.

Click on any of the exams listed in the table to view Exam Topics, Recommended Training and any Additional Preparation available.

Top Certifications


Oracle Certified Junior Associate (OCJA)

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

How To Stay Current

Java Programmer

Java Foundations:  Pass exam 1Z0-811

Java SE 8 Programmer I:  Pass exam 1Z0-808

Java SE 8 Programmer II:  Pass exam 1Z0-809

If you are a Java SE 7 OCP:  Pass exam 1Z0-810

If you are a Java SE 6 OCP (or earlier):  Pass exam 1Z0-813

Oracle Database 12c Administrator

Oracle Database Foundations:  Pass exam 1Z0-006


Database 12c Administrator:  Pass SQL exam 1Z0-071 and Pass exam 1Z0-062

Database 12c Administrator:  Earn 12c DBA OCA, complete one 12c Database training course and Pass exam 1Z0-063

If you are any earlier version of Oracle DBA OCA:  Complete one 12c Database training course and Pass exam 1Z0-067

If you are any earlier version of Oracle DBA OCP:  Pass exam 1Z0-060

Oracle Database 12c R2 Administrator

Oracle Database Foundations:  Pass exam 1Z0-006

Database 12c R2 Administrator:  Pass SQL exam 1Z0-071 and Pass exam 1Z0-072

Database 12c R2 Administrator:  Earn 12c R2 DBA OCA, complete one 12c R2 Database training course and Pass exam 1Z0-073

If you are an 11g or 12c DBA OCP:  Pass exam 1Z0-074

Oracle Database SQL  Administrator


Oracle Database SQL:  Pass exam 1Z0-071



PL/SQL Developer


Oracle PL/SQL Developer:  Pass SQL exam 1Z0-071 and Pass exam 1Z0-144


Oracle Database PL/SQL Developer:  Pass one of these exams

1Z0-071 or 1Z0-144 and Pass exam 1Z0-148 


How to Prepare for an Oracle Certification Exam

  • Identify any knowledge gaps.  
    • Click on the exam link in the table above and review Exam Topics.
  • Take any missing recommended training.
  • Refresh your knowledge with Exam Prep Seminars and Packages.
    • Get a focused and fast-paced review of exam material with exam prep seminars.
    • Look for extras in the Exam Prep Seminar Packages:
    • Exam prep seminar access, 24/7 (6 month subscription).
    • Practice test access, 24/7 (6 month subscription).
    • 1 exam voucher with a free retake, in case you need it (valid for 6 months).
  • Practice. Test your knowledge with Kaplan SelfTest Practice Exams.
  • Plan.  Read this Entrepreneur article on productivity “How to Accomplish More in 4 Days Than Most People Do in 4 Weeks” to create a road map. 

RELATED:  The Secret to Choosing the Best Oracle DBA Certification for You 

Join the discussion

Comments ( 19 )
  • guest Friday, April 22, 2016

    Having had ocp in 11g database still can't find one company (as a fresher) that'll hire

  • Brandye Barrington Friday, April 22, 2016

    I'm sorry to hear this. This is something we hear from time to time. You need experience to get a job and need a job to get experience.

    One way to start gaining experience is to make yourself available for contract work. You can try www.upwork.com.

    Others have also conmmented on this dilemma in the Oracle Certification Community https://forums.oracle.com/forums/forum.jspa?forumID=459.


    Brandye Barrington

  • guest Friday, May 6, 2016

    "Having had ocp in 11g database still can't find one company (as a fresher) that'll hire"

    I don't really see that in real life, I work in Poland, Silesian District and I have a couple of friends that work with Oracle DB and don't even have an OCA, when recruiting your cetificates are a big advantage but you have to prove that you know the practical side of working with RDBMS, that it's not only a paper you've got. If you have an OCP it shouldn't really be a problem to find a job. If you have an OCP an know your stuff you can choose a job that suits you ;)

    I wish you all of the best ;)

  • guest Friday, July 29, 2016

    Will the Java Java SE 8 Programmer Oracle Certified Associate(OCA) help me land a job in the financial industry in their technology division? How well do these certifications stand out to recruiters and HR?

  • Brandye Barrington Thursday, August 4, 2016

    The certification can get your resume to the top of the pile. It is up to you to ensure that you have the knowledge and skills for the job.


    Brandye Barrington

  • guest Saturday, December 3, 2016

    Good news! I get a job lately. thanks Oracle

  • guest Thursday, December 22, 2016


    I am about to start a new position in January as an Analyst, which involves supporting the Oracle R12 Suite in the Supply Chain Management sector. It is an entry-level position, and requires basic understanding of PL/SQL 12c.

    I hope to study one of the certification exams to demonstrate my understanding in PL/SQL, ability to learn, and might help me learning my way to master the R12 Suite (Nice to have but not necessary).

    Would you kindly point me to the right direction? I am confused a bit the following 2 paths:

    ONE: Oracle Database 12c Administrator Oracle Certified Associate

    TWO: Oracle Database 12c SQL Administrator Oracle Certified Associate

    I'd appreciate it if you could tell me which path would be more align with my goal.

    Thanks&Merry Christmas,

    Willyum Wu

  • Brandye Barrington Tuesday, January 3, 2017

    Hi Willyum,

    The Administrator OCA certification covers more material than the SQL OCA. The SQL OCA certification focuses on SQL.


    Brandye Barrington

  • guest Friday, January 6, 2017

    Hello oracle expert

    I take the oracle 11 i financials payable certified consultant and full training of oracle 11i financials from 2010 but unfortunately I didn't found any jobs till now in this field but I already work this period in accounting so I need help even in how I can update my degrees to get hire in oracle and if I can use my certificate

    Advance regards for all.

  • Brandye Barrington Friday, January 6, 2017

    If you are looking for a job at Oracle, you can have a look at the Oracle Careers page https://www.oracle.com/corporate/careers/index.html. If you're looking for a job with the skills and certification you hold, I'd recommend searching prominent job sites. You can update your certification to R12 and that may help, but I'd start with in depth searching on specific skills and technologies related to your training and certification.


    Brandye Barrington

  • Gauraw Monday, March 27, 2017

    I am little bit confuse by choosing OCA certification of oracle developer.

    Can you just tell me to choosing right certification in following:

    Oracle Database 12c SQL 1Z0-071 or

    Oracle Database 12c: SQL Fundamentals 1Z0-061 or

    Oracle Database 11g: SQL Fundamentals I 1Z0-051 or

    Oracle Database SQL Expert 1Z0-047

  • Brandye Barrington Wednesday, March 29, 2017

    If you are pursuing a Database Administrator or Developer OCA, your first step will be to pass a SQL exam. All the exams you mention above will fulfill the SQL requirement in your OCA path. The difference in these exams is in what they test on and what results they provide.

    061 and 051 are non-proctored exams that can be taken on your computer from your own location. These two exams do not result in certification on their own. Once passing these exams, you'll have to pass another exam to earn a certification.

    071 and 047 are a bit more arduous and also result in a certification. After passing these, you can go on to earn the DBA or Developer OCA, but you will have a certification after passing one of these exams. The 047 exam retires soon.


    Brandye Barrington

  • venkateswarreddy Tuesday, June 12, 2018
    sir/ma'am i need the material to complete the sql fundamentals exam
  • Brandye Barrington Wednesday, June 20, 2018
    Hi Venkateswarreddy,
    You can find the recommended training on our website, on the exam page. You can search our Oracle Certification Community https://community.oracle.com/community/technology_network_community/certification to find recommendations on books and methods others have used to prepare.

    Brandye Barrington
  • Brandye Barrington Wednesday, June 20, 2018
    Hi Venkateswarreddy,
    I recommend that you visit the exam page to find the recommended training. I also recommend that you visit the Oracle Certification discussion Community and search for books and preparation methods that others have used to help prepare for this exam.


    Brandye Barrington
  • guest Monday, December 10, 2018
    I am planning to take a oracle database certification exam, but i am confused with what exam i should go for???
  • Brandye Barrington Tuesday, December 11, 2018
    You can start with pursuing Oracle Database 12c R2 Database Administrator Certified Associate.

    Start with passing exam 1Z0-071 - this will earn you the SQL OCA credential and fulfill your SQL requirement in order to earn 12c R2 DBA OCA. After passing 1Z0-071, you'll need to pass 1Z0-072.

    Links for all these exams are in post above. Go to the exam page to view recommended training and exam topics.

    Brandye Barrington
  • DeAndra Tuesday, February 12, 2019
    What learning path should I take as a Pl/SQL developer to extend my skills to the cloud?
  • Brandye Barrington Tuesday, February 19, 2019
    Checking on this for you, DeAndra.

    Brandye Barrington
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha