RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



Implement Oracle Data Warehousing Best Practices (D65995GC10)

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D65995GC10

Dla kogo

  • Application Developers
  • Data Warehouse Administrator
  • Data Warehouse Developer
  • Database Administrators
  • Support Engineer

Czas trwania

1 dzień

Cena bazowa

PLN 1490

Cel

  • Convert the logical model into the suitable physical model
  • Describe the various methods to load data efficiently into the data warehouse
  • Use partition exchange load and data compression during staging to improve performance
  • Describe the methods of running the Enterprise Data Warehouse at optimal performance
  • Explain how parallel execution enables you to fully utilize the system
  • Describe how to monitor workload
  • Describe how to gather statistics efficiently
  • Optimize the Star schema model
  • Identify the hardware elements that influence the throughput
  • Build a balanced hardware configuration
  • Discuss and apply the two classic models, third normal form (3NF) or star schema, depending on the business information needs
  • Optimize the third normal form design

Opis

This Implement Oracle Data Warehousing Best Practices training helps you build a balanced hardware configuration. You'll learn how to identify the hardware elements that influence the throughput; you'll also review two classic models and how to optimize them: third normal form (3NF) and star schema.Learn To:Describe how to build a balanced hardware configuration.Discuss and apply the two classic models, the third normal form (3NF) or star schema.Describe how to convert the logical model into the suitable physical model.Describe the various methods to load data efficiently into the data warehouse.Use partition exchange load and data compression during staging to improve performance.Manage the system workload and resources.Convert the logical model into a suitable physical model. Benefits to YouEnrolling in this course will teach you how to load data efficiently into the data warehouse and use partition exchange load and data compression during the ETL process to improve performance. You'll also learn how to manage the system workload and resources, ensure an Enterprise Data Warehouse can run at optimal performance and understand how parallel execution enables you to fully utilize the system. Expert Oracle University instructors will also show you how to gather statistics efficiently.

Tematy

  1. Introduction
    • Prerequisites and Suggested Prerequisites
    • Questions About You
    • Course Objectives
    • Course Agenda
    • Sample Schemas Used in the Course
    • The Sales History (SH) Schema
    • Oracle 11g SQL and Data Warehousing Guide Documentation
    • Additional Resources: Oracle By Example (OBE)
  2. Building a Balanced Hardware Configuration
    • Maintaining High Throughput
    • Balanced System
    • Components of Hardware Configuration
    • Example of a Balanced System: 4-Node RAC Environment
    • Data Warehouse Hardware Configuration: Best Practices
    • Disk Layout and Design
    • Implementing S.A.M.E. Using ASM and Hardware Mirroring
  3. Data Warehouse Logical and Physical Design
    • Data Warehouse Models: 3NF and Star
    • Industry Best Practices: When to Use Each Model
    • The Typical Blueprint of Physical Layers in a Data Warehouse Environment
    • Optimizing 3rd Normal Form: Power, Partitioning, Parallelism
    • Partitioning Strategies Example: Composite Range-Hash Partitioning
    • Partition Pruning
    • Partition Wise Join
    • Optimizing Star Queries: Star Transformation
  4. Loading Data: Best Practices
    • Loading Data into the Warehouse
    • The Three Layers of ETL
    • Data Loading Methods in a Data Warehouse
    • Loading Data from Flat Files into the Data Warehouse Using External Tables
    • Pre-Processing in an External Table
    • Using Direct Path Load
    • Partition Exchange Loading
    • Tips for Data Loading: File Size and Formats, Compression, and Statistics
  5. Managing the System Workload and Resources
    • System Management: Keeping the Lights On for Your Data Warehouse
    • Scanning a Table in Parallel
    • SQL Parallel Execution: Overview
    • Parallel Execution In Action
    • General Rules on When to Use Parallel Execution
    • Workload Monitoring Using (G)V$ Views or Oracle EM 11g
    • Oracle Resource Manager
    • Gathering Statistics

Wymagania

    • Oracle Database 11g: Administer a Data Warehouse ILT, or experience in data warehouse design, implementation, and maintenance

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.