Data Warehouse Database Design

amk-group
Inhouse

2.200 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
030 -... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

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

Wichtige informationen

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


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen