Oracle Version 11g PL/SQL Programming for Developers

    

Summary:
The Oracle Version 11g PL/SQL Programming for Developers course teaches students the detailed aspects of writing PL/SQL procedural language programming that exists within the Oracle Version 11g Relational Database Management System. This class is meant to inform students of the entire aspects of programming that are available through Oracles PL/SQL facility. This class is a combination of both intensive lectures and student hands on lab exercises.

Duration:
3 Days/Lecture & Lab

Audience:
This course is recommended for applications programmers, system administrators, and database administrators who require an in-depth understanding of the PL/SQL coding facilities contained in the Oracle Relational Database Management System.

Topics:

• PL/SQL overview
• Block based development
• PL/SQL datatypes
• Local variables
• Database derived variables
• User defined records
• User defined subtypes
• Variable assignment
• Conversion functions
• Date functions
• String functions
• Regular expressions
• Numeric functions
• Returning data
• If….else processing
• Case processing
• For loops
• While loops
• Goto and labels
• Exception handling
• Sqlcode and sqlerrm
• Nested blocks
• Coding cursors
• Implicit cursors
• Cursor variables
• Stored procedures coding
• Input parameters
• i/o parameters
• i/o parameters
• Stored functions coding
• Compilations
• Coding triggers
• Examples of DML triggers
• Coding PL/SQL packages
• Built in packages
• DBMS_SQL
• DBMS_UTILITY
• UTL_FILE
• Native Dynamic SQL
• Execute immediate command
• Collections
• Bulk binds

Prerequisites:
Students should have knowledge of relational database concepts, and the usage of the structured query language.

Last Update: May 21, 2013