PL/SQL and Objects: Objects, Libraries, XML, Exceptions and More
(PLS301, 3 days)


This SETC Certified course covers the advanced elements of the PL/SQL language. Beginning with procedures and functions, the exploration includes database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling and object oriented programming in PL/SQL. And if that was not enough, the course concludes with a detailed study of XML processing, Java integration and performance tuning and optimization. Now that is a full learning week.

Dates and Pricing

Jan 24 to Jan 26, 2018$1,675/person Feb 21 to Feb 23, 2018$1,675/person Mar 21 to Mar 23, 2018$1,675/person


Advanced SQL Querying
Multiple-Table Join Strategies
Using Multi-Table Joins
Creating and Using Sub-Queries
Advanced Sub-Queries
Creating and Using Stored Views
Working with CLOBs and BLOBs
PL/SQL Procedures and Functions
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
Oracle Database Triggers
Creating Triggers
Using Triggers for Logging
System Triggers
Working with PL/SQL Records
PL/SQL Records
Defining Record Types in PL/SQL
Defining Record Types as Object Types
PL/SQL Collections
PL/SQL Collections Overview/Types
Working with Varrays
Using Nested Tables
Using Associative Arrays
Collection Reference
PL/SQL Error Handling
Oracle Errors
Custom Errors
Exception Handling
Raising Exceptions
Handling User Exceptions
Handling PL/SQL Exception
Propagating Exception
Object Oriented Programming with PL/SQL
PL/SQL and Object Oriented Programming
Creating Objects
Object Table
Using DML with Objects
XML Processing
Processing XML Data
Creating XML Documents
Validating XML Data against a Schema
A Few Examples
Oracle and Java
Preparing the Environment
Using loadjava and dropjava
Managing Java
Publishing and Using Java
A Few Useful Examples
Best Practices and Performance Tuning
Optimization and Performance Tuning
Using Indexes
Common Mistakes and their Solutionss