Introduction to Data Warehousing and Azure Synapse Analytics

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

TAKE THIS COURSE