We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course Oracle PL-SQL
  • Public Scheduled Price£895 +VAT
  • Course Duration2 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed 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 content, flexible date, flexible location, variable 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.

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.
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.
Objectives
    • To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
Target Audience
    • 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
    • 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
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.
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 21 Nov 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields