Build data analytics solutions using Azure Synapse serverless SQL pools

Intermediate
Data Engineer
Synapse Analytics

Learn how to query and prepare data in an interactive way on files placed in Azure Storage.

Prerequisites

  • It is recommended that students have completed Data Fundamentals before starting this learning path.

Modules in this learning path

Explore the capabilities of Azure Synapse serverless SQL pools and how it can be used to interactively work with data in a data lake.

Learn how you can query the different file types that can be stored in a data lake.

Learn how you can create objects to help you query data or optimize your existing data transformation pipeline through Azure Synapse serverless SQL pools.

Learn how to use CREATE EXTERNAL TABLE AS SELECT statements to transform data and encapsulate the transformation logic in stored procedures.

Learn how to serve and make use of the data that is queried or transformed by Azure Synapse serverless SQL pool.

Learn how you can set up security when using Azure Synapse serverless SQL pools