Data Warehouse Database Design

amk-group
Inhouse

2.200 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
030 -... Mehr ansehen

Wichtige informationen

Tipologie Seminar
Niveau Anfänger
Methodologie Inhouse
Dauer 2 Tage
  • Seminar
  • Anfänger
  • Inhouse
  • Dauer:
    2 Tage
Beschreibung

In this course, students are presented with the basic concepts, fundamental issues, and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the data warehouse design process, including business modeling, entity relationship diagramming, dimensional modeling, physical modeling, and warehouse meta data management.

Häufig gestellte Fragen

· Voraussetzungen

In-depth understanding of data warehousing concepts

Familiarity with data modeling and relational database design

Themenkreis

Seminarziel:

In this course, students are presented with the basic concepts, fundamental issues, and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the data warehouse design process, including business modeling, entity relationship diagramming, dimensional modeling, physical modeling, and warehouse meta data management.

Zielgruppe:

Database Administrators

Implementation Team

Data Warehouse Designer

Data Warehouse Administrator

Inhalt:

  • Reviewing Data Warehouse Basics


  • Defining the Business & Logical Models


  • Creating the Dimensional Model


  • Creating the Physical Model


  • Storage Considerations for the Physical Model


  • Strategies for Extracting, Transforming, and Transporting


  • Summary Management


  • Analytical Capabilities


Voraussetzung:

In-depth understanding of data warehousing concepts

Familiarity with data modeling and relational database design


User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen