-
Get up and running with Azure Synapse (formerly known as Azure SQL Data Warehouse), a powerful analytics service that blends big data analytics with data warehousing.
Data powers decision-making. And to effectively leverage data to support business insights, companies must be able to query data and run analytics at a large scale. Azure Synapse, formerly known as Azure SQL Data Warehouse, can help. This powerful analytics service blends big data analytics with data warehousing, offering organizations a way to store large amounts of incoming data for a reasonable cost. In this course, instructor Nertil Poci helps developers get up and running with Azure Synapse and build their first data warehouse. Nertil goes over the benefits that Azure Synapse offers, as well as how to provision a data warehouse, load and query data, and leverage best practices to minimize costs and optimize your data warehouse. Along the way, he shares challenges that allow you to practice your new skills.
Overview
Syllabus
-
Introduction
- Create your data warehouse
- What you should know
- Cloud data warehouses
- Azure SQL Data Warehouse overview
- Provision Azure SQL Data Warehouse instances
- Challenge: Provision SQL Data Warehouse
- Solution: Provision SQL Data Warehouse
- Data loading in Azure SQL Data Warehouse
- Loading methods in data warehousing
- Load data with PolyBase
- Load data using the COPY command
- Load data with Azure Data Factory
- Load data using an SSIS package
- Challenge: Evaluate data load methods
- Solution: Evaluate data load methods
- Querying, labeling, and tracking data warehouse performance
- Query concurrency and concurrency slots
- Monitoring concurrency for queries in real time
- Transactions in Azure SQL Data Warehouse
- Scaling and performance
- Challenge: Track and monitor queries
- Solution: Track and scale to match workload
- Transactions and transaction sizes
- Azure SQL Data Warehouse maintenance operations
- Azure SQL Data Warehouse distribution methods and keys
- Minimizing Azure SQL Data Warehouse costs
- Challenge: Determine the correct distribution method
- Solution: Determine the correct distribution method
- Next steps with data warehouses
