Microsoft Azure Synapse for Developers
Offered By: LinkedIn Learning
Course Description
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
Taught by
Nertil Poci
Related Courses
ETL and ELT BasicsA Cloud Guru Programming Use Cases with Python
A Cloud Guru Microsoft Power BI: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn Amazon Connect Data Streaming Intermediate
Amazon Web Services via AWS Skill Builder Analisar e preparar dados com o Amazon SageMaker Data Wrangler e o Amazon EMR (Português (Brasil)) | Lab - Analyze and Prepare Data with Amazon SageMaker Data Wrangler and Amazon EMR (Portuguese (Brazil))
Amazon Web Services via AWS Skill Builder