D68861 - Implement Oracle Data Warehousing Best Practices

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.

Duration: 1.0 day

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Upon completing this course, the learner will be able to meet these overall 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

Content

  • Module 1: Introduction
  • Module 2: Building a Balanced Hardware Configuration
  • Module 3: Data Warehouse Logical and Physical Design
  • Module 4: Loading Data: Best Practices
  • Module 5: Managing the System Workload and Resources

Audience

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

Prerequisites

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

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d83527

D83527 - Java SE 8 Fundamentals

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop
Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy