Training Course

Oracle PL-SQL

Download Course PDF

Private Training

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

Course Duration

2 Days

Oracle PL-SQL Course Overview

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.

Oracle PL-SQL 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.

Oracle PL-SQL 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 How to work out what is good and what does not need to be put into the final draft

L.T. Direct Rail Services, Minute Taking

How would you rate the course materials overall Brilliant, showed me everything I need to know going forward

L. Esh Construction, Adobe InDesign Level 1

Was able to ask the questions I had and practice the skills as we learned. Very comfortable atmosphere, approachable trainer and informative content. Learned some really great new skills! Really feel I understand the full breadth of possibilities in PowerPoint.

M.M. Ryder Architecture, PowerPoint Essentials

I'm very pleased I went on this course I have learnt a lot and I'm sure I will be more efficient in my role as a result. The tips I learnt will save me a lot of time at work.

D.S. Joseph Rowntree Foundation, Outlook Essentials

Very competent and thorough course

S.W. Land Digital Agency, Train the Trainer Training Skills for the Workplace

Another very useful course that will help me in my job role, brilliant, thank you.

L.B. Greggs, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

Extremely useful with insights on why you use functions, not only how.

E. , Excel Level 2

Great Course! Great Trainer!

A.M. Hemingways, Excel Level 2

+ 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:9/16/2024 12:06:50 PM