Implement Oracle Data Warehousing Best Practices Training

Live Online & Classroom Enterprise Certification Training

Learn about the best practices for implementing an enterprise data warehouse by taking this course. Learn about building a balanced hardware configuration and review the two classic models: Third normal form and star schema. Also learn 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, learn to manage the system workload and resources.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Data Warehousing Best Practices Certification Training about?

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

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.

What are the objectives of Data Warehousing Best Practices Certification Training ?

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

Who is Data Warehousing Best Practices Certification Training for?

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

What are the prerequisites for Data Warehousing Best Practices Certification Training?

Suggested Prerequisite

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

Required Prerequisite

Oracle Database 11g: Data Warehousing Fundamentals

Available Training Modes

Live Online Training

Course Outline Expand All

Expand All

Introduction

Prerequisites and Suggested Prerequisites

Course Agenda

Oracle 11g SQL and Data Warehousing Guide Documentation

The Sales History (SH) Schema

Questions About You

Additional Resources: Oracle By Example (OBE)

Course Objectives

Sample Schemas Used in the Course

Building a Balanced Hardware Configuration

Example of a Balanced System: 4-Node RAC Environment

Data Warehouse Hardware Configuration: Best Practices

Implementing S.A.M.E. Using ASM and Hardware Mirroring

Balanced System

Components of Hardware Configuration

Disk Layout and Design

Maintaining High Throughput

Data Warehouse Logical and Physical Design

Optimizing 3rd Normal Form: Power, Partitioning, Parallelism

Partition Pruning

Industry Best Practices: When to Use Each Model

Data Warehouse Models: 3NF and Star

The Typical Blueprint of Physical Layers in a Data Warehouse Environment

Partition Wise Join

Partitioning Strategies Example: Composite Range-Hash Partitioning

Optimizing Star Queries: Star Transformation

Loading Data: Best Practices

Loading Data from Flat Files into the Data Warehouse Using External Tables

Using Direct Path Load

Tips for Data Loading: File Size and Formats, Compression, and Statistics

Loading Data into the Warehouse

Data Loading Methods in a Data Warehouse

The Three Layers of ETL

Partition Exchange Loading

Pre-Processing in an External Table

Managing the System Workload and Resources

Oracle Resource Manager

Scanning a Table in Parallel

System Management: Keeping the Lights On for Your Data Warehouse

General Rules on When to Use Parallel Execution

Workload Monitoring Using (G)V$ Views or Oracle EM 11g

Gathering Statistics

SQL Parallel Execution: Overview

Parallel Execution In Action

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Data Warehousing Best Practices Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree