Oracle Database 12c: Implement Partitioning

Àííîòàöèÿ:

Êóðñ îáó÷àåò ñëóøàòåëåé ñîïðîâîæäàòü ñåêöèîíèðîâàíèå â ÁÄ Oracle 12c.  Èíñòðóêòîðû Oracle University ïðîäåìîíñòðèðóþò äîñòîèíñòâà ñåêöèîíèðîâàíèÿ äëÿ ðàçëè÷íûõ òèïîâ ðàáî÷åé íàãðóçêè îáó÷àò ñèíòàêñèñó êîìàíä ñîïðîâîæäåíèÿ ñåêöèîíèðîâàíèÿ.

Ñëóøàòåëè èçó÷àò:

• Èñïîëüçîâàíèå ñòðàòåãèé ñåêöèîíèðîâàíèÿ äëÿ óëó÷øåíèÿ ïðîèçâîäèòåëüíîñòè ïðèëîæåíèÿ 
• Èñïîëüçîâàíèå ìåòîäîâ ñåêöèîíèðîâàíèÿ äëÿ óìåíüøåíèÿ âðåìåíè ñîïðîâîæäåíèÿ òàáëèö è èíäåêñîâ 
• Èñïîëüçîâàíèå  ñåêöèîíèðîâàíèÿ äëÿ ñîêðàùåíèÿ âðåìåíè îáíîâëåíèÿ ìàòåðèàëèçîâàííûõ ïðåäñòàâëåíèé  
• Ñåêöèîíèðîâàíèå  lob ñåãìåíòîâ, âëîæåííûõ (nested) è îáúåêòíûõ òàáëèö
• Ïîíèìàíèå ìåòîäîâ ñåêöèîíèðîâàíèÿ òàáëèö, èíäåêñîâ è ìàòåðèàëèçîâàííûõ ïðåäñòàâëåíèé, äîñòóïíûõ â ÁÄ Oracle  12c Release  1.

Àóäèòîðèÿ:

• Àäìèíèñòðàòîðû áàç äàííûõ
• Äèçàéíåðû áàç äàííûõ
• Ñèñòåìíûå àðõèòåêòîðû 

Öåëè êóðñà:

• Îáçîð àðõèòåêòóðû ñåêöèîíèðîâàíèÿ, èñïîëüçîâàíèÿ è ïðåèìóùåñòâ
• Îáçîð òèïîâ ñåêöèîíèðîâàíèÿ, ïîääåðæèâàåìûõ Oracle RDBMS
• Ñïèñîê âñåõ îïöèé ñîçäàíèÿ ñåêöèîíèðîâàííûõ òàáëèö
• Ñîçäàíèå ñåêöèîíèðîâàííûõ òàáëèö
• Îïèñàíèå âçàèìîîòíîøåíèé ìåæäó ñåêöèîíèðîâàííûìè òàáëèöàìè è èíäåêñàìè
• Ñïèñîê âñåõ îïöèé ñîçäàíèÿ ñåêöèîíèðîâàííûõ èíäåêñîâ
• Ñîçäàíèå ñåêöèîíèðîâàííûõ èíäåêñîâ.
• Ñïèñîê âñåõ àòòðèáóòîâ ñåêöèîíèðîâàííûõ òàáëèö è èíäåêñîâ, êîòîðûå ìîæíî èçìåíèòü êîìàíäîé alter.
• Îïèñàíèå íàêëàäíûõ ðàñõîäîâ áàçû (overhead ), ñâÿçàííûõ ñ êàæäîé êîìàíäîé ñîïðîâîæäåíèÿ.
• Èñïîëüçîâàíèå ñëîâàðÿ äàííûõ äëÿ ïðîâåðêè ñòðóêòóðû ñåêöèîíèðîâàíèÿ îáúåêòîâ áàçû.
• Ñîçäàíèå ñåêöèîíèðîâàííûõ ìàòåðèàëèçîâàííûõ ïðåäñòàâëåíèé
• Îáçîð äîñòîèíñòâ ñåêöèîíèðîâàííûõ ìàòåðèàëèçîâàííûõ ïðåäñòàâëåíèé
• Âûáîð ñîîòâåòñòâóþùèé àòòðèáóòîâ ñåêöèîíèðîâàíèÿ äëÿ ðàçëè÷íûõ òðåáîâàíèé ïðèëîæåíèÿ
• Ïîíèìàíèå îïöèé ñåêöèîíèðîâàíèÿ äëÿ äðóãèõ îñîáåííîñòåé ÁÄ
• Îáçîð ïîääåðæêè ñåêöèîíèðîâàííûõ îáúåêòîâ â Oracle Enterprise Manager

Ïðåäâàðèòåëüíàÿ ïîäãîòîâêà:

• SQL Fundamentals
• Basic SQL Tuning
• Basic Database Administration
• Oracle Database: SQL Workshop I

Ðåêîìåíäóåìàÿ ïðåäâàðèòåëüíàÿ ïîäãîòîâêà:

• Basic Data Modeling and Relational Database Design
• Basic knowledge of Data Warehousing Design
• Oracle Database: SQL Tuning for Developers

Ïðîãðàììà êóðñà:

Partitioning Concepts

• VLDB Manageability and Performance Constraints
• Manual Partitions Versus Partitioning
• Partitioned Tables and Indexes
• Table Versus Index Partitioning
• Partitioned Indexes
• Partitioning Strategies: Single-Level Partitioning
• Partitioning Strategies: Composite Partitioning
• Oracle Partitioning History

Implementing Partitioned Tables

• Table, Partition, and Segment Relations
• Creating Partitions with Enterprise Manager
• CRE ATE TABLE Statement with Partitioning
• Logical and Physical Attributes
• Partition Strategy Declaration: Single-Level Partitioning
• Specifying Partition Attributes
• Range Partitioning
• Interval Partitioning

Implementing Partitioned Indexes

• Partitioned Indexes
• Partitioned Index Attributes: Global or Local
• Partitioned Index Attributes: Prefixed or Nonprefixed
• Global Indexes
• Local Prefixed Indexes
• Local Nonprefixed Index
• Index Partitioning and Type Matrix
• Specifying an Index with Table Creation

Maintenance of Partitioned Tables and Indexes

• Maintenance: Overview
• Table and Index Interaction During Partition Maintenance
• Modifying the Logical Properties of Tables and Indexes
• Modifying Partition Properties on the Table
• Using the ALT ER TABLE and ALT ER INDEX Commands
• Renaming a Partition
• Partition Storage Changes
• Moving a Partition

Partitioning Administration and Usage

• Using Partitioned Tables
• Pruning Rules
• Static and Dynamic Pruning
• Pruning Tips
• Static Partition Pruning and Star Query
• Dynamic Partition Pruning and Star Query
• Collecting Statistics for Partitioned Objects
• ANALYZE and Partitioned Objects

Partitioning and Workload Types

• Partitioning in Data Warehouses
• Using Materialized Views for Summary Management
• Partitioning and Materialized Views
• Maintaining Partitions of a Materialized View
• Partition Change Tracking (PCT) Refresh
• PCT Refresh: Requirements
• When Is PCT Refresh Used?
• Partition Key or Partition Marker?