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.
Attendees to OR-422: Oracle 11g: Advanced Oracle PL/SQL will receive TechNow approved course materials and expert instruction.
Dates/Locations:
No Events
Duration: 2 Days
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, or 10g Database Administration
- Experience in Oracle tuning, backup and recovery
- Networking
- SQL & PL/SQL programming experience is also required
Comments
Latest comments from students
User: mendezjames
Instructor comments: Excellent instructor. Explained concepts very well.