Back
|
|
|
Oracle Program With PL/SQL Outline
Delegates: |
|
This course is designed for Oracle programmers and developers
and provides practical experience in writing stand-alone PL/SQL programs
and database triggers, functions, procedures and packages.
It also introduces some of the Oracle-supplied packages including
DBMS_LOB for handling Large Objects.
|
Objectives: |
By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically.
Together with the SQL course, this course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination #1Z0-001: Introduction to Oracle SQL and PL/SQL.
This course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination #1Z0-147: Program with PL/SQL.
This course is also suitable for delegates intending to sit the Oracle Internet Application Developer Rel. 6i Certified Professional examination #1Z0-101: Develop PL/SQL Program Units.
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
Topics Covered: |
- The PL/SQL Program Structure
- Variables and Constants
- Using SQL in PL/SQL Programs
- Generating Output
- IF Statements, CASE Expressions and LOOP Constructs
- Cursors and Cursor Loops
- Exception Handling
- PL/SQL Records and Tables
- Creating and Managing Triggers
- Creating and Managing Stored Procedures and Functions
- Passing Parameters to Stored Program Units
- Creating and Managing Packages
- Implementing Package Features and Constructs
- Using PL/SQL Records and Tables in Packages
- Bulk Collection and Bulk Binding Operations
- Managing Program Unit Dependencies
- Native Compilation and Compile-time Warnings
- Overview of Oracle Supplied Packages
- Native Dynamic SQL
- Using UTL_FILE
- Scheduling Jobs using DBMS_SCHEDULER
- Introduction to the DBMS_METADATA, UTL_MAIL and HTP Packages
- Large Objects and the DBMS_LOB Package
|
Requirements:
|
|
Attendance on the pre-requisite Oracle SQL course and
practical experience in writing SQL statements. Some prior programming
experience will also prove advantageous.
|
|
|
|
