trainocate-oracle-training-b
Home > Vendors > Oracle > d58832

D58832 - Oracle Database 11g: OLAP Essentials

Overview

Duration: 3 days
This Oracle Database 11g: OLAP Essentials training will teach you how to progressively build an OLAP data model to support a wide range of business intelligence requirements. Expert Oracle University instructors will teach you how to design OLAP cubes to serve as a summary management resource for existing SQL table queries.

Learn To:

  • Design and create an Oracle OLAP data model.
  • Enable query rewrite to OLAP Cube MVs for relational summary management.
  • Easily create OLAP calculations that enrich the analytic content of your data model.
  • Query OLAP data using simple SQL.
  • Implement cube security.
  • Efficiently design cubes for performance and scalability.
  • Create sophisticated reports of OLAP data by using simple SQL queries.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

  • Describe OLAP concepts and terminology
  • Examine the role of Oracle OLAP within the Oracle BI / DW Platform
  • Design and create OLAP Cubes
  • Enable query rewrite to OLAP Cube MVs for summary management
  • Create OLAP calculated measures
  • Query stored and calculated OLAP data with simple SQL
  • Use ad hoc query and reporting tools against OLAP data
  • Implement cube security
  • Efficiently design cubes for performance and scalability

Content

Module 1: Examining the Role of Oracle OLAP within the Oracle BI / DW Platform

Module 2: Understanding the Dimensional Model

Module 3: Building OLAP Cubes

Module 4: Examining Cube-Organized Materialized Views (Cube MVs)

Module 5: Creating Calculated Measures

Module 6: Using SQL to Query Oracle OLAP Cubes

Module 7: Enhancing Analytic Content

Module 8: Using Ad Hoc Query and Reporting Tools Against OLAP Data

Module 9: Implementing Cube Security

Module 10: Designing Cubes for Performance and Scalability

Module 11: Examining Performance Tuning

Audience

  • Database Administrators
  • Business Analysts
  • Data Warehouse Analyst
  • Business Intelligence Developer
  • Data Warehouse Developer
  • Data Warehouse Administrator

Prerequisites

  • Basic SQL knowledge
  • A basic understanding of OLAP concepts

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for:




➤