Overview
-
Learn how to get up and running with Azure Synapse to analyze your data and store it in the cloud.
Syllabus
-
Introduction
- Data warehouses in the cloud
- What you should know
- Azure Synapse Analytics overview
- Creating Azure Synapse Analytics workspaces
- Analyzing the architecture of dedicated SQL pools
- Provisioning dedicated Synapse Analytics pools
- Challenge: Create a Synapse Analytics workspace with a dedicated pool
- Solution: Create a Synapse Analytics workspace with a dedicated pool
- Data loading in Azure Data Warehouse
- Preparing your data
- Exploring Azure Synapse Studio
- Loading data using the copy tool
- Load data using the COPY command
- Load data with PolyBase
- Transform data using data flows
- Challenge: Loading data using the copy tool
- Solution: Loading data using the copy tool
- Data streaming scenarios
- Creating a Stream Analytics job
- Testing data streaming using sample data
- Understanding serverless pools
- Querying and discovering data using serverless pools
- Using file metadata in queries
- Building a logical data warehouse, part 1
- Building a logical data warehouse, part 2
- Manage statistics
- Cost management
- Challenge: Query partitioned data
- Solution: Query partitioned data
- Querying, labeling, and tracking data warehouse performance
- Transactions in dedicated SQL pool
- Optimizing queries with materialized views
- Connecting using external clients
- Creating and updating statistics
- Analyzing data distribution
- Next steps with Synapse Analytics
