Data Warehouse Database Design

Doelgroep | Voorkennis | Doel | Onderwerpen | Data & prijzen | Aanmelden
Deze PlusPartner cursus hebben we niet meer in ons assortiment maar nog wel andere cursussen, bijvoorbeeld:Meer informatie? Klik hier!

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. Participants use a case study to apply these concepts and methods. Group discussions and practices are included.A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Doelgroep cursus Data Warehouse Database Design

Data Warehouse Administrator


Wij adviseren onderstaande voorkennis:

  • In-depth understanding of data warehousing concepts


  • Describe the role of meta data in data warehouse design and strategies to define and maintain meta data

Onderwerpen cursus Data Warehouse Database Design

De cursus Data Warehouse Database Design behandelt de volgende onderwerpen:

    • 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

    Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?

Vraag informatie aan

Gedetailleerde onderwerpenlijst cursus Data Warehouse Database Design

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Data Warehouse Database Design behandeld zullen worden:

    • Reviewing Data Warehouse Basics
      • Describing the features and characteristics of a data warehouse
      • Identifying the components and functionality of an Oracle data warehouse environment using the Common Warehouse Model
    • Defining the Business Logical Models
      • Describing the enterprise level strategic analysis tasks
      • Defining components of business modeling
    • Creating the Dimensional Model
      • Describing attributes of a star model
      • Identifying fact tables and their attributes from business measure entities
    • Creating the Physical Model
      • Translating the dimensional model into a physical model
      • Discussing the architectural requirements for the data warehouse
    • Storage Considerations for the Physical Model
      • Explaining data warehouse sizing techniques and test load sampling
      • Describing data warehousing indexing types and strategies
    • Strategies for Extracting, Transforming, and Transporting
      • Outlining the extraction, transformation, and transportation processes for building a data warehouse
      • Identifying extraction, transformation, and transportation issues
    • Summary Management
      • Discussing summary management and Oracle implementation of summaries
      • Describing materialized views
    • Analytical Capabilities
      • Defining Business Intelligence (BI)
      • Understanding the categories of BI and their use within the data warehouse

Getoonde informatie onder voorbehoud, genoemde prijzen zijn exclusief BTW.

Share |

  Bel mij!
  Brochure aanvragen
  Aanmelden voor nieuwsbrief
  Stel een vraag