BUSINESS INTELLIGENCE – DB CONCEPTS & OLAP INTRODUCTION

DURATION:

1 Day Course

COURSE GOALS:

The goals of the DB concepts & OLAP Introduction training course are: 

• To set the building blocks of database and OLAP concepts that will be used in every BI project. 
• To provide insights into the technical data structures and database objects in order to create more efficient designs. 
• To describe a range of techniques to build efficient and accomplished performing BI systems. 

TARGET AUDIENCE:

• BI Consultants – get insights into key database and OLAP concepts. 
• IT Consultants – understand the key notions of database and OLAP. 

PRE-REQUISITES:

No pre-requisites are needed to enrol in this course although basic database knowledge will help you to quickly understand the different concepts. 

LANGUAGES:

DB Concepts & OLAP Introduction is offered in English and Spanish (training material is only available in English). 

TOPICS COVERED:

Database concepts 

• Table, View & Materialised view. 
• Index, Partitioning. 
• Procedure, Function, Package & Trigger. 
• Sequence. 
• Constraint. 
• Deleting & Inserting rows. 
• Rollback segment. 
• Join. 
• Execution plan. 

OLAP 

• OLAP Technology. 
• OLAP Cube. 
• OLAP Visualisation. 
• Dimensional Data Model and OLAP Cube. 
• Types of OLAP: MOLAP, ROLAP, HOLAP. 
• Aggregation.