Using Azure Synapse Analytics to Query Data Lake

Lab Steps

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

The hands-on lab is part of this learning path

Ready for the real environment experience?

DifficultyIntermediate
Time Limit1h 45m
Students677
Ratings
5/5
starstarstarstarstar

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

Prerequisites

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
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students5994
Labs56
Courses1
Learning paths2

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.