Skip to content
  1. Online
  2. IT
  3. Database
Oracle PL/SQL Programming cover image
Play overlay
Preview this course

Oracle PL/SQL Programming
Uplatz

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate

Summary

Price
£100 inc VAT
Or £33.33/mo. for 3 months...
Study method
Online, On Demand 
Course format
Video with subtitles and transcript
Duration
4.9 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
  • Reed courses certificate of completion - Free

Overview

Uplatz offers comprehensive training on Oracle PL-SQL. This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

Oracle PL/SQL is an extension of SQL language, specifically speaking it is Procedural language extension to Structured Query Language, and is designed for seamless processing of SQL statements enhancing the security, portability, and robustness of the database. PL/SQL embraces and enhances the SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.

Certificates

Curriculum

This course contains

Format: 19 Videos (with subtitles and transcripts)

Duration: 4h and 57m

    • 1: Overview of PL/SQL Preview 06:48
    • 2: Declaring PL/SQL Variables 10:42
    • 3: Writing Executable Statements 05:43
    • 4: Interacting with Oracle DB Server 05:22
    • 5: Writing Control Structure 39:34
    • 6: Working with Composite Data Types 43:15
    • 7: Using Explicit Cursors 22:04
    • 8: Handling Exceptions 22:35
    • 9: Creating Procedure 15:40
    • 10: Creating Functions 12:38
    • 11: Creating Packages 10:03
    • 12: Working with Packages 10:27
    • 13: Using Oracle-supplied Packages in Application Development 05:59
    • 14: Using Dynamic SQL 11:59
    • 15: Design Consideration for PL/SQL Code 13:36
    • 16: Creating Triggers and Compound, DDL, Event Database Trigger 22:38
    • 17: Using the PL/SQL Compiler 16:01
    • 18: Managing PL/SQL Code 08:55
    • 19: Managing Dependencies 12:36

Course media

Description

Oracle PL/SQL – Course SyllabusModule 1: Introduction to PL/SQL

  • Overview of Oracle Database Architecture

  • Introduction to PL/SQL: Features & Advantages

  • PL/SQL Block Structure (Anonymous Blocks)

  • Execution Environment of PL/SQL

  • PL/SQL Development Tools (SQL*Plus, SQL Developer)

Module 2: PL/SQL Fundamentals

  • Declaring Variables and Data Types

  • Constants and Scope of Variables

  • Using %TYPE and %ROWTYPE

  • Operators and Expressions

  • Commenting and Formatting

Module 3: Control Structures

  • Conditional Statements (IF, CASE)

  • Loops (Basic LOOP, WHILE LOOP, FOR LOOP)

  • EXIT and CONTINUE Statements

  • Nested Blocks and Scope Rules

Module 4: Cursors

  • Implicit Cursors

  • Explicit Cursors: DECLARE, OPEN, FETCH, CLOSE

  • Cursor FOR Loops

  • Cursor Attributes (%FOUND, %NOTFOUND, %ROWCOUNT, %ISOPEN)

  • Parameterized Cursors

  • Cursor with Subqueries

Module 5: Exception Handling

  • Types of Exceptions: Predefined, User-defined

  • Handling Exceptions using EXCEPTION Block

  • RAISE and RAISE_APPLICATION_ERROR

  • Exception Propagation and Scope

Module 6: Stored Procedures and Functions

  • Creating and Executing Procedures

  • Creating and Using Functions

  • Parameter Modes: IN, OUT, IN OUT

  • Calling PL/SQL Subprograms from SQL/Other Programs

  • Differences Between Procedures and Functions

Module 7: Packages

  • Introduction to PL/SQL Packages

  • Creating Package Specifications and Bodies

  • Private vs Public Objects in Packages

  • Advantages of Using Packages

  • Using Built-in Oracle Packages (e.g., DBMS_OUTPUT)

Module 8: Triggers

  • Types of Triggers: BEFORE, AFTER, INSTEAD OF

  • Row-level vs Statement-level Triggers

  • Creating and Managing Triggers

  • Trigger Restrictions and Mutating Table Errors

  • Compound Triggers (Oracle 11g+)

Module 9: PL/SQL Collections and Records

  • Introduction to Collections: VARRAY, Nested Tables, Associative Arrays

  • Declaring and Manipulating Collections

  • Bulk Collect and FORALL Statements

  • PL/SQL Records and Composite Data Types

Module 10: Advanced Topics

  • Dynamic SQL using EXECUTE IMMEDIATE

  • Working with Large Objects (LOBs)

  • Autonomous Transactions

  • Performance Optimization and Best Practices

  • Using PL/SQL with Cursors and Joins

  • Secure Coding Practices in PL/SQL

Module 11: Working with Oracle Tools

  • SQL*Loader for Data Import

  • UTL_FILE for File Handling

  • Using DBMS_SCHEDULER for Job Scheduling

  • Logging and Auditing in PL/SQL

  • Debugging and Profiling PL/SQL Code

Module 12: Real-world Projects and Use Cases

  • Building a Payroll Processing Module

  • Designing an Inventory Management Subsystem

  • Financial Transactions and Audit Trail

  • Data Transformation and ETL with PL/SQL

  • Automation Scripts for DB Maintenance

Who is this course for?

  • Aspiring Database Developers – Individuals looking to start a career in Oracle database development and application programming.
  • SQL Users & Analysts – Professionals familiar with SQL who want to expand into procedural programming for more complex logic and automation.
  • Oracle Application Developers – Developers working on Oracle-based enterprise applications who need to write or maintain PL/SQL procedures, triggers, and packages.
  • Database Administrators (DBAs) – DBAs aiming to enhance their scripting and automation skills using PL/SQL for performance tuning and administrative tasks.
  • Software Engineers & Backend Developers – Engineers building scalable data-driven applications that require efficient data manipulation and logic control.
  • ETL Developers & Data Engineers – Professionals working on data integration and transformation processes in Oracle environments.
  • Students & Graduates – Computer science and IT students seeking hands-on knowledge of enterprise database programming to increase employability.
  • Tech Professionals Preparing for Oracle Certifications – Learners aiming to pursue certifications such as Oracle PL/SQL Developer Certified Associate or Oracle Database SQL Certified Associate.

Requirements

Passion and determination to achieve your goals!

Career path

  • Oracle Developer
  • Oracle DBA (Database Administrator)
  • PL/SQL Developer
  • Database Developer
  • Database Modeller
  • Database Programmer
  • Metadata Administrator/Developer
  • System Administrator
  • Accounts Administrator
  • Core Operation Engineer (Database)
  • Systems Operations Engineer - SQL, Database
  • SQL Database Developer
  • Data Analyst
  • Business Analyst
  • Application Developer (back-end part)
  • IT/Database Consultant

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, Software engineering, SQL, IT, Coding
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.