Oracle Database 11g: Implement Partitioning Release 2

Duration : 2 Days

What you will learn

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.

Learn to:

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

Audience

  • Architect
  • Data Warehouse Administrator
  • Database Administrators
  • Database Designers

Related Training

Required Prerequisites

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

Course Objectives

  • 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 materialized views
  • Show performance enhancements of partitioned materiized views
  • Choose appropriate partition attributes for various application requirements
  • Describe Oracle Enterprise Manager Support of partitioned objects

Course Outline :

Popular Courses

Related Courses

Testimonials

Thank you EZY Intellect and Trainer for your support to become an Oracle Certified Professional

thumb Mr. Tint Aung Shwe
Assistant Manager (IT Department)-AYA Bank,August 29, 2017

This training helped me identify clear and do-able next steps toward my goal. Thank you EZY Intellect and Mr.Kushantha ( EC-Council Certified Trainer) for very valuable training.

thumb Mr. Kyaw Htet
CEH V10,21,22,23,29,30 Sep 2018