This Oracle Database 12c - Implement Partitioning training course teaches how to manage partitioning using Oracle Database 12c. You will learn the benefits of partitioning for different types of workloads and the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service. 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.
By attending Oracle Database 12c - Implement Partitioning workshop, delegates will learn to:
- 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
- Attend a training on Oracle Database 12c - SQL Tuning for Developers or equivalent practical experience
- Attend a training on Oracle Database 18c - Administration or equivalent practical experience
The Oracle Database 12c - Implement Partitioning class is ideal for:
- Architects
- Database Administrators
- System Integrators