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
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
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.

 

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

Printed: 23 Aug 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