Data Warehouse Essential: Architecture Frameworks & Implementation

Data Warehouse    |    Beginner
  • 11 videos | 1h 1m 27s
  • Includes Assessment
  • Earns a Badge
Likes 241 Likes 241
Examine architectures of data warehouse implementations, including logical and physical design. How to effectively implement and manage data warehousing projects is also covered.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 8m 24s
  • 7m 42s
  • Locked
    3.  Logical and Physical Data Warehouse Designs
    4m 27s
  • Locked
    4.  Use Cases of Logical and Physical Modeling
    2m 46s
  • Locked
    5.  Principles of Dimensional Modeling
    6m 23s
  • Locked
    6.  Information Realization
    5m 7s
  • Locked
    7.  ETL in Data Warehouse
    5m 6s
  • Locked
    8.  Popular Data Warehouse and ETL Tools
    7m 28s
  • Locked
    9.  Exploring Talend
    4m 48s
  • Locked
    10.  Talend ETL Implementation
    5m 34s
  • Locked
    11.  Exercise: Transform Multi-data with Talend
    3m 43s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Modern Data Warehouses
Likes 27 Likes 27  
Channel Data Warehousing
Likes 86 Likes 86  
Course Software Design and Development: Methodologies

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SSIS Packages
Likes 54 Likes 54  
Course Data Warehousing with Azure: Architecture & Modeling Techniques
Likes 36 Likes 36  
Book Emerging Perspectives in Big Data Warehousing