DB2 Data Warehousing Fundamentals

Wise

Course

In Gatwick

£ 1,175 + VAT

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc. Suitable for: IT developers, database administrators or anyone responsible for a data warehouse or related discipline.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

At least six (6) months in a DB2 environment or its equivalent.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme


Summary:
This dimensional modelling techniques course is designed to answer questions, such as the following:

  • What is data warehousing?
  • What is a data mart?
  • What are the data modelling options?
  • What are the terms and concepts specific to data warehousing and OLAP design?
  • How to plan and implement a data warehouse with high availability, simplified manageability and optimal performance
  • What are common statistics, analytic and OLAP SQL queries?


Objectives:
Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.

See related categories

DB2 Data Warehousing Fundamentals

£ 1,175 + VAT

The best Other Database courses

See all

See all