Introduction to Data Warehousing and Azure Synapse Analytics

Name: Introduction to Data Warehousing and Azure Synapse Analytics
Rating: 4.2 (44 reviews)

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

Last updated 9/2020

English

What you'll learn

5 sections • 25 lectures • 3h 38m total length

Introduction, Key Features & Benefits, and Use Cases of Azure Synapse17:16
Azure Synapse Demo Structure1:15
Azure Synapse Analytics Workspace Demo15:38
Introduction to Synapse Analytics Studio1:42
Explore Azure Synapse Analytics Studio, a web-based environment for data scientists, analysts, and engineers to manage code, monitor artifacts, and review hubs: overview, data develop, orchestrate, and monitor and manage.
Creating Azure Synapse Analytics Workspace7:49
Create an Azure Synapse Analytics workspace, configure a resource group, storage account, security and networking settings, then deploy and access the workspace via the URL.
Overview Hub Introduction1:53
Overview Hub Demo11:40
Ingest a public dataset from an S3 bucket into Azure Data Lake Storage, using a linked service and a pipeline.
Data Hub Introduction3:41
Data Hub Demo25:40
Develop Hub Introduction13:23
Develop Hub Demo32:30

Introduction to Azure Synapse SQL Architecture2:22
Explore how Azure Synapse SQL architecture uses a scale-out, decoupled compute and storage model to distribute processing across nodes, and compare SQL pool with SQL on-demand serverless architectures.
Azure Synapse SQL Architecture (SQL Pool) and Data Warehouse Units5:21
Azure Synapse SQL-Pool Architecture - Core Components Details21:56
Explore the core components of Azure Synapse SQL-Pool architecture, including control node, AMP Engine, compute nodes, storage, data movement, and distribution types such as hash, round-robin, and replicated tables.

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