Introduction to Data Warehousing and Azure Synapse Analytics

About Introduction to Data Warehousing and Azure Synapse Analytics

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