View Schedule

What you will learn:

In this course students will set the building blocks of database and OLAP concepts that will be used in every BI project. This knowledge will provide them with an insight of the technical data structures and database objects in order to create more efficient designs. Also some techniques will be imparted to the students to build efficient and good performing BI systems.

Course Description:

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

Topics Covered:

• Database concepts
  • 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

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

View Schedule