Programming with PL/SQL
Course Description
Fundamentals
Introduction to PL/SQL
Benefits of PL/SQL
Creating PL/SQL Blocks
Defining Variables and Datatypes
Using Variables in PL/SQL
Recognizing PL/SQL Lexical Units
Recognizing Data Types
Using Scalar Data Types
Writing PL/SQL Executable Statements
Nested Blocks and Variable Scope
Good Programming Practices
Using SQL in PL/SQL
Review of SQL DML
Retrieving Data in PL/SQL
Manipulating Data in PL/SQL
Using Transaction Control Statements
Program Structures to Control Execution Flow
Conditional Control: IF Statements
Conditional Control: CASE Statements
Iterative Control: Basic Loops
Iterative Control: WHILE and FOR Loops
Iterative Control: Nested Loops
Using Composite Datatypes
User-Defined Records
Indexing Tables of Records
Using Cursors and Parameters
Introduction to Explicit Cursors
Using Explicit Cursor Attributes
Cursor FOR Loops
Cursors with Parameters
Using Cursors for UPDATE
Using Multiple Cursors
Exception Handling
Handling Exceptions
Trapping Oracle Server Exceptions
Trapping User-Defined Exceptions
Recognizing the Scope of Exceptions
Using and Managing Procedures
Creating Procedures
Using Parameters in Procedures
Passing Parameters
Using and Managing Functions
Creating Functions
Using Functions in SQL Statements
Review of the Data Dictionary
Managing Procedures and Functions
Review of Object Privileges
Using Invoker's Rights and Autonomous Transactions
Using and Managing Packages
Creating Packages
Managing Package Concepts
Advanced Package Concepts
Persistent State of Package Variables
Using Oracle-Supplied Packages
Improving PL/SQL Performance
Using Dynamic SQL
Improving PL/SQL Performance
Using and Managing Triggers
Introduction To Triggers
Creating DML Triggers, Part I
Creating DML Triggers, Part II
Creating DDL and Database Event Triggers
Managing Triggers