Data Warehousing with Azure: Architecture & Modeling Techniques

Azure    |    Intermediate
  • 15 videos | 1h 17m 26s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 11 users Rating 4.5 of 11 users (11)
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

  • 5m 23s
    Find out how to identify the essential characteristics of data warehouses and compare data warehouses with operational databases. FREE ACCESS
  • 5m 53s
    After completing this video, you will be able to list the various possible data warehousing architectures that can be implemented. FREE ACCESS
  • Locked
    3.  Data Warehouse Alternatives
    4m 25s
    Upon completion of this video, you will be able to recall the various essential data warehousing alternatives that are available today in addition to Azure. FREE ACCESS
  • Locked
    4.  Data Warehouse Generation
    5m 27s
    During this video, you will learn how to depict the evolution of data warehouses and illustrate the first generation and second generation data warehouses. FREE ACCESS
  • Locked
    5.  Variations of Data Warehouse
    9m 21s
    Upon completion of this video, you will be able to illustrate the various types of data warehouses that are being implemented by various businesses. FREE ACCESS
  • Locked
    6.  Federated Data Warehouse Features
    4m 18s
    After completing this video, you will be able to list the critical features of the federated data warehouse, compare the federated data warehouse with the centralized approach, list the advantages and disadvantages of this approach, and list implementation scenarios. FREE ACCESS
  • Locked
    7.  Star Schema and Data Mart Approach
    6m 9s
    In this video, you will learn how to identify the critical advantages and disadvantages associated with the star schema and data mart approaches to implementing a data warehouse. FREE ACCESS
  • Locked
    8.  Data Warehouse Lifecycle Phases
    3m 41s
    Learn how to define the essential lifecycle phases of data warehousing implementation and data movement. FREE ACCESS
  • Locked
    9.  Metadata Concepts in Data Warehouse
    3m 55s
    Upon completion of this video, you will be able to illustrate the essential concepts of metadata, types of metadata, and its roles in data warehouse implementation. FREE ACCESS
  • Locked
    10.  Structured and Unstructured Data
    6m 39s
    In this video, you will learn how to compare the essential approaches of processing, integrating, and managing structured and unstructured data. FREE ACCESS
  • Locked
    11.  Structured and Unstructured Data - Examples
    2m 30s
    In this video, learn how to compare the essential approaches of processing, integrating, and managing structured and unstructured data with real-time examples. FREE ACCESS
  • Locked
    12.  Analytics and Reporting Approach
    5m 33s
    Upon completion of this video, you will be able to specify the critical analytical and reporting mechanisms implemented in data warehouses. FREE ACCESS
  • Locked
    13.  Cloud Data Warehouse
    4m 45s
    In this video, learn how to define the benefits of implementing a cloud data warehouse and compare a cloud data warehouse with an on-prem implementation. FREE ACCESS
  • Locked
    14.  Hybrid Data Warehouse Architecture
    4m 25s
    After completing this video, you will be able to describe the benefits and how to implement Hybrid architectures using on-premises capabilities. FREE ACCESS
  • Locked
    15.  Exercise: Implementing Data Warehouse Features
    5m 4s
    In this video, learn how to define the critical features, characteristics, and advantages of implementing a Federated and Hybrid data warehouse. FREE ACCESS

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 Microsoft Azure Fundamentals: Azure Cloud Computing
Rating 4.6 of 1713 users Rating 4.6 of 1713 users (1713)
Course Microsoft Azure Fundamentals: Management Tools
Rating 4.6 of 645 users Rating 4.6 of 645 users (645)
Channel Azure Architecture
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing & Implementing Dimensions
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Course Data Warehousing with Azure: Implementing Azure SQL Data Warehouse
Rating 4.4 of 8 users Rating 4.4 of 8 users (8)
Course Microsoft Azure Architect Design: Azure Storage Design
Rating 4.3 of 24 users Rating 4.3 of 24 users (24)