Oracle Database 12c: Implement Partitioning

Oracle Database 12c: Implement Partitioning Certification Training Course Overview

This course has been designed to impart the in-depth knowledge about the partitioning types and architecture in the Oracle RDBMS. The process of partitioning tables and partitioned indexes, use of data dictionaries and creating materialized views are the prime areas of course delivery. Various partitions tabled attributes will be demonstrated and participants will explore the support of Oracle Enterprise Manager for partitioned objects.

Test your current knowledge Qubits42

Oracle Database 12c: Implement Partitioning (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
04 - 05 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)
01 - 02 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1:Partitioning Concepts
  • VLDB Manageability and Performance Constraints
  • Manual Partitions Versus Partitioning
  • Partitioned Tables and Indexes
  • Table Versus Index Partitioning
  • Partitioned Indexes
  • Partitioning Strategies: Single-Level Partitioning
  • Partitioning Strategies: Composite Partitioning
  • Oracle Partitioning History
Module 2:Implementing Partitioned Tables
  • Table, Partition, and Segment Relations
  • Creating Partitions with Enterprise Manager
  • CREATE TABLE Statement with Partitioning
  • Logical and Physical Attributes
  • Partition Strategy Declaration: Single-Level Partitioning
  • Specifying Partition Attributes
  • Range Partitioning
  • Interval Partitioning
Module 3:Implementing Partitioned Indexes
  • Partitioned Indexes
  • Partitioned Index Attributes: Global or Local
  • Partitioned Index Attributes: Prefixed or Nonprefixed
  • Global Indexes
  • Local Prefixed Indexes
  • Local Nonprefixed Index
  • Index Partitioning and Type Matrix
  • Specifying an Index with Table Creation
Module 4:Maintenance of Partitioned Tables and Indexes
  • Maintenance: Overview
  • Table and Index Interaction During Partition Maintenance
  • Modifying the Logical Properties of Tables and Indexes
  • Modifying Partition Properties on the Table
  • Using the ALTER TABLE and ALTER INDEX Commands
  • Renaming a Partition
  • Partition Storage Changes
  • Moving a Partition
Module 5: Partitioning Administration and Usage
  • Using Partitioned Tables
  • Pruning Rules
  • Static and Dynamic Pruning
  • Pruning Tips
  • Static Partition Pruning and Star Query
  • Dynamic Partition Pruning and Star Query
  • Collecting Statistics for Partitioned Objects
  • ANALYZE and Partitioned Objects
Module 6:Partitioning and Workload Types
  • Partitioning in Data Warehouses
  • Using Materialized Views for Summary Management
  • Partitioning and Materialized Views
  • Maintaining Partitions of a Materialized View
  • Partition Change Tracking (PCT) Refresh
  • PCT Refresh: Requirements
  • When Is PCT Refresh Used?
  • Partition Key or Partition Marker?
Module 7:Oracle Database Cloud Service: Overview
  • Database as a Service Architecture, Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to Database as a Service & Scaling a Database Deployment
  • Patching Database as a Service & Using the Oracle Database Cloud Service Console to Manage Patches
  • Migrating from On-premises to Oracle Cloud Database
  • Gather Information for Migration
Download Course Contents

Request More Information

Course Prerequisites
  • Good knowledge of Oracle Database

Upon Completion of this Course, you will accomplish following:

  • Understand the partitioning advantages and architecture
  • Explore various partition types in the Oracle RDBMS
  • Understand the partition options, creating partition tables and indexes
  • Specify relationships  between table and index
  • Identify the associated overhead with maintenance commands
  • Verify the partitioning structure
  • Explore and create Materialized Views
  • Track the performance of a partitioned materialized views
  • Set various partitioning options in regard to the features of databases
  • Explore Oracle Enterprise Manager to support partitioned objects

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 12c Implement Partitioning Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

FAQ's