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

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

Rating: 3.8

Level: Beginner Level

Duration: 3.5 hours

Instructor: Hassan Janjua

Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.