Oracle9i Database: Implement Partitioning
Kontakt na dodavatele získáte po registraci
Tento kurz je pořádán dodavatelem, který nevyužívá placenou prezentaci na portálu EduCity.Kontaktní údaje na dodavatele získáte po registraci. Nebo použijte poptávkový formulář.
-
Kurz na míru
- ID akce:460324
Popis kurzu na míru Oracle9i Database: Implement Partitioning
Co se naučíte
This course covers in depth the management of table and index partitioning in the Oracle RDBMS. This includes purpose, administration and syntax of commands. Design and performance issues are mentioned. This course is an immediate prerequisite to the course D13289GC10 Oracle9i: Data Warehouse Administration. These two courses can be taken in the same week.
While this course is complete and is targeted at a larger audience, some detail of partitioning performance is deferred to the Data Warehouse course.
Posluchači
Database Administrators
Cíle kurzu
Choose appropriate partition attributes (keys, storage, types) for various application requirements
Create tables and indexes that are partitioned
Verify and modify the table and index partitioning and attributes thereof
Understand partitioning options with other database features
Témata kurzu
Understanding the Partitioning Design
The Management and Performance Benefits (Partition Elimination)
Tablespace, Segment, Table, and Partition Relation
Range, Hash, and List Partitions
Partitioning of Tables
Commands and Syntax
Viewing Partition Information
Partitioning of Indexes
Relation to Table Partitioning
Commands and Syntax
Modifying Partitions and Partition Attributes
Merge, Split, Exchange, and Move
Indexing
Application and Use of Partitions
Export, Import and SQL*Loader
Parallel Query and DML
This course covers in depth the management of table and index partitioning in the Oracle RDBMS. This includes purpose, administration and syntax of commands. Design and performance issues are mentioned. This course is an immediate prerequisite to the course D13289GC10 Oracle9i: Data Warehouse Administration. These two courses can be taken in the same week.
While this course is complete and is targeted at a larger audience, some detail of partitioning performance is deferred to the Data Warehouse course.
Posluchači
Database Administrators
Cíle kurzu
Choose appropriate partition attributes (keys, storage, types) for various application requirements
Create tables and indexes that are partitioned
Verify and modify the table and index partitioning and attributes thereof
Understand partitioning options with other database features
Témata kurzu
Understanding the Partitioning Design
The Management and Performance Benefits (Partition Elimination)
Tablespace, Segment, Table, and Partition Relation
Range, Hash, and List Partitions
Partitioning of Tables
Commands and Syntax
Viewing Partition Information
Partitioning of Indexes
Relation to Table Partitioning
Commands and Syntax
Modifying Partitions and Partition Attributes
Merge, Split, Exchange, and Move
Indexing
Application and Use of Partitions
Export, Import and SQL*Loader
Parallel Query and DML
