Microsoft Azure Synapse for Developers
2h 36mIntermediate2021-09-10
Authors

Nertil Poci
Freelance Software Architect
Course details
In today’s world, businesses are relying more and more on big data for their daily operations. This is a trend that is not likely to reverse. Azure Synapse is a great tool to handle all that data, as it 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, Nertil Poci shows you how to get up and running with Azure Synapse Analytics as your data warehouse in the cloud. He explains how to load, process and query data, and covers the benefits of Synapse Analytics, creating workspaces, processing data from storage, and loading data into dedicated SQL pools using different data loading tools and querying data. Along the way, he shares challenges that allow you to practice your new skills. If you’re ready to start building your data warehouse in the cloud, join Nertil in this course.
Skills covered
SQLCloud DevelopmentData EngineeringAzureSoftware Development ToolsPersonaNetwork AdministrationCloud PlatformsNetwork and System AdministrationCloud ComputingData ScienceOpen SourceMicrosoftSoftware Development
Concepts
Introduction
- Data warehouses in the cloud
- What you should know
Getting Started with Azure Synapse Analytics
- 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
Populating Dedicated Synapse Analytics Pools
- 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
Streaming Data into Azure Synapse Analytics
- Data streaming scenarios
- Creating a Stream Analytics job
- Testing data streaming using sample data
Querying Using Serverless SQL
- 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 and Best Practices in Dedicated SQL Pools
- 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
Conclusion
- Next steps with Synapse Analytics