Oracle 9i Advanced PL/SQL

This hands-on course provides critical continuation of learning for the PL/SQL developer and is the next step for students with knowledge of the PL/SQL basics.  This class is designed for PL/SQL developers writing or supporting complex enterprise systems.

Class Agenda:

• PL/SQL review
• Oracle 9i PL/SQL new features overview
• Working with object types and methods
• PL/SQL records, tables and collections
• Table functions
• Overloading packages
• Built-in packages
  • DBMS_SQL and execute immediate
  • DBMS_LOB
  • UTL_FILE
  • DBMS_JOB
  • DBMS_TRACE
  • DBMS_PROFILER

Prerequisites:

• Oracle 9i SQL Fundamentals, Oracle PL/SQL Fundamentals or equivalent experience

Audience:

• Oracle application developers

Course Benefits:

• Students will expand their knowledge of basic Oracle PL/SQL and be able to incorporate userdefined datatypes (objects, records, tables, collections) and built-in packages when developing complex enterprise systems.

Materials Furnished:

• Student Manual

Recommended Follow-On Course:

• Oracle Forms 9i
• Oracle Reports 9i
• Oracle 9i Advanced SQL

Course Length: Three Days

List Price: $1485