Oracle Database 11g: Administer a Data Warehouse - Fudgelearn

Oracle Database 11g: Administer a Data Warehouse

Date
Time
Price
Date
Time
Price
Location
Date
Start time
Price
Location
Version title
Price
Oracle Database 11g: Administer a Data Warehouse
£ 1764

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.

Benefits To You

Expert instructors will also teach you how to extract, transform and load data into an Oracle database warehouse. Discover how to use SQL Access Advisor to optimize the entire workload. Use materialized views to improve data warehouse performance and learn how query rewrites can improve performance.

Required Prerequisite

  • 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
  • Administrator
  • Database Administrator
  • Developer
  • Implementer
  • 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
  • Introduction
  • Data Warehouse Design: Overview
  • Data Warehouse Tuning Considerations
  • Partitioning Basics
  • Parallelism Concepts
  • Parallel Operations in Data Warehouses
  • ETL: Extraction and Transportation
  • ETL: Loading
  • ETL: Transformation
  • Materialized Views
  • Refreshing Materialized Views
  • Working With Dimensions
  • Query Rewrite
  • Using the SQL Access Advisor, Compression, and Resumable Sessions
Need help finding the right course

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

£ 1764
4 Days
Train online via an Internet connection, 24/7
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

Oracle Database 11g: Administer a Data Warehouse

Course Overview

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.

Benefits To You

Expert instructors will also teach you how to extract, transform and load data into an Oracle database warehouse. Discover how to use SQL Access Advisor to optimize the entire workload. Use materialized views to improve data warehouse performance and learn how query rewrites can improve performance.

Training on Demand
Date
Start time
Price
Location
Available On Demand
£ 1764
Prerequisites

Required Prerequisite

  • 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
Audience
  • Administrator
  • Database Administrator
  • Developer
  • Implementer
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
Topics
  • Introduction
  • Data Warehouse Design: Overview
  • Data Warehouse Tuning Considerations
  • Partitioning Basics
  • Parallelism Concepts
  • Parallel Operations in Data Warehouses
  • ETL: Extraction and Transportation
  • ETL: Loading
  • ETL: Transformation
  • Materialized Views
  • Refreshing Materialized Views
  • Working With Dimensions
  • Query Rewrite
  • Using the SQL Access Advisor, Compression, and Resumable Sessions