Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements

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

Overview

To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements

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 Dynamic SQL and Implementing Performance Improvements

  • recognize the steps for using native dynamic SQL and the DBMS_SQL package to specify dynamic SQL statements, using CLOB data types and also abstract data types.
  • identify the steps for using language enhancements to improve sequence usability, control loop iterations, employ named and mixed notation in calls to PL/SQL, and place a table in read-only mode.
  • recognize the steps for improving the performance of SQL and PL/SQL with a new compiler, a new, faster data type, inlining for faster performance, caching, and flashback enhancements.
  • examine and then improve performance in Oracle Database 11g.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?