Introduction to Data Warehousing and Azure Synapse Analytics

Learn about Data Warehousing, Azure Synapse Analytics, Azure Synapse Analytics Studio, HTAP and Azure Synapse Link

Ratings: 3.90 / 5.00




Description

In this course, you will learn

  • What is data warehousing?

    • A basic introduction to data warehousing

  • History and evolution of data warehousing

    • History of data warehousing from the 1970s to date

  • Limitation of traditional data warehouse

    • What is the limitation of the traditional data warehouse?

  • Modernization of data warehouse

    • How modern technological advances helped to define the modern data warehouses

  • Terminologies and Concepts – Part I

    • What is OLTP and OLAP?

    • What is ETL and ELT?

    • What is Micro-Batch and Change Data Capture (CDC)?

    • What is Star and Snowflakes Schema?

  • Introduction to Azure Synapse

    • Introduction to Azure Synapse

    • Key features and benefits of Azure Synapse

    • Azure Synapse Analytics (Putting in altogether)

    • Structure of Azure Synapse Demo

    • A demo of Azure Synapse

    • Use cases of Azure Synapse

  • Introduction to Synapse Analytics Studio

    • What are the activity hubs of Synapse Studio?

  • Introduction to Overview Hub

    • Demo of Overview Hub

  • Introduction to Data Hub

    • Demo of Data Hub

  • Introduction to Develop Hub

    • Demo of Develop Hub

  • Introduction to Orchestrate Hub

    • Demo of Orchestrate Hub

  • Introduction to Manage Hub

    • Demo of Manage Hub

  • Introduction to Monitoring Hub

    • Demo of Monitoring Hub

  • Azure Synapse – SQL Analytics

    • Introduction to Azure Synapse SQL Architecture

    • Azure Synapse SQL Architecture (SQL Pool) and Data Warehouse Units

  • What is HTAP (Hybrid transactional/analytical processing)?

  • Azure Synapse Link


What You Will Learn!

  • Students will learn about Data Warehousing and Azure Synapse Analytics
  • Data Warehouse Basics
  • Azure Synapse Basics
  • Introduction to Azure Synapse Analytics
  • Design Pattern Azure Synapse Analytics

Who Should Attend!

  • Beginner to Azure Services and Architecture