Oracle Program with PL/SQL

Catalyst Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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. The content of the course covers all the topics required for the Oracle 9i PL/SQL Developer Certified Associate Examination #1Z0-147.

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

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Linux Advanced System Administration (LPI)
Lotus
Nortel Networks
MCDST, MCSA, MCSE, MCDBA, MCAD, MCSD
Novell
Relational Databases
Introduction to SQL
ORACLE Overview
PL/SQL
ORACLE Fundamentals
PL/SQL Web Applications
SQL Performance Tuning
Forms Web Deployment
DBA Fundamentals
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration
Oracle 11i System Administration
Oracle Financials

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.