Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Query Data by Using Azure Synapse Analytics - DP-500

via Pluralsight

Overview

Providing insight from data should be a quick and straightforward process. This course will teach you how to write efficient queries against the data stored in Azure Synapse Analytics pools.

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.

Syllabus

  • 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

Taught by

Nikola Ilic

Reviews

4.6 rating at Pluralsight based on 11 ratings

Start your review of Query Data by Using Azure Synapse Analytics - DP-500

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.