Home  Courses  Custom dept.  Sales desk  Samples  Services  Help   

Phone 01636 893673
International
+44 1636 893673

Fax (0870) 051 7558
International
+44 870 051 7558

enquiries@firstalt.co.uk

Training Centre:
Harwell, Oxon.
Newark, Notts.

Administration office:
High Park Farm
Swinderby Road
Collingham
Nr. Newark
Notts NG23 7NZ.

OA2

Introduction to Oracle PL/SQL

This two-day course gives an introduction to ORACLE PL/SQL, an application development environment which enables the writing of programs and stored procedures using both SQL and PL/SQL commands.

Select here for related courses
Select here for a list of all courses

OBJECTIVES OF THE COURSE

To take students with basic SQL knowledge a stage further, and to become proficient with PL/SQL.

COURSE CODE OA2 TUTORS Ken Decr email
DURATION 2 days VENUE Newark Training Centre **
PRICE £550 plus VAT * BOOKING CONTACT Mick Hosegood email
EXPERIENCE LEVEL Intermediate TECHNICAL CONTACT Mick Hosegood email
*see note at bottom for special savings! for pricing for a course run especially for your organisation, please use our worksheet **Also available on your site for groups of four to ten.

COURSE DATES:

Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr May June
July
Available
onsite
only








INTENSITY: About 40% of the course is practicals, and 60% lectures.

RESOURCE: Each student will have exclusive use of a PC or Sun workstation for the duration of the course. Each student will be provided with a full set of training notes relating to the course.

PREREQUISITES: Basic SQL knowledge as taught on the Oracle (Part 1) course or extensive experience of SQL with another relational database.

FOLLOW UPS: First Alternative also offer a database administration course Oracle Database Administration

PRACTICALS / TAKEAWAYS: Each student leaves the course with his own set of training notes for the material covered.

SOFTWARE VERSIONS: This course is based on Oracle 8 and 9.

 

TOPICS COVERED ON THE COURSE

Review of SQL*Plus
Some SQL*Plus commands. The SQL*Plus environment. The sample database.

What is PL/SQL?
Block Structure. Some Example Code. The DMBS_OUTPUT Statement.

Variables
Declaration and Data Types. Value Assignment, Variable Typing. Constants, Local and Global. Substitution Variables.

Populating Variables
The SELECT statement. Selecting into variables. Rowtype variables.

Iteration - Looping
The LOOP statement, WHILE Statement and FOR Statement. GOTO and labels.

Cursors
Using Implicit Cursors. Declaring and using Explicit Cursors Cursor attributes. Cursors with loops. Use of select for update. Where Current Of.

Exceptions
Trapping Errors. Raising Internal Exceptions. Using SQLCODE and SQLERRM. Raising User Exceptions. Using the PRAGMA EXCEPTION.

Procedures and Functions
Creating and Executing Procedures. Creating and Executing Functions.

Packages
Creating and Executing packages. Public and Private sub-programs. Examining Dependencies.

Triggers
Types of Trigger. Creating and Firing Triggers. Administration of Triggers.

Appendicies
The Sample Tables. Tables and Arrays. debug Package. Dynamic SQL.

 

SPECIAL SAVINGS FOR MULTIPLE AND PACKAGE BOOKINGS

Multiple Bookings
If you book more than one place on our courses on the same order, you are entitled to a 10% discount.

Package Bookings
Further discounts are available for certain packages of courses.

The complete package is available for £2100 for the 10 days of training (individually taken, the price would be £2675)

 
Fiercely inde dent
 

 

© 2006 First Alternative. All rights reserved.