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.
Start learning today!
Click Hereto customize your Training
Private training brings the classroom or virtual classroom experience to your office or a preferred offsite location. Convenient, practical, and effective training tailored to your company's needs.
If you have multiple locations, please list them in the comments section.
Upon completing this course, the learner will be able to meet these overall objectives:
Module 1: Introduction to Partitioning
Module 2: Implementing Partitioned Tables
Module 3: Implementing Partitioned Indexes
Module 4: Maintenance of Partitioned Tables and Indexes
Module 5: Partitioning Administration and Usage
Module 6: Partitioning and Workload Types
This course is not associated with any Certification.