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.68 (2806 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

Why take this course?

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

Reviews

Ali

July 11, 2023

The course gives a good insight into serverless sql pool offering by Synapse. The instructor has demonstrated the concepts very well. I hope we can have more videos added for dedicated sql pool in the future

Simon

July 10, 2023

It is an awesome course. Very detailed, clear and very well explained. My congratulations to the instructor!

Robin

July 4, 2023

Good learning covered most of concepts in Serverless SQL pool it would have been best if the SQL dedicated pool covered in more depth

Eduardo

June 29, 2023

Cuenta todo desde las bases y fundamentos a buen ritmo y muy facil de entender , lo recomiendo sobre todo si ya has visto un poquito, poquito de synapse para ir siguiéndole el ritmo bien

Muhammad

June 28, 2023

This is one of the most detailed courses I ever took. Hats to the instructor for such an amazing job. Well done sir!

Samantha

June 26, 2023

I think the trainer is very engaging and the course is laid out in a very systematic way. The only reason I didn't give 5 stars is because there are a lot of new terms introduced and not sufficient information about those terms. For instance, a container, an data lake account, what the difference is between a notebook and a sql script. etc.

Gheorghe

June 15, 2023

A nice course with good explanations. Being new to Azure and Synapse it was really good to get familliar with some concepts and get an overview about the services and how they interact and are related

June 13, 2023

Hi Ramesh, The course was good, it would have been more better if u have added CI/CD along with increasing chapters under Dedicated SQL Pool and by adding Data Warehouse Concepts.

William

June 5, 2023

Very good course with hands-on lab to get a good overview of Azure Synapse Studio. I got a lot out of it.

Richard

May 21, 2023

Excellent course. The presenter is expert in the subject matter and also presents it very well. The course is well structured and interesting.

Andrii

May 10, 2023

The course materials are well organized. Each lesson has a detailed explanation with code examples - it's quite useful. In overall, this course covers all main parts of Azure Synapse Analytics.

Fotios

May 5, 2023

Great course, concrete explanations and easy to follow. Probably the best on synapse. If it included devops approach of the project would been 5 stars.

Viral

April 17, 2023

Thank you Ramesh for Azure Synapse Analytics course. It helped me gaining skills related to openrowset function for all file formats, different file formats overview, querying from multiple folders and different data transformation techniques.

Vincent

April 9, 2023

Very good learning process, in my case as a really beginner it is perfect. Tools are all introduced with sense and business approach. I am at 3hours, project is starting and i am glad to spend some times doing this course Thanks for your job

Penchala

April 7, 2023

Most of courses show how to create and manipulate objects and data by UI, Ramesh shows coding or T-SQL commands with ease and easy to understand. I would recommend this course to any one.

Charts

Price

Rating

Enrollment distribution

Azure Synapse Analytics For Data Engineers -Hands On Project - Distribution chart