OR-422: Oracle 10g: Advanced Oracle PL/SQL

Dates/Locations:
11/22/2010 – 11/23/2010 | San Antonio|

Duration:
2 Days

Course Overview:
In this course, students learn how to use the advanced features of PL/SQL in order to design & tune PL/SQL to interface with the database & other applications in the most efficient manner.  Using advanced features of program design, packages, cursors & collections, students learn how to write powerful PL/SQL programs.

Course Objectives:

  • PL/SQL Programming Concepts Review
  • Identify PL/SQL block structure
  • Procedures, Functions, Packages
  • Cursors
  • Exceptions
  • Design Considerations
  • Cursor design
  • Describe cursor variables
  • Pass cursor variables as program parameters
  • Compare cursor variables to static cursors
  • Program Overloading
  • Overloading Concepts
  • Writing an Overloaded Program
  • Oracle Supplied Packages
  • Common Supplied Packages
  • Using Supplied Packages
  • Collections
  • Describe & use nested tables
  • Describe & use varrays
  • Describe & use associative arrays
  • Describe & use string indexed collections
  • Describe & use nested collections
  • Write PL/SQL programs that use collections
  • Performance & Tuning
  • Tune PL/SQL code
  • Write smaller executable sections of code
  • Compare SQL to PL/SQL on performance
  • Understand how bulk binds can improve performance
  • The FORALL Option

Prerequisites:
Before attending this course, students must have an understanding of Oracle8i or Oracle9i Database Administration, experience in Oracle tuning, backup and recovery, & networking, & SQL & PL/SQL programming experience is also required.

Related posts:

  1. OR-415A: Oracle 10g: SQL & PL/SQL Programming
  2. OR-413: Tune Oracle SQL
  3. OR-414: Oracle AdministrationTips and Techniques Workshop
  4. OR-412: Learn Oracle PL/SQL
  5. J-215: Advanced Java Programming
This entry was posted in Courses, Oracle, Uncategorized. Bookmark the permalink.

Comments are closed.