Oracle Database 11g: Implement Partitioning Release 2 Training

Live Online & Classroom Enterprise Certification Training

Print Preview This course covers in depth the management of partitioning using the Oracle Database 11g Release 2. This includes purpose, administration, and syntax of commands. Design and performance issues are mentioned. This course is based on Oracle Database 11g Release 2 Patch Set 1.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Implement Partitioning Release 2 Certification Training about?

This course will discuss the Oracle Partitioning methods for tables, index, and materialized views that are available in Oracle Database 11g Release 2 with examples and explanations of appropriate use. Oracle Database 11g introduces several new partitioning methods: Reference partitioning, System partitioning, Interval partitioning, Virtual column partitioning, and several new composite partitioning methods: Range-Range, Hash-Hash, List-List, List-Hash, List-Range, along with Interval-Range, Interval-Hash, and Interval-List. When added to all the existing methods of partitioning, this large range of choices require that Database Administrators and Data Architects understand each method and appropriate uses.

The course will also cover partitioning of Lob segments, nested tables, and object tables. Proper use of partitioning can greatly benefit many types of applications including Data Warehouses, Information Lifecycle management, and very large databases in general.

This course is based on Oracle Database 11g Release 2 Patch Set 1.

What are the objectives of Implement Partitioning Release 2 Certification Training ?

Understand partitioning options with other database features
Describe the partitioning architecture, uses, and advantages
Describe the partition types supported by the Oracle RDBMS
List all of the options for creating partition tables
Create partitioned tables
Describe the table and index partition relationships
List all the options of partitioned indexes
Create partitioned indexes
List all of the alterable partitioned table and index attributes
Describe the overhead associated with each maintenance command
Use the data dictionary to verify partitioning structure
Create Materialized Views that are partitioned
Explain the benefits of partitioning materialzied views
Show performance enhancements of partitioned materiized views
Choose appropriate partition attributes for various application requirements
Describe Oracle Enterprise Manager support of partitioned objects

Who is Implement Partitioning Release 2 Certification Training for?

Data Warehouse Administrator
Database Administrators
Database Designers
Architect

What are the prerequisites for Implement Partitioning Release 2 Certification Training?

Suggested Prerequisite

Basic Oracle Database administration, Basic SQL Skills

Required Prerequisite

Oracle Database 11g: Administration Workshop I Release 2
Oracle Database 11g: Administration Workshop II Release 2

Available Training Modes

Live Online Training

Course Outline Expand All

Expand All

Introduction to Partitioning

Benefits of Partitioning

Performance Consideration, Manageability & Partitioning Methods

SQL-Loader, Partitioned Objects and Partitioning History

Manual Partitions

VLDB Manageability and Performance Constraints

Proof of Pruning

Partitioned Tables, Indexes, Materialized Views

Table Versus Index Partitioning, Partitioned Indexes & Verifying Partition Use

Implementing Partitioned Tables

Partitioned Object Tables and Partitioned Tables with Object Types

Index Organized Table (IOT) Partitioning, LOB Partitioning

Composite Partitioning

Partition Key Value, Range Partitioning, Interval Partitioning, Multicolumn Partitioning

The CREATE TABLE Statement with Partitioning

List Partitioning, Hash Partitioning, Named Partitions & Hash Partitioning: Quantity of Partitions

Equipartitioning & General Restrictions

Table, Partition, and Segment Relations

Implementing Partitioned Indexes

Index Partitioning and Type Matrix

Graphic Comparison of Partitioned Index Types

Local Prefix Index Examples, Local Nonprefixed Index

Index Partitioning Types

Partitioned Indexes & Partitioned Index Attributes

Specifying Index with Table Creation

Index Partition Status, Data Dictionary Views Indexes & Guidelines for Partitioning Indexes

Global Indexes, Local Prefixed Index

Maintenance of Partitioned Tables and Indexes

Using the ALTER TABLE or INDEX Commands

Table and Index Interaction During Partition Maintenance

Moving a Partition, Adding a Partition, Dropping a Partition, Splitting and Merging a Partition, Coalescing a Partition, Rebuilding Indexes

Partition Storage Changes

Modifying Partition Properties on the Table

Maintenance Overview

Renaming a Partition

Modifying a Table or Indexing Logical Properties

Partitioning Administration and Usage

SQL*Loader Direct Path Parallel Loads

SQL*Loader and Partitioned Objects

Using Partitioned Tables

ANALYZE and Partitioned Objects & Data Dictionary View Statistics

Pruning Rules, Partition-wise Joins

SQL*Loader Conventional Path

Export and Import

SQL*Loader Direct Path Sequential Loads

Partitioning and Workload Types

Partitioning for Information Lifecycle Management

Partitioning in OLTP Environments

Partitioning in Data Warehouses

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Implement Partitioning Release 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree