Oracle PL/SQL Developer Certified Professional

Who can take it

Oracle logo

Oracle PL/SQL Developer Certified Professional Eligibility

1Z0-149

Whether you can sit the Oracle PL/SQL Developer Certified Professional certification exam: prerequisites, who the exam is for, and the skills it assesses.

2 prerequisites
professional level
5 skills

Prerequisites and requirements

Published requirements for this certification.

  • Strong command of standard
  • Understanding of Relational Database Management Systems (RDBMS)

Who this exam is for

Professional Database Developers, Backend Engineers working with Oracle ecosystems, Database Administrators seeking development specialization, and Software Architects responsible for data-driven application logic.

Skills assessed

What the exam actually tests, beyond the domain names.

Procedural Programming
Performance Tuning
Error Management
Data Encapsulation
Bulk Data Processing

The domains you will be assessed on

Eligibility is not only about paperwork. These are the areas you have to actually know.

DomainWeightTopic count
SQL in PL/SQL10%3
Code Management10%4
Working with Data15%4
Exception Handling10%3
PL/SQL Fundamentals15%6
Subprograms and Packages25%5
Dynamic SQL and Advanced Topics15%6

How demanding this exam is

Cognitive load
High. Requires simultaneous mastery of logical programming flow and relational database mechanics.

Our focus for this certification: Emphasis is placed on performance optimization and the efficient use of memory through collections, rather than just syntactical correctness.

More about the Oracle PL/SQL Developer Certified Professional exam

Explore the rest of this page series: format, cost, difficulty, requirements and how to prepare.

Related certifications

Explore other certifications in the same category and see how they stack up.

Frequently asked questions

Everything you need to know about the Oracle PL/SQL Developer Certified Professional exam.