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

0. Introduction

01 - Data warehouses in the cloud
02 - What you should know

1. Getting Started with Azure Synapse Analytics

03 - Azure Synapse Analytics overview
04 - Creating Azure Synapse Analytics workspaces
05 - Analyzing the architecture of dedicated SQL pools
06 - Provisioning dedicated Synapse Analytics pools
07 - Challenge - Create a Synapse Analytics workspace with a dedicated pool
08 - Solution - Create a Synapse Analytics workspace with a dedicated pool

2. Populating Dedicated Synapse Analytics Pools

09 - Data loading in Azure Data Warehouse
10 - Preparing your data
11 - Exploring Azure Synapse Studio
12 - Loading data using the copy tool
13 - Load data using the COPY command
14 - Load data with PolyBase
15 - Transform data using data flows
16 - Challenge - Loading data using the copy tool
17 - Solution - Loading data using the copy tool

3. Streaming Data into Azure Synapse Analytics

18 - Data streaming scenarios
19 - Creating a Stream Analytics job
20 - Testing data streaming using sample data

4. Querying Using Serverless SQL

21 - Understanding serverless pools
22 - Querying and discovering data using serverless pools
23 - Using file metadata in queries
24 - Building a logical data warehouse, part 1
25 - Building a logical data warehouse, part 2
26 - Manage statistics
27 - Cost management
28 - Challenge - Query partitioned data
29 - Solution - Query partitioned data

5. Querying and Best Practices in Dedicated SQL Pools

30 - Querying, labeling, and tracking data warehouse performance
31 - Transactions in dedicated SQL pool
32 - Optimizing queries with materialized views
33 - Connecting using external clients
34 - Creating and updating statistics
35 - Analyzing data distribution

Conclusion

36 - Next steps with Synapse Analytics