Oracle Certification Path 2026: From SQL Associate to PL/SQL Developer and DBA

Oracle's database certifications form a clear ladder: everyone starts with SQL, then branches into the developer track (PL/SQL) or the DBA track (Database Administration). This guide maps the whole path for 2026 — which exam to take first, how the branches sequence, what each step costs, and how to prepare for every one of them free with SQLMentor's tutorials and timed practice exams.

The path at a glance

Step 1 — everyone: Oracle Database SQL Certified Associate (1Z0-071) — the SQL language foundation both branches assume.
Step 2, developer branch: Oracle Database Program with PL/SQL (1Z0-149) — procedural Oracle development.
Step 2, DBA branch: Oracle Database Administration I (1Z0-082) — running the database.
Step 3, DBA branch: Oracle Database Administration II — combined with 1Z0-082 it leads to Oracle's professional DBA credential (confirm the current exam number on Oracle University).

Exam numbers, credential names, and fees are set by Oracle and change between database versions, so confirm current details on Oracle University ↗ before booking. SQLMentor is an independent study resource, not affiliated with Oracle.

Step 1: the SQL foundation (1Z0-071)

Whatever direction you are heading, start here. The 1Z0-071 tests the SQL language itself — SELECT, joins, subqueries, set operators, DML, DDL, constraints, and views — with no administration content. Both follow-on exams assume this knowledge: PL/SQL is built on SQL, and a DBA who cannot read queries cannot troubleshoot them. It is also the most beginner-friendly exam on the path: motivated candidates routinely go from limited SQL to a pass in two or three months of consistent study.

Prepare with the free Oracle SQL tutorial, practise every construct in the in-browser SQL editor, then take the timed 1Z0-071 practice exams until you consistently clear the 63% pass mark with a cushion. The full 1Z0-071 exam guide has the syllabus breakdown and a week-by-week plan.

Branch A — the developer track: PL/SQL (1Z0-149)

If you build applications, reports, ETL, or server-side business logic on Oracle, the developer branch is one exam: the 1Z0-149 Oracle Database Program with PL/SQL. It covers stored procedures, functions, packages, triggers, every cursor style, collections, bulk operations, and dynamic SQL — the material that separates someone who writes queries from someone who builds Oracle back-ends. Prepare with the PL/SQL tutorial and the 1Z0-149 practice exams; the 1Z0-149 exam guide maps every syllabus area to a tutorial topic.

Branch B — the DBA track: Database Administration (1Z0-082 and beyond)

If your work is operating databases — installation, storage, users and security, networking, backup and recovery — the DBA branch starts with the 1Z0-082 Oracle Database Administration I. It is an operational exam: architecture, instances, tablespaces, undo/redo, the listener, and moving data with Data Pump and SQL*Loader. Passing it positions you for the second DBA exam (Database Administration II), and the two together lead to Oracle's professional DBA credential. Prepare with the 1Z0-082 practice exams and the 1Z0-082 exam guide.

Choosing your branch

You write code or queries all day → developer branch (1Z0-149). PL/SQL skills also make you dramatically more effective at debugging the database side of applications.
You (will) carry the pager for the database → DBA branch (1Z0-082 → Administration II).
Not sure yet? Take 1Z0-071 and decide afterwards — it counts fully toward both branches, and preparing for it will show you which side of the work you enjoy.
Working across engines? The Oracle path pairs well with the Microsoft DP-300 (Azure) or the PostgreSQL Associate — see the full certification comparison.

Budget and timeline

Each Oracle exam costs around US$245 (region-dependent), so a complete two-exam path is roughly US$490 in fees — the only mandatory spend, since preparation can be entirely free. Time-wise, budget 4–8 weeks per exam alongside a job: a typical zero-to-certified developer path (1Z0-071 + 1Z0-149) spans three to six months. If you fail an attempt, Oracle enforces a 14-day minimum wait before a retake — one more reason to only book once your practice-exam scores sit comfortably above the pass mark.

How to prepare for every step, free

Learn: the Oracle SQL and PL/SQL tutorials cover the exam syllabi topic by topic.
Practise: the SQL editor runs your queries live against an HR schema — the same style of schema the exams reason about.
Test: timed practice exams for 1Z0-071, 1Z0-082, and 1Z0-149 mirror the real format, scoring threshold, and time pressure, with per-question explanations.
Reinforce: the Oracle SQL and PL/SQL interview question sets exercise the same concepts from a different angle.

Start at step 1

Three full-length, timed 1Z0-071 practice exams with per-question explanations — free, no sign-up, progress saved locally in your browser.

Take a free 1Z0-071 practice exam →

Frequently asked questions — the Oracle certification path

Which Oracle certification should I get first?

Start with the Oracle Database SQL Certified Associate (1Z0-071). It tests the SQL language itself, is assumed knowledge for both the PL/SQL (1Z0-149) and DBA (1Z0-082) exams, and is attainable for motivated beginners after a few months of study.

Can I skip 1Z0-071 and go straight to 1Z0-082 or 1Z0-149?

There is no formal prerequisite, so yes — but both follow-on exams assume SQL fluency at the 1Z0-071 level. If you already write Oracle SQL daily you can skip ahead; if not, studying (or sitting) 1Z0-071 first makes the later exams substantially easier.

Do Oracle certifications expire?

Oracle certifications do not have a fixed expiry date, but they are tied to product versions, and Oracle retires older exams over time. Your earned credential remains on your record, though employers value certifications aligned with current database versions more. Check Oracle CertView for your credential status and Oracle University for current exam versions.

Should I take the developer path or the DBA path?

Choose by the work you want to do. If you build applications, reports, or back-end logic, take the developer path: 1Z0-071 then 1Z0-149 (PL/SQL). If you operate databases — installation, storage, security, backup — take the DBA path: 1Z0-071 (recommended) then 1Z0-082 and the second DBA exam. The paths share the SQL foundation, so you can switch later.

How much does the Oracle certification path cost?

Each Oracle exam is around US$245 (varies by region), so a two-exam path such as 1Z0-071 plus 1Z0-149 is roughly US$490 in exam fees. Preparation can be free: SQLMentor's tutorials, SQL editor, and full-length practice exams cost nothing and need no sign-up.

How long does the full Oracle certification path take?

A typical timeline is 4 to 8 weeks of study per exam alongside a job. Going from zero to 1Z0-071 plus one follow-on exam usually spans 3 to 6 months, faster if you already work with Oracle daily.