Data Warehousing with Azure: Architecture & Modeling Techniques

Azure 2018    |    Intermediate
  • 15 Videos | 1h 24m 26s
  • Includes Assessment
  • Earns a Badge
Likes 28 Likes 28
Explore the fundamentals of data warehousing and the essential architectures and components being implemented to manage data.

WHAT YOU WILL LEARN

  • identify the essential characteristics of data warehouse and compare data warehouse with operational databases
    list the various possible data warehousing architectures that can be implemented
    recall the various essential data warehousing alternatives that are available today apart from Azure
    depict the evolution of data warehouse and illustrate the first generation and second generation data warehouse
    illustrate the various types of data warehouse that are being implemented by various businesses
    list the critical features of the federated data warehouse, compare federated data warehouse with the centralized approach, and list advantages and disadvantages of this approach and implementation scenarios
    identify the critical advantages and disadvantages associated with the star schema and data mart approaches of implementing data warehouse
    define the essential lifecycle phases of data warehousing implementation and data movement
  • illustrate the essential concepts of metadata, types of metadata, and its roles in data warehouse implementation
    compare the essential approaches of processing, integrating, and managing structured and unstructured data
    compare the essential approaches of processing, integrating, and managing structured and unstructured data with real time examples
    specify the critical analytical and reporting mechanisms that are implemented in data warehouse
    define the benefits of implementing cloud data warehouse and compare cloud data warehouse with on-prem implementation
    describe the benefits and how to implement Hybrid architectures using on-premise capabilities
    define the critical features, characteristics, and advantages of implementing Federated and Hybrid data warehouse

IN THIS COURSE

  • Playable
    1. 
    Data Warehouse Features
    5m 23s
    UP NEXT
  • Playable
    2. 
    Data Warehouse Architectures
    5m 53s
  • Locked
    3. 
    Data Warehouse Alternatives
    4m 25s
  • Locked
    4. 
    Data Warehouse Generation
    5m 27s
  • Locked
    5. 
    Variations of Data Warehouse
    9m 21s
  • Locked
    6. 
    Federated Data Warehouse Features
    4m 18s
  • Locked
    7. 
    Star Schema and Data Mart Approach
    6m 9s
  • Locked
    8. 
    Data Warehouse Lifecycle Phases
    3m 41s
  • Locked
    9. 
    Metadata Concepts in Data Warehouse
    3m 55s
  • Locked
    10. 
    Structured and Unstructured Data
    6m 39s
  • Locked
    11. 
    Structured and Unstructured Data - Examples
    2m 30s
  • Locked
    12. 
    Analytics and Reporting Approach
    5m 33s
  • Locked
    13. 
    Cloud Data Warehouse
    4m 45s
  • Locked
    14. 
    Hybrid Data Warehouse Architecture
    4m 25s
  • Locked
    15. 
    Exercise: Implementing Data Warehouse Features
    5m 4s

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.

YOU MIGHT ALSO LIKE

Likes 38 Likes 38