|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
Oracle8i Foundation PL/SQL Workshop
Duration: 2 days
|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
Oracle8i Foundation PL/SQL Workshop
Duration: 2 days
Develop database triggers, stored procedures, and functions.
Course Description:
This course will cover Oracle8i PL/SQL programming language. Students will control data sharing and locking, develop an understanding of multi-user and concurrent transactions and develop database triggers, stored procedures and functions.
You can learn …
The PL/SQL Environment and Program Structure
Update, Insert and Delete Statements
Variable Scope Rules
Error Report Functions
Debugging Procedures
Logical Comparisons
To define and Execute Procedures, and To define Functions, store and Test a Function
To create Package Specifications
To store PL/SQL Program Units
Who Needs to Attend:
Application Developers and Database Administrators who need a fundamental understanding of Oracle 8i, PL/SQL or the SQL language.
Prerequisites:
Oracle 8i Foundation: SQL Basics & SQL*PLUS or equivalent experience.
Course Labs:
Using PL/SQL to create an Anonymous Block
PL/SQL Basics
Selecting and Updating Database Data
Using Explicit Cursors
Handling Exceptions
Creating a Procedure
Creating a Function
Creating a Package
Creating a Database Trigger
Course Content:
PL/SQL BASICS
SQL and PL/SQL
PL/SQL anonymous block structure, and datatypes
Variable declarations, Object naming rules, Executable Statements, Repetition control, and Types of LOOP statements
SQL*PLUS development environment
WORKING WITH DATABASE DATA
Selecting single and multiple rows
Referencing other variables or a database column’s datatypes
Modifying database data (DML)
Implicit cursor attributes
Transaction control commands
Selecting
Declaring explicit cursors
Referencing other structures datatypes
Using the cursor FOR LOOP
Displaying messages with DBMS_OUTPUT
EXCEPTION HANDLING
Writing an exception handler section
Handling predefined exceptions
Handling user-defined exceptions
Controlling exception processing
Using RAISE_APPLICATION-ERROR
Preventing unhandled exceptions
Using PRAGMA EXCEPTION-INIT
STORED PL/SQL OBJECTS
Introduction to procedures and functions stored in the database
Creating stored PL/SQL objects
Creating procedures
Creating functions
Creating packages
Creating package bodies
Introduction to database triggers
Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow