Data Warehouse Essential: Architecture Frameworks & Implementation

Data Warehouse
  • 11 Videos | 1h 6m 27s
  • Includes Assessment
  • Earns a Badge
Likes 118 Likes 118
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

  • Playable
    1. 
    Essential Data Warehouse Architectural Components
    8m 24s
    UP NEXT
  • Playable
    2. 
    Data Warehouse Architectural Styles and Frameworks
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
Likes 14 Likes 14  
Likes 12 Likes 12