Oracle Certified Associate: PL/SQL Developer

This globally recognised credential validates your expertise in using the PL/SQL programming language in Oracle databases.

This Skillsoft course will train you in everything you need to know to pass the exams for the Oracle PL SQL Developer certification. You'll need to sit the exams separately.

Have a question or ready to enrol?

Document icon and receive a free course guide

At a glance

Study mode



Career Opportunities

Globally recognised





Course length
12 weeks
Study mode



Study from anywhere, when it suits you best and graduate with the identical qualification as an on-campus student.


Study part of the course online. Combine your online learning with classes or practical sessions on-campus at a college or university.


Attend classes on-campus at a university, TAFE or college and interact face-to-face with teachers and fellow students.

Oracle exams 1Z0-144 and 1Z0-047 or 1Z0-051 (by external provider)
Start date

Enrol anytime.

Contact us about starting now.

Skillsoft is the premier global provider of online IT and project management certification training courses.

If you want to be an expert of a particular software package or project management practice, a Skillsoft course will prepare you completely for the certification exam.

The certifications include Microsoft, Cisco, Oracle, Six Sigma, PRINCE2 and more.

Skillsoft's award-winning training method combines affordable computer-based training with the personal attention of instructor-led training.

Read more about
Payment options

12-month interest free payment planTerms & conditions apply

Upfront payment

Read more
Why isn't the course price shown?

Why isn't the course price shown?

The cost of a course can vary depending on a few factors, including:

  • Whether you are an Australian resident
  • How you pay for the course (via a government loan, via a payment plan, or upfront)

To work out how much this course would cost you,
contact a SEEK Learning consultant.

What you'll learn

You'll learn about:

  • PL/SQL (Procedural Language/Structured Query Language)
  • Creating procedures, database triggers, packages and functions with PL/SQL
  • Writing executable statements
  • Creating PL/SQL executable blocks using DML and transaction control statements
  • Creating user-defined PL/SQL records
  • Handling and defining exceptions
  • Using Dynamic SQL
  • Writing and calling local subprograms

Course structure

  • Getting started with PL/SQL
  • Using DML, DDL, cursors, loops and control structures
  • Using data types, INDEX BY tables and cursors
  • Using exceptions, subprograms, JDeveloper and REF cursors
  • Subprograms, packages and exception handling
  • Packages, dynamic SQL and coding considerations
  • Using triggers and the PL/SQL compiler
  • PL/SQL code and dependency management


  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Subqueries, set operators and data manipulation
  • Using DDL, views, sequences, indexes and synonyms
  • Controlling user access and managing schema objects
  • Data dictionary views and large data sets
  • Managing data in different time zones
  • Using subqueries and regular expressions



Certification is awarded by Oracle and is globally recognised. 

Payment options

There are 2 ways you can pay for this course:

1. 12-month interest free payment plan

Pay for your course over time by making weekly, fortnightly or monthly repayments.

This flexible payment plan requires no deposit, and you pay no interest for the first 12 months.

After 12 months, you will be charged an interest rate of 19.95% per annum on the amount that remains to be repaid.

Most working Australian adults are eligible. See Am I Eligible? for details.

A SEEK Learning consultant can help you set up this payment plan. There is a $99 annual fee. Terms and conditions apply.

2. Upfront payment

You can pay for this course upfront via credit card or bank transfer.

To understand more about payment options or find out if you’re eligible for a funding entitlement, contact a SEEK Learning Consultant.

Have a question or ready to enrol?

Our Learning Consultants can:
  • icon enquiry 1Answer any questions about a course
  • icon enquiry 2Give advice on job outcomes
  • icon enquiry 3Explain finance options and help you enrol
Document icon and receive a free course guide

Free call 1800 675 282

9am - 5.30pm AEDT Monday - Friday