Oracle Database 11g: Data Warehousing Fundamentals (D56261)

Oracle Database 11g: Data Warehousing Fundamentals (D56261)

Overview

Duration: 5 days

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.

Objectives

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

    Module 2: Data Warehousing, Business Intelligence, OLAP, and Data Mining

    Module 3: Defining Data Warehouse Concepts and Terminology

    Module 4: Business, Logical, Dimensional, and Physical Modeling

    Module 5: Database Sizing, Storage, Performance, and Security Considerations

    Module 6: The ETL Process: Extracting Data

    Module 7: The ETL Process: Transforming Data

    Module 8: The ETL Process: Loading Data

    Module 9: Refreshing the Warehouse Data

    Module 10: Materialized Views

    Module 11: Leaving a Metadata Trail

    Module 12: Data Warehouse Implementation Considerations
    N/A
    • Knowledge of general data warehousing concepts
    • Knowledge of client-server technology
    • Knowledge of relational server technology
    Course ID:
    D56261


    Show Schedule for:



    © Copyright Trainocate 2019 . All rights reserved.

    ▲