Providing insight from data should be a fast and efficient process. In this course, Query Data by Using Azure Synapse Analytics – DP-500, you’ll learn to perform exploratory data analysis in Azure Synapse Analytics. First, you’ll discover the key components of the Azure Synapse Analytics platform. Next, you’ll understand how to leverage various file types to explore the data from serverless SQL pools, and how to query the relational data stored in dedicated SQL pool. Finally, you’ll learn how to use a machine learning PREDICT function to take your queries to another level. When you’re finished with this course, you’ll have the foundational understanding of the data exploration process in Azure Synapse Analytics that will enable you to explore and query the data in Azure Synapse Analytics and get you ready for the DP-500 exam.
Author Name: Nikola Ilic
Author Description:
Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI – but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed “Data-Mozart”. As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer’s last name as part of his nickname. That’… more

Table of Contents

• Course Overview
  2mins
• Identifying an Appropriate Azure Synapse Pool When Analyzing Data
  14mins
• Querying Various File Types with Serverless SQL Pool
  20mins
• Querying Relational Data in a Dedicated SQL Pool
  24mins
• Enhancing Queries with PREDICT Function
  6mins