SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training


The course was very helpful for my career. It opened up my eyes on how the web has evolved. I would recommend this course to my colleagues.
Comment from Canada Revenue Agency

1. Title

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

2. Course Pre-requisites

  • Participants must be familiar with all aspects of the PL/SQL language as it pertains to relational database manipulation

3. Target Audience

  • IT professionals who want to make full use of PL/SQL

4. Dates and Pricing


2 People for Guaranteed Live or Virtual Delivery $1,675.00 per person

5. Outline

Module 1: Advanced SQL Querying

Topic 1: Multiple-Table Join Strategies

Topic 2: Using Multi-Table Joins

Topic 3: Creating and Using Sub-Queries

Topic 4: Advanced Sub-Queries

Topic 5: Creating and Using Stored Views

Topic 6: Working with CLOBs and BLOBs

Module 2: PL/SQL Procedures and Functions

Topic 1: Overview

Topic 2: Creating Procedures and Functions

Topic 3: Simple Stored Procedures

Topic 4: Stored Procedures with Parameters

Module 3: Oracle Database Triggers

Topic 1: Triggers

Topic 2: Creating Triggers

Topic 3: Using Triggers for Logging

Topic 4: System Triggers

Module 4: Working with PL/SQL Records

Topic 1: PL/SQL Records

Topic 2: Defining Record Types in PL/SQL

Topic 3: Defining Record Types as Object Types

Module 5: PL/SQL Collections

Topic 1: Introduction

Topic 2: PL/SQL Collections Overview/Types

Topic 3: Working with Varrays

Topic 4: Using Nested Tables

Topic 5: Using Associative Arrays

Topic 6: Collection Reference

Module 6: PL/SQL Error Handling

Topic 1: Oracle Errors

Topic 2: Custom Errors

Topic 3: Exception Handling

Topic 4: Raising Exceptions

Topic 5: Handling User Exceptions

Topic 6: Handling PL/SQL Exception

Topic 7: Propagating Exception

Module 7: Object Oriented Programming with PL/SQL

Topic 1: PL/SQL and Object Oriented Programming

Topic 2: Creating Objects

Topic 3: Methods

Topic 4: Object Table

Topic 5: Using DML with Objects

Module 8: XML Processing

Topic 1: Processing XML Data

Topic 2: Creating XML Documents

Topic 3: Validating XML Data against a Schema

Topic 4: A Few Examples

Module 9: Oracle and Java

Topic 1: Preparing the Environment

Topic 2: Using loadjava and dropjava

Topic 3: Managing Java

Topic 4: Using DBMS_JAVA and DBMS_JAVA_TEST

Topic 5: Publishing and Using Java

Topic 6: A Few Useful Examples

Module 10: Best Practices and Performance Tuning

Topic 1: Overview

Topic 2: Optimization and Performance Tuning

Topic 3: Using Indexes

Topic 4: Common Mistakes and their Solutionss

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette