Oracle Database 12c: Implement Partitioning

  • Êîä êóðñà: 12cIP
  • Äëèòåëüíîñòü: 2 ä.
  • Öåíà: 126 500 Ð 22 350 Ð
    Äàííàÿ öåíà äåéñòâèòåëüíà íà êóðñ, ïðîâîäèìûé â ïåðèîä ñ 01.01.2022 ïî 01.11.2030

Àííîòàöèÿ:

Êóðñ îáó÷àåò ñëóøàòåëåé ñîïðîâîæäàòü ñåêöèîíèðîâàíèå â ÁÄ 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


Çàÿâêà íà îáó÷åíèå

* - îáÿçàòåëüíûå ïîëÿ

Çàÿâêà íà îáó÷åíèå

Çàïèñàòüñÿ íà êóðñ:

Ãîðîä:

Äàòà:

* - îáÿçàòåëüíûå ïîëÿ