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