BI CORE – DB CONCEPTS & OLAP INTRODUCTION

Todos nuestros cursos pueden ser impartidos en Español. Sin embargo, no podemos garantizar que dispongamos de todos los materiales lectivos en dicho idioma.

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 insight of the technical data structures and database objects in order to create more efficient designs. 
  • To describe some techniques to build efficient and good performing BI systems. 

 

TARGET AUDIENCE:

  • BI Consultants – get insight of key database and OLAP concepts. 
  • IT Consultants – understand the key concepts of database and OLAP. 

 

PRE-REQUISITES:

No pre-requisites are needed to enroll 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). 

 

TOPIC 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. 

RELATED COURSES:

BI Fundamentals
Dimensional Modeling

REQUEST MORE INFORMATION

For further information about this course, please fill out the form below.