Programm

  1. Partitioning Concepts

  2. Implementing Partitioned Tables

  3. Implementing Partitioned Indexes

  4. Maintenance of Partitioned Tables and Indexes

  5. Partitioning Administration and Usage

  6. 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:

  • 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
Noch nicht bewertet