Training Course

Oracle PL-SQL

PDF
2 Days
The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
03 Apr - 04 Apr 2025
Virtual Course
£995
01 May - 02 May 2025
Virtual Course
£995
12 May - 13 May 2025
Virtual Course
£995
05 Jun - 06 Jun 2025
Virtual Course
£995
03 Jul - 04 Jul 2025
Virtual Course
£995
14 Jul - 15 Jul 2025
Virtual Course
£995
31 Jul - 01 Aug 2025
Virtual Course
£995
04 Sep - 05 Sep 2025
Virtual Course
£995
15 Sep - 16 Sep 2025
Virtual Course
£995
02 Oct - 03 Oct 2025
Virtual Course
£995
30 Oct - 31 Oct 2025
Virtual Course
£995
10 Nov - 11 Nov 2025
Virtual Course
£995
27 Nov - 28 Nov 2025
Virtual Course
£995

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Prerequisites

    • Prerequisite course : Oracle SQL
    • A working knowledge of SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous.

Course Objectives

    • To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.

Target Audience for this Course

    • Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.

Skills Gained from this Training

    • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
    • Declaring and using variables and constants
    • Assigning and manipulating values
    • Using SQL statements within PL/SQL
    • Implementing conditional execution and loop constructs
    • Declaring and using cursors with and without parameters
    • Updating data with cursors
    • Trapping and handling errors and exceptions in code
    • Implementing nested and labelled loops and blocks
    • Raising exceptions
    • Handling PL/SQL records and tables
    • Using PL/SQL table built-in functions

Included with this course

    • Comprehensive course materials and exercises

Oracle PL-SQL Course Content

  • DAY 1


  • Course Introduction

    Administration and Course Materials
    Course Structure and Agenda
    Delegate and Trainer Introductions

  • PL/SQL FUNDAMENTALS

    What is PL/SQL?
    Basic Elements
    Variables and Constants
    Data Types
    Initialising Variables and Assigning Values
    Using SQL Statements in Code
    Generating Output to SQL or SQL Developer
  • PROGRAM LOGIc# #IF THEN ELSIF ELSE Statements
    CASE Statements
    The Basic Loop Construct
    WHILE and FOR Loops
    Nested and Labelled Loops
    The GOTO Statement
    The CONTINUE Statement

  • USING CURSORS

    What is a Cursor?
    Implicit and Explicit Cursors
    Cursor Operations
    Declaring, Opening and Closing Cursors
    Fetching Rows
    Status Checking
    Using Cursors FOR UPDATE
    The Cursor FOR Loop
    Parameterised Cursors
  • Day 2

  • EXCEPTIONS AND NESTED BLOCKS

    The EXCEPTION Section
    Types of Exception
    Handling Named System-Raised Exceptions
    Handling Un-named System-Raised Exceptions
    User-Declared Exceptions and Application Errors
    WHEN OTHERS THEN NULL
    Nested and Labelled Blocks
    Propagation of Exceptions
    Scope of Variables and Cursors
    Scope of Goto Statements

  • PL/SQL RECORDS AND INDEX-BY TABLES

    Declaring Record Types
    Handling PL/SQL Records
    Nested Records
    Declaring PL/SQL Index-By Tables or Associative Arrays
    PL/SQL Table Built-in Functions
    Manipulating PL/SQL Tables or Associative Arrays

  • Note

    The 2 Day Oracle PL/SQL course can be combined with the 3 Day Stored Program Units course, this is equivalent to attending the 5 Day Oracle Program with PL/SQL course.

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
03 Apr - 04 Apr 2025
Virtual Course
£995
01 May - 02 May 2025
Virtual Course
£995
12 May - 13 May 2025
Virtual Course
£995
05 Jun - 06 Jun 2025
Virtual Course
£995
03 Jul - 04 Jul 2025
Virtual Course
£995
14 Jul - 15 Jul 2025
Virtual Course
£995
31 Jul - 01 Aug 2025
Virtual Course
£995
04 Sep - 05 Sep 2025
Virtual Course
£995
15 Sep - 16 Sep 2025
Virtual Course
£995
02 Oct - 03 Oct 2025
Virtual Course
£995
30 Oct - 31 Oct 2025
Virtual Course
£995
10 Nov - 11 Nov 2025
Virtual Course
£995
27 Nov - 28 Nov 2025
Virtual Course
£995

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Oracle PL-SQL Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Course Reviews
"Just really useful and enjoyable"

N.W. Riverford Organic Farmers, Excel Level 2

Following this training what are you going to do differently "Play around a lot more and be more confident with excel."

J. LHP, Excel Level 1

Following this training what are you going to do differently "It will save alot of time on my day to day knowing the shortcuts and how excel can help me to work faster"

H.S. Dartmouth Global Trading Co Ltd, Excel Level 1

Following this training what are you going to do differently "Take less time to do everything on excel"

S.A. ASW Assurance, Excel Level 2

Which part of the course did you find particularly valuable "It was useful to gain a wider knowledge on how the pie chart function works."

S.B. , Excel Level 1

What were the most useful aspects of the course "Personal adaption of course content to make it relevant to your situation"

J.M. Welwyn Components Ltd, Conflict Management

Following this training what are you going to do differently "My general usage of InDesign will be much improved! I'm a much more confident and competent user of the platform now, and feel ready to explore other platforms within the Adobe Creative Cloud suite."

L.O. Cambrex, Adobe InDesign Level 1

"There were many small elements of my existing understanding that were expanded. Everything was explained really well and I now have a better understanding of things I struggled with before like how IF statements are set up. I also have easier ways to do things, like naming cells where there are absolutes."

S.F. , Excel Level 2

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
03 Apr - 04 Apr 2025
Virtual Course
£995
01 May - 02 May 2025
Virtual Course
£995
12 May - 13 May 2025
Virtual Course
£995
05 Jun - 06 Jun 2025
Virtual Course
£995
03 Jul - 04 Jul 2025
Virtual Course
£995
14 Jul - 15 Jul 2025
Virtual Course
£995
31 Jul - 01 Aug 2025
Virtual Course
£995
04 Sep - 05 Sep 2025
Virtual Course
£995
15 Sep - 16 Sep 2025
Virtual Course
£995
02 Oct - 03 Oct 2025
Virtual Course
£995
30 Oct - 31 Oct 2025
Virtual Course
£995
10 Nov - 11 Nov 2025
Virtual Course
£995
27 Nov - 28 Nov 2025
Virtual Course
£995

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your Oracle PL-SQL course, we have many solutions available to ensure you receive the best training possible.
Your PL-SQL course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Oracle PL-SQL course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master PL-SQL, please contact us to book a place or request a quote for your Oracle PL-SQL course.

General Information

Oracle PL SQL Training Courses. Oracle PL/SQL training courses throughout the North East of England including Newcastle, Durham, Washington, Middlesbrough, Darlington, Gateshead, Sunderland, Leeds. SQL SQL Developer Training Courses North East England. How to write and run PL/SQL Programs.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/26/2025 7:37:11 AM