CEL Best of Partitioning with Uwe Hesse (D101218)

 

Course Overview

In this one day seminar, Uwe Hesse will review some of the key aspects of partitioning across all versions, including some new features of 12c.

Learn About:
  • Partition Pruning.
  • Rolling Window.
  • Interval Partitioning.
  • Compressed Partitions.
  • Exchange Partition.
  • Partition Indexes: Local vs Global.
  • When to use which kind of partitioned index.
  • Reducing contention with Hash partitioning.
  • 12c New Features:.
  • Online partition move.
  • Partial indexing.

Who should attend

  • Database Administrators
  • Architect
  • Project Manager

Prerequisites

  • Prior knowledge of partitioning is not required

Course Objectives

  • Learn to use the most important and most efficient techniques related to partitioning

Course Content

  • Partition Pruning
  • Rolling Window
  • Interval partitioning
  • Compressed Partitions
  • Exchange Partition
  • Partitioned Indexes: Local vs Global

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • 677.— €

Currently there are no training dates scheduled for this course.