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

Oracle Training


The Teacher was very talented. As English is my second language, the teacher was able to understand what I was trying to say and answer easily all my questions.
Comment from DND

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