Oracle PL/SQL — A 2 day course

contact usEnquire about this course

Synopsis

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.

Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-144: Program with PL/SQL.

Examinations are not included as part of the course and anyone intending to sit examinations should check directly on the Oracle website for up to date requirements.

Objectives

On completion of this course, delegates will have gained knowledge of:

Suitable For

Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.

Prerequisites

A working knowledge of Oracle's SQL*Plus or SQL Developer products and practical experience in writing SQL statements. This can be gained by attendance of the Oracle SQL course.

Some previous programming experience will also prove advantageous

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 30 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

Birmingham — £795 (+VAT)

Bristol — £795 (+VAT)

Edinburgh — £795 (+VAT)

Leeds — £795 (+VAT)

London — £795 (+VAT)

Manchester — £795 (+VAT)

Sunderland — £795 (+VAT)


Contents

PL/SQL Fundamentals

Program Logic

Using Cursors

Exceptions and Nested Blocks

PL/SQL Records and Index-By Tables