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

Dates/Locations:

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 11g: SQL & PL/SQL Programming
2. J-215: Advanced Java Programming
3. OR-412: Learn Oracle PL/SQL
4. OR-413: Tune Oracle SQL
5. MS-2609: Introduction to C# Programming with Microsoft .Net