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.

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.

 

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

Which part of the course did you find particularly valuable Understanding my personal objectives and challenges and talking through them with examples of goals to improve

C.R. Froneri International plc, Assertiveness Skills

The short cuts when using formulas as I wasn't aware of them whereas I've done doing things the long way round.

D.P. , Excel Level 2

Which part of the course did you find particularly valuable Learned some quick, simple ways that I didn't know were there

C.P. Egger Uk, Excel Level 2

Thank you for an excellently presented training day :

E.C. Nissan, Excel Level 3

I thoroughly enjoyed this course and the pace suited me

J.P. South Tyneside Sunderland NHSFT, Excel Level 2

I found the VLOOKUP and flash field functions really useful. I also enjoyed learning all the additional uses of pivot tables. All of the training was very detailed whilst also being enjoyable!

B.C. , Excel Level 3

Following this training what are you going to do differently Use the knowledge I have gained to set up master pages making it more effective and consistent

S.S. esh group, Adobe InDesign Level 1

Really enjoyed the training and found it useful.

K.M. Durham County Council, Microsoft Power BI Desktop

+ View More Training Reviews

 

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:12/2/2024 7:54:01 AM