Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements

This course is included in our On-demand training solution.

Overview

To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations

Target Audience

PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites

The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration

80 min.

Course Objectives

Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements

  • identify the steps for creating and enabling a compound trigger and control its firing order using new trigger clauses.
  • recognize the steps for implementing SecureFile LOBs.
  • recognize the steps for performing PIVOT and UNPIVOT operations in various ways on the server side.
  • create reports with the PIVOT operator.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?