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:
