Oracle Database 11g: Data Warehousing Fundamentals - Fudgelearn
Need help finding the right course

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

£ 792
Train when and where you want, at your own place.
£ 1323
3 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: Data Warehousing Fundamentals

Course Overview

This Oracle Database 11g: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.

Learn To:

  • Define the terminology and explain basic concepts of data warehousing.
  • Identify the technology and some of the tools from Oracle to implement a successful data warehouse.
  • Describe methods and tools for extracting, transforming and loading data.
  • Identify some of the tools for accessing and analyzing warehouse data.
  • Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse.
  • Explain the implementation and organizational issues surrounding a data warehouse project.
  • Improve performance or manageability in a data warehouse using various Oracle Database features.

Oracle’s Database Partitioning Architecture

You'll also explore the basics of Oracle’s Database partitioning architecture, identifying the benefits of partitioning. Review the benefits of parallel operations to reduce response time for data-intensive operations. Learn how to extract, transform and load data (ETL) into an Oracle database warehouse.

Improve Data Warehouse Performance

Learn the benefits of using Oracle’s materialized views to improve the data warehouse performance. Instructors will give a high-level overview of how query rewrites can improve a query’s performance. Explore OLAP and Data Mining and identify some data warehouse implementations considerations.

Use Data Warehousing Tools

During this training, you'll briefly use some of the available data warehousing tools. These tools include Oracle Warehouse Builder, Analytic Workspace Manager and Oracle Application Express.

Subscription
Date
Start time
Price
Location
£ 792
Training on Demand
Date
Start time
Price
Location
Available On Demand
£ 1323
Audience
  • Administrator
  • Analyst
  • Developer
  • Implementer
  • Manager
Objectives
  • Describe methods and tools for extracting, transforming, and loading data
  • Identify some of the tools for accessing and analyzing warehouse data
  • Identify the technology and some of the tools from Oracle to implement a successful data warehouse
  • Define the decision support purpose and end goal of a data warehouse
  • Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
  • Explain the implementation and organizational issues surrounding a data warehouse project
  • Use materialized views and query rewrite to improve the data warehouse performance
  • Define the terminology and explain the basic concepts of data warehousing
  • Develop familiarity with some of the technologies required to implement a data warehouse
Topics
  • Introduction
  • Data Warehousing, Business Intelligence, OLAP, and Data Mining
  • Defining Data Warehouse Concepts and Terminology
  • Business, Logical, Dimensional, and Physical Modeling
  • Database Sizing, Storage, Performance, and Security Considerations
  • The ETL Process: Extracting Data
  • The ETL Process: Transforming Data
  • The ETL Process: Loading Data
  • Refreshing the Warehouse Data
  • Materialized Views
  • Leaving a Metadata Trail
  • Data Warehouse Implementation Considerations