Oracle Database 12c: Implement Partitioning Ed 1 Training

Live Online & Classroom Enterprise Certification Training

The Oracle Database 12c: Implement Partitioning training deep dives into managing the partitioning using the Oracle Database 12c. You will learn the benefits of partitioning for different types of workloads. In this course, you will be introduced to Oracle Database Cloud Service.

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 12c: Implement Partitioning Ed 1 Certification Training about?

This Oracle Database 12c: Implement Partitioning training teaches you how to manage partitioning using Oracle Database 12c. Expert Oracle University instructors will demonstrate the benefits of partitioning for different types of workloads and learn the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service.

Taking this course will introduce you to several new partitioning enhancements, including partition maintenance operations on multiple partitions, heat maps, partial indexes for partitioned tables, interval-reference partitioning and online move partition capabilities. When the new enhancements are added to all the existing methods of partitioning, this large range of choices and capabilities requires that database administrators and data architects understand each partitioning method and it's appropriate uses. Proper use of partitioning can greatly benefit many types of applications including data warehouses, information life cycle management and very large databases.

What are the objectives of 12c: Implement Partitioning Ed 1 Certification Training ?

Choose appropriate partition attributes for various application requirements
Understand partitioning options with other database features
Describe Oracle Enterprise Manager support of partitioned objects
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
Gain an understanding of the Oracle Database Cloud Service

Who is 12c: Implement Partitioning Ed 1 Certification Training for?

Systems Architects
Database Administrators
Database Designers

What are the prerequisites for 12c: Implement Partitioning Ed 1 Certification Training?

Suggested Prerequisite

Basic SQL Tuning
SQL Fundamentals
Basic Database Administration
Basic Data Modeling and Relational Database Design
Basic knowledge of Data Warehousing Design

Required Prerequisite

Oracle Database: SQL Workshop I
Oracle Database 12c: Administration Workshop Ed 2
Oracle Database: SQL Tuning for Developers

Available Training Modes

Live Online Training

16 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

Partitioning Concepts

Table Versus Index Partitioning

Partitioned Tables and Indexes

Oracle Partitioning History

Partitioning Strategies: Composite Partitioning

Partitioning Strategies: Single-Level Partitioning

Manual Partitions Versus Partitioning

VLDB Manageability and Performance Constraints

Partitioned Indexes

Implementing Partitioned Tables

Creating Partitions with Enterprise Manager

Interval Partitioning

Partition Strategy Declaration: Single-Level Partitioning

Table, Partition, and Segment Relations

Range Partitioning

Logical and Physical Attributes

CREATE TABLE Statement with Partitioning

Specifying Partition Attributes

Implementing Partitioned Indexes

Local Nonprefixed Index

Index Partitioning and Type Matrix

Partitioned Index Attributes: Global or Local

Local Prefixed Indexes

Global Indexes

Partitioned Indexes

Specifying an Index with Table Creation

Partitioned Index Attributes: Prefixed or Nonprefixed

Maintenance of Partitioned Tables and Indexes

Renaming a Partition

Table and Index Interaction During Partition Maintenance

Modifying Partition Properties on the Table

Using the ALTER TABLE and ALTER INDEX Commands

Partition Storage Changes

Modifying the Logical Properties of Tables and Indexes

Moving a Partition

Maintenance: Overview

Partitioning Administration and Usage

Static and Dynamic Pruning

Dynamic Partition Pruning and Star Query

Collecting Statistics for Partitioned Objects

Using Partitioned Tables

Pruning Rules

ANALYZE and Partitioned Objects

Static Partition Pruning and Star Query

Pruning Tips

Partitioning and Workload Types

PCT Refresh: Requirements

Maintaining Partitions of a Materialized View

Using Materialized Views for Summary Management

Partitioning and Materialized Views

Partition Key or Partition Marker?

Partition Change Tracking (PCT) Refresh

When Is PCT Refresh Used?

Partitioning in Data Warehouses

Oracle Database Cloud Service: Overview

Migrating from On-premises to Oracle Cloud Database

Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning

Software Editions: Included Database Options and Management Packs

Database as a Service Architecture, Features and Tooling

Gather Information for Migration

Managing the Compute Node Associated With a Database Deployment

Managing Network Access to Database as a Service & Scaling a Database Deployment

Patching Database as a Service & Using the Oracle Database Cloud Service Console to Manage Patches

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.

12c: Implement Partitioning Ed 1 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