Oracle PL/SQL

Course

In Birmingham, Manchester, Bristol and 3 other venues

£ 795 + VAT

Description

  • Typology

    Course

Description

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

Facilities

Location

Starts

Birmingham (West Midlands)

Starts

On request
Bristol (Avon)

Starts

On request
Edinburgh (Midlothian/Edinburghshire)

Starts

On request
Leeds (North Yorkshire)

Starts

On request
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Starts

On request
Manchester (Greater Manchester)

Starts

On request
See all (6)

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Subjects

  • PL/SQL
  • SQL
  • IT

Course programme

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

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

Oracle PL/SQL

£ 795 + VAT