Home : Directions : Hotels : Contact Us : About : e-mail : Login
Oracle 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.
Covered Topics:
  • 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 user defined datatypes (objects, records, tables, collections) and built-in packages when developing complex enterprise systems.
Materials Furnished:
Recommended Follow-On Course:
  • Oracle 9i Advanced SQL
  • Oracle 9i Advanced PL/SQL
  • Oracle Forms 9i
  • Oracle Reports 9i
Course Length: Three Days
Public Course Price: $1,485.00
On-Site Price:
Please contact Euler Solutions for details
Home : Directions : Hotels : Contact Us : About : e-mail : Login
Copyright © 2008 Euler Solutions, Inc. Minneapolis, MN