D70064 - Oracle Database 11g: Administer a Data Warehouse

This course will help you understand the basic concepts of administering a data warehouse. You’ll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

Learn To:

  • Implement partitioning.
  • Use parallel operations to reduce response time.
  • Extract, transform and load data.
  • Create, use and refresh materialized views to improve data warehouse performance.
  • Use query rewrite to quickly answer business queries using materialized views.
  • Use SQL access advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrites.
  • Identify the benefits of partitioning, in addition to using parallel operations to reduce response time for data-intensive operations.

Duration: 4.0 days

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:

  • Use parallel operations to reduce response time for data-intensive operations
  • Extract, Transform, and Load data in the data warehouse
  • Create, use, and refresh materialized views to improve the data warehouse performance
  • Use Query rewrite to quickly answer business queries using materialized views
  • Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite
  • Use the features of compression and resumable sessions
  • Review the basic Oracle data warehousing concepts

Content

  • Module 1: Introduction
  • Module 2: Data Warehouse Design: Overview
  • Module 3: Data Warehouse Tuning Considerations
  • Module 4: Partitioning Basics
  • Module 5: Parallelism Concepts
  • Module 6: Parallel Operations in Data Warehouses
  • Module 7: ETL: Extraction and Transportation
  • Module 8: ETL: Loading
  • Module 9: ETL: Transformation
  • Module 10: Materialized Views
  • Module 11: Refreshing Materialized Views
  • Module 12: Working With Dimensions
  • Module 13: Query Rewrite
  • Module 14: Using the SQL Access Advisor, Compression, and Resemble Sessions

Audience

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

Prerequisites

  • Good working knowledge of SQL and in data warehouse design and implementation
  • Data Warehouse design, implementation, and maintenance experience
  • Ability to read and understand execution plans

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

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

d79995

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

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
A8iBVy
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy