Oracle Database 11g: Partitioning and Storage-Related Enhancements

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

Overview

identify the benefits of Oracle Database 11g’s partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

110 min.

Course Objectives

Oracle Database 11g: Partitioning and Storage-Related Enhancements

  • identify the steps for employing Oracle Database’s new partitioning scheme to perform interval partitioning.
  • recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11g’s new partitioning scheme.
  • identify the steps for performing reference partitioning, using Oracle Database 11g’s new partitioning scheme.
  • recognize the steps for performing extended composite partitioning, using Oracle Database 11g’s new partitioning scheme, and for compressing tables.
  • recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database’s workload.
  • use the SQL Access Advisor to get partitioning recommendations.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?