PL/SQL and Objects: Objects, Libraries, XML, Exceptions and More
(PLS301, Live Instructor-Led Training, 3 days)


Description

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

Outline

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
Overview
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
Oracle Database Triggers
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
Introduction
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
Methods
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
Using DBMS_JAVA and DBMS_JAVA_TEST
Publishing and Using Java
A Few Useful Examples
Best Practices and Performance Tuning
Overview
Optimization and Performance Tuning
Using Indexes
Common Mistakes and their Solutionss