Implement Oracle Data Warehousing Best Practices - Fudgelearn

Implement Oracle Data Warehousing Best Practices

Date
Time
Price
Date
Time
Price
Location
05-Jun-2020
02:00 AM BST - 10:00 PM BST
£ 0
Live Virtual Class
Date
Start time
Price
Location
Version title
Price

In this course, participants learn about the best practices for implementing an enterprise data warehouse. Participants identify the hardware elements that influence the throughput and learn how to build a balanced hardware configuration. Participants also review the two classic models: Third normal form (3NF) and star schema and learn how to optimize both models. Participants learn how to convert the logical model into a suitable physical model. Participants also learn how to load data efficiently into the data warehouse and how to use partition exchange load and data compression during the ETL process to improve performance. Finally, participants learn to manage the system workload and resources, to ensure an Enterprise Data Warehouse can run at optimal performance, and explains how parallel execution enables them to fully utilize the system. In addition, participants describe how to gather statistics efficiently.

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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Required Prerequisite

  • Oracle Database 11g: Data Warehousing Fundamentals Ed 1 LVC
  • Oracle Database 11g: Administer a Data Warehouse, or experience in data warehouse design, implementation, and maintenance
  • Administrator
  • Database Administrator
  • Developer
  • 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
  • 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)
  • 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
  • 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
  • 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
  • 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
Need help finding the right course

Having problem finding the course you’re looking for? Get in touch.

1 Days
Live Virtual Class
1 Event available
Share this Course
Get in touch
If you would like to find out how we can help you, please get in touch
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Print
Use the links below to print the details.
Convince your boss

Implement Oracle Data Warehousing Best Practices

Course Overview

In this course, participants learn about the best practices for implementing an enterprise data warehouse. Participants identify the hardware elements that influence the throughput and learn how to build a balanced hardware configuration. Participants also review the two classic models: Third normal form (3NF) and star schema and learn how to optimize both models. Participants learn how to convert the logical model into a suitable physical model. Participants also learn how to load data efficiently into the data warehouse and how to use partition exchange load and data compression during the ETL process to improve performance. Finally, participants learn to manage the system workload and resources, to ensure an Enterprise Data Warehouse can run at optimal performance, and explains how parallel execution enables them to fully utilize the system. In addition, participants describe how to gather statistics efficiently.

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

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Classroom
Date
Start time
Price
Location
05-Jun-2020
02:00 AM BST
£ 0
Live Virtual Class
Prerequisites

Required Prerequisite

  • Oracle Database 11g: Data Warehousing Fundamentals Ed 1 LVC
  • Oracle Database 11g: Administer a Data Warehouse, or experience in data warehouse design, implementation, and maintenance
Audience
  • Administrator
  • Database Administrator
  • Developer
Objectives
  • 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
Topics
  • 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)
  • 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
  • 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
  • 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
  • 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