Course details

Data Warehouse Essential: Architecure Frameworks and Implementation

Data Warehouse Essential: Architecure Frameworks and Implementation


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Examine architectures of data warehouse implementations, including logical and physical design. How to effectively implement and manage data warehousing projects is also covered.



Expected Duration (hours)
1.0

Lesson Objectives

Data Warehouse Essential: Architecure Frameworks and Implementation

  • recall essential architectural components of data warehouse along with the design considerations to successfully implement the right data warehousing solution
  • specify essential data warehouse architectural styles and frameworks, and compare Kimball and Inmon
  • identify the logical and physical data warehousing architectural models, with the emphasis on schema and objects
  • illustrate implementation scenarios of the logical and physical data warehousing models
  • list dimensional modeling principles and the differences between it and the ER model
  • specify how data warehousing can be used to facilitate information realization
  • illustrate the processes of extracting, loading, and transforming data in a data warehousing environment
  • recall data warehousing and ETL tools and specify how they are implemented real-time
  • recognize essential tools, components, features and how they are used to implement ETL
  • demonstrate how to use Talend to implement ETL
  • extract data from various sources, and transform and load the data in the intended destination
  • Course Number:
    it_dfdwes_02_enus

    Expertise Level
    Beginner