Oracle Database 12c: Implement Partitioning
- Êîä êóðñà: 12cIP
- Äëèòåëüíîñòü: 2 ä.
-
Öåíà:
126 500 Ð22 350 Ð
Îïèñàíèå êóðñà
Àííîòàöèÿ:
Êóðñ îáó÷àåò ñëóøàòåëåé ñîïðîâîæäàòü ñåêöèîíèðîâàíèå â ÁÄ 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?
Çàïèñàòüñÿ íà êóðñ: Oracle Database 12c: Implement Partitioning