Programm
- Partitioning Concepts
- Implementing Partitioned Tables
- Implementing Partitioned Indexes
- Maintenance of Partitioned Tables and Indexes
- Partitioning Administration and Usage
- Partitioning and Workload Types
Ziele
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.
Nach Abschluss des Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:
Nach Abschluss des Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:
- 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.
- Partition lob segments, nested tables and object tables.
- Understand the Oracle Partitioning methods for tables, index and materialized views available in Oracle Database 12c Release 1.
Voraussetzungen
Für dieses Seminar werden folgende Kenntnisse empfohlen:
- SQL Fundamentals
Basic SQL Tuning
Basic Database Administration
Oracle Database: SQL Workshop I