Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing

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

Overview

To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.

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

70 min.

Course Objectives

Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing

  • identify the steps for using the PL/SQL Debugger tool in SQL Developer.
  • debug a procedure using the PL/SQL Debugger.
  • recognize the steps for making effective use of collections in PL/SQL and deciding which is the best collection to use in a given scenario.
  • recognize the steps for using materialized views and query rewrite enhancements to improve query execution times.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?