Udemy

Azure Synapse Analytics For Data Engineers -Hands On Project

Enroll Now
  • 29,532 Students
  • Updated 7/2025
  • Certificate Available
4.6
(3,927 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
13 Hour(s) 28 Minute(s)
Language
English
Taught by
Ramesh Retnasamy . 200,000+ Learners
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.6
(3,927 Ratings)

Course Overview

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]

Welcome!

I am looking forward to helping you with learning one of the in-demand data engineering tools in the cloud, Azure Synapse Analytics! This course has been taught with implementing a data engineering solution using Azure Synapse Analytics for a real world project of analysing and reporting on NYC Taxi trips data.

This is like no other course in Udemy for Azure Synapse Analytics. Once you have completed the course including all the assignments, I strongly believe that you will be in a position to start a real world data engineering project on your own and also proficient on Azure Synapse Analytics.  The primary focus of the course is Azure Synapse Analytics, but it also covers the relevant concepts and connectivity to the other technologies mentioned.

The course follows a logical progression of a real world project implementation with technical concepts being explained and the scripts and notebooks being built at the same time. Even though this course is not specifically designed to teach you the skills required for passing the exams Azure Data Engineer Associate Certification [DP-203] or Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI [DP-500], it can greatly help you get most of the necessary skills required for the exams.

I value your time as much as I do mine. So, I have designed this course to be fast-paced and to the point. Also, the course has been taught with simple English and no jargons. I start the course from basics and by the end of the course you will be proficient in the technologies used.

Currently the course teaches you the following

  • Azure Synapse Analytics Architecture

  • Serverless SQL Pool

  • Spark Pool

  • Dedicated SQL Pool

  • Synapse Pipelines

  • Synapse Link for Cosmos DB / Hybrid Transactional and Analytical Processing (HTAP) capability

  • Power BI Integration with Azure Synapse Analytics

  • Azure Data Lake Storage Gen2 integration with Azure Synapse Analytics

  • Project using NYC Taxi Trips data using the above technologies

Please note that the following are not currently covered

  • Data Flows

  • Advanced concepts around Dedicated SQL Pool

  • Spark Programming

  • SQL Fundamentals

Course Content

  • 19 section(s)
  • 132 lecture(s)
  • Section 1 Introduction
  • Section 2 Azure Subscription (Optional)
  • Section 3 Azure Synapse Analytics Overview
  • Section 4 NYC Taxi Project Overview
  • Section 5 Serverless SQL Pool - Overview
  • Section 6 Serverless SQL Pool - Query CSV
  • Section 7 Serverless SQL Pool - Query JSON
  • Section 8 Serverless SQL Pool - Query Folders & Multiple Files
  • Section 9 Serverless SQL Pool - Query Columnar Formats
  • Section 10 Serverless SQL Pool - Data Discovery
  • Section 11 Serverless SQL Pool - Data Virtualisation
  • Section 12 Serverless SQL Pool - Data Ingestion
  • Section 13 Serverless SQL Pool - Data Transformation
  • Section 14 Synapse Pipelines & Triggers
  • Section 15 Spark Pool
  • Section 16 Power BI Integration
  • Section 17 Synapse Link/ HTAP
  • Section 18 Dedicated SQL Pool
  • Section 19 Next Steps

What You’ll 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


Reviews

  • s
    sukumar pallapu
    5.0

    it was good to have this training

  • S
    Sai Kiran
    5.0

    Excellent course which helps in getting detailed understanding of most of the components in Azure Synapse Analytics. The hands on exercises will help in understanding the real time scenarios. The way the project is built from scratch into an enterprise level data warehouse is definitely a commendable effort.

  • N
    Nethi Vinay
    4.5

    course is good for beginners, it provides basic understanding of azure synapse analytics

  • R
    Rajasekar Asaithambi
    5.0

    Good course

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed