Home > Vendors > oracle > d58832

D58832 - Oracle Database 11g: OLAP Essentials

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.

Duration: 3.0 days

Start learning today!

Click Hereto customize your Training

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

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

d83527

D83527 - Java SE 8 Fundamentals

d79995

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

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

Enquire Now

By clicking "Submit", I agree to the Terms Of Use and Privacy Policy

➤