You are here:Courses|Oracle|Data Warehouse|Oracle Database 11g: Implement Partitioning Release 2

Oracle Database 11g: Implement Partitioning Release 2

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.

 

Schedule for Oracle Database 11g Implement Partitioning Release 2 Training Boot Camp
Course Contents Regular Track (days)
Oracle Database 11g: Implement Partitioning Release 2 2
Balance Days  for day of arrival, exam and practice 1
Total duration 3

Prerequisites :

  • Basic Oracle Database administration, Basic SQL Skills
  • Oracle Database 11g: Administration Workshop I DBA Release 2
  • Oracle Database 11g: Administration Workshop II DBA Release 2

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email: [email protected]