X

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 often asked how to earn an Oracle Certification. Most of these questions refer to 3 top areas of certification - Oracle Database Administration, Oracle Database Development, and Java Programming.

It is widely agreed that there are tangible benefits of being certified.  Arguably, 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 issues.

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

Top Certifications

Oracle Database Administration

Earn This Popular Certification Do This Use These Preparation Tools
Oracle Database Foundations Certified Junior Associate

Pass Oracle Database Foundations | 1Z0-006

Database Foundations (Oracle Academy Course)

See more options on the exam page.

Oracle Database Administration 2019 Certified Professional

Pass Oracle Database Administration I | 1Z0-082 and 

Pass Oracle Database Administration II | 1Z0-083

Oracle Database Administration Learning Subscription

See more options on each of the exam pages.

If You Hold  One of These Certifications Do This to Upgrade Use These Preparation Tools

Oracle Database 10g, 11g, 12c, 12c R2 Administrator Certified Professional

Pass Oracle Database Administration II 1Z0-083

Oracle Database New Feature Learning Subscription

See more options on the exam page.

Get your Oracle Database Administration 2019 certification questions answered.

Oracle Database Development

Earn This Popular Certification Do This Use These Preparation Tools
Oracle Database SQL Certified Associate

Pass Oracle Database SQL 1Z0-071

Oracle Database Developer Learning Subscription

Practice Exam: 1Z0-071 Oracle Database SQL Administration

Exam Prep Seminar Package: Oracle Database SQL

See more options on each the exam page.

Oracle PL/SQL Developer Certified Associate

Pass Oracle Database SQL 1Z0-071

Pass Oracle Database 11g: Program with PL/SQL 1Z0-144

See above for 1Z0-071 preparation

Oracle Database Developer Learning Subscription

Exam Prep Seminar Package: Program with PL/SQL

Practice Exam: 1Z0-144 Oracle Database 11g: PL/SQL Fundamentals

See more options on each of the exam pages.

Oracle Database PL/SQL Developer Certified Professional

Pass one: Oracle Database SQL | 1Z0-071 or Oracle Database 11g: Program with PL/SQL | 1Z0-144

Pass Oracle Database: Advanced PL/SQL 1Z0-148

See above for 1Z0-071 and 1Z0-144 preparation

Oracle Database Developer Learning Subscription

Practice Exam: 1Z0-148 Oracle Database 12c: Advanced PL/SQL

See more options on each of the exam pages.

Java Programming

Earn This Popular Certification Do This Use These Preparation Tools
Oracle Certified Professional: Java SE 11 Developer

Pass Java SE 11 Programmer I 1Z0-815

Pass Java SE 11 Programmer II 1Z0-816

Core Java Learning Subscription

Java SE 11 Certification Overview and Sample Questions

Practice Exam: 1Z0-815 Oracle Java SE 11 Programmer I OCP

See more options on each of the exam pages.

 

If You Hold  One of These Certifications Do This to Upgrade Use These Preparation Tools

Sun Certified Programmer for the Java Platform, SE 6

Oracle Certified Professional, Java SE 6 , SE 7, SE 8 Programmer

Pass Upgrade OCP Java 6, 7 & 8 to Java SE 11 Developer 1Z0-817

Java 11 Upgrade Learning Subscription

See more options on the exam page.

Oracle Certified Associate, Java SE 5/SE 6, SE 8, SE 8

Pass Java SE 11 Programmer II 1Z0-816

Core Java Learning Subscription

Java SE 11 Certification Overview and Sample Questions

See more options on the exam page.

Get your Java SE 11 Certification questions answered.

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 - some valuable options shown above.
  • 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 Content:

What Does it Cost to Get Oracle Certified?

How to Become a Database Developer

Test Your Java Knowledge With FREE Sample Questions

It's Here! NEW Oracle Certified Professional, Java SE 11 Developer Certification!

Join the discussion

Comments ( 21 )
  • 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.

    Regards,

    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.

    Regards,

    Brandye Barrington


  • guest Saturday, December 3, 2016

    Good news! I get a job lately. thanks Oracle


  • guest Thursday, December 22, 2016

    Hi,

    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.

    Regards,

    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.

    Regards,

    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.

    Regards,

    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.

    Regards,
    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.

    https://community.oracle.com/community/technology_network_community/certification

    Regards,
    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.

    Regards,
    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
  • Charandeep Singh Wednesday, April 24, 2019
    Hi
    What is the code for 19c database certification

    thanks
  • Brandye Williams Barrington Monday, June 10, 2019
    Hi Charandeep,
    So sorry for the delay in replying. There is not an Oracle Database 19c exam. The most current version of Oracle Database Administrator Certification is 12c R2.

    That said, this summer we are releasing a new version of Oracle Database Admin certification. Keep an eye on this blog!

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