hands-on lab

Using Azure Synapse Analytics to Query Data Lake

Up to 1h 45m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
Lab description

Azure Synapse Analytics is an integrated analytics platform that gives you the ability to gain insight into the data collected from various sources. It comes with features such as data warehousing, big data analytics, data integration, and visualization.

Data Analytics is one of the fundamental drivers of business decisions. The ability to search through the data and make critical business decisions is super powerful to make a significant impact. The ability to visualize the current analytics and do predictive analytics is possible with the Azure Synapse Spark engine pool. It also supports modern data warehousing, advanced analytics, data exploration, real-time analytics, and data ingestion from multiple sources to provide a seamless integration to connect to your data source.

In this lab, you will learn how to deploy Azure Synapse Analytics and use serverless SQL to execute queries against the data stored in a data lake storage account.

Learning Objectives

Upon completion of this intermediate-level lab, you will be able to:

  • Create and manage Azure Synapse Analytics workspace
  • Work with Data Lake to store data files
  • Interact with Synapse Studio
  • Create queries to analyze data using SQL query
  • Create SQL View using Serverless SQL pool

Intended Audience

  • Candidates for Azure Data Engineer (DP-203)
  • Cloud Architects
  • Data Engineers
  • Database Administrators
  • Anyone with a need to visualize and analyze data in Azure


Familiarity with the following will be beneficial but is not required:

  • Basic knowledge of Azure Storage Services
  • Basic knowledge of Running SQL Queries
  • Basic knowledge of AzCopy command & Azure Cloud Shell

The following courses/courses and labs can be used to fulfill the prerequisite:

Environment before

Environment after

About the author
Learning paths

Parveen is an Azure advocate with previous experience in the professional consulting services industries. He specializes in infrastructure and DevOps with a wide range of knowledge in security and access management. He is also an Azure Certified - DevOps Engineer Expert, Security Engineer, Developer Associate, Administrator Associate, CompTIA Certified - Network+, Security+, and AWS Cloud Practitioner.
Parveen enjoys writing about cloud technologies and sharing the knowledge with the community to help students upskill in the cloud.

Covered topics
Lab steps
Logging in to the Microsoft Azure Portal
Creating Azure Synapse Analytics Workspace
Uploading Sample Data into Data Lake Storage
Exploring Azure Synapse Workspace and Studio
Querying a Data Lake Store using serverless SQL pools in Azure Synapse Analytics
Creating a View for CSV Data with a Serverless SQL Pool