Oracle Database Oracle Database 11g Implement Partitioning

Duration: 
2 days
Codes: 
11G,D71835
Versions: 
NULL

Overview

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

Audience

This Oracle Database 11g Release 2 DBA - Part II course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g Release 1 or Release 2

Skills Gained

  • Apply partitioning strategies to enhance application performance
  • Use partitioning techniques to reduce impact of table and index maintenance
  • Use partitioning to decrease the time to refresh materialized views

Prerequisites

Required 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

Course Outline

Oracle Database 11g Release 2 DBA - Part II Training Course Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite
Onsite2 1000 £1000 2019-05-23