Introduction to Data Warehousing and Azure Synapse Analytics
Learn about Data Warehousing, Azure Synapse Analytics, Azure Synapse Analytics Studio, HTAP and Azure Synapse Link
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