Azure Synapse Analytics For Data Engineers -Hands On Project

Hands on Project for Data Engineers using all the services available in Azure Synapse Analytics [DP-203, DP-500]

4.56 (3691 reviews)

Udemy

platform

English

language

Data Science

What you will learn

You will learn how to build a real world project using Azure Synapse Analytics. This course has been taught using real world data from NYC Taxi Trips data

You will acquire professional level data engineering skills in Azure Synapse Analytics

You will learn how to create SQL scripts and Spark notebooks in Azure Synapse Analytics

You will learn how to create dedicated SQL pools and spark pools in Azure Synapse Analytics

You will learn how to enable synapse link and enable analytic store in Cosmos DB

You will learn how to ingest and transform data Serverless SQL Pool and Spark Pool

You will learn how to load data into dedicated SQL Pool

You will learn how to serve data to Power BI from Serverless SQL Pool and Dedicated SQL Pool

You will learn how to execute scripts and notebooks using Synapse Pipelines and Triggers

You will learn how to do operational reporting from the data stored in Cosmos DB using Azure Synapse Analytics

You will learn how to build reports in Power BI for the data stored in Azure Synapse Analytics

Loading charts...

Comidoc Review

Our Verdict

This Azure Synapse Analytics course caters to both beginners and intermediates with its hands-on project and real-world data. While there may be room for minor improvements addressing glitches in provided queries and specific tool explanations, the instructor's expertise and detailed walkthrough of various services provide a solid foundation in Azure Synapse Analytics skills. This highly-rated course is particularly recommended for those keen on learning or expanding their knowledge within Azure Synapse Analytics.

What We Liked

Comprehensive coverage of Azure Synapse Analytics services including Serverless SQL Pool, Spark Pool, Synapse Pipelines, Triggers, and Cosmos DB
Hands-on project using real-world data from NYC Taxi Trips data offering practical insights into data engineering skills in Azure Synapse Analytics
Detailed explanations of creating SQL scripts, Spark notebooks, dedicated SQL pools and spark pools
Instructor's deep understanding of the subject matter and ability to explain concepts lucidly with a focus on solution architecture

Potential Drawbacks

Missing a detailed section on Dedicated SQL Pool which will be covered in a separate course, as per instructor's announcement
Few queries provided during lessons had issues leading to difficulty catching up in the latter part of the course
Minor discrepancies between Azure Portal and course content might require adjustments while following along
Some learners requested more in-depth explanations for select intermediate tools such as containers, data lake accounts, notebooks, and SQL scripts