Oracle Certified Professional

About

Oracle Certified Professional is issued by Oracle, a major maker of database software. It proves that you can install, configure, tune and protect Oracle databases. The credential is international, so it is recognized by employers in Canada and around the world.

No law or licence requires you to hold this certification in order to work in Canada. Employers often like it, though. It can help you move from an entry-level data role into a database administrator job, or support a raise or promotion. It works best when paired with hands-on practice and a background in SQL.

How to get it

1. Learn the basics of SQL and databases
   Make sure you are comfortable writing SQL queries and understand how relational databases work. A college program, an online course or on-the-job experience can all help.
2. Pick the right certification path
   Review the certification options on Oracle's training site and choose the one that matches the database role you want. Check the current requirements, since Oracle updates its paths from time to time.
3. Study with official and practice materials
   Use Oracle's learning resources, study guides and practice tests. Set up a test database at home so you can practise real tasks, not just read about them.
4. Book and take the exam
   Register for the exam through Oracle's testing partner. You can usually choose a testing centre in Canada or take the exam online from home.
5. Add it to your resume and profile
   Once you pass, you will receive a digital badge and certificate. Add them to your resume and professional profiles so employers can see your new credential.

The exam

The exam is a computer-based test made up of multiple-choice and similar question types. It covers the skills needed to manage Oracle databases, such as setup, performance tuning, backup and security. You need to reach a set passing score, and the topics vary by certification path. Most people prepare for a few months while working or studying.

Careers that mention it

Keeping it

Oracle can retire older certification versions as new database releases come out. Your credential does not usually expire on a fixed date, but employers prefer current skills. To stay up to date, you can take an exam on a newer version or earn an additional certification. Check Oracle's current policy before you plan your path.