Hands on Project for Data Engineers using all the services available in Azure Synapse Analytics [DP-203, DP-500]
Instructed by Ramesh Retnasamy 13.5 hours on-demand video, 3 articles & 5 downloadable resources
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
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
Who this course is for:
- University students looking for a career in Data Engineering
- IT developers working on other disciplines trying to move to Data Engineering
- Data Engineers/ Data Warehouse Developers currently working on on-premises technologies, or other cloud platforms such as AWS or GCP who want to learn Azure Data Technologies
- Data Architects looking to gain an understanding about Azure Data Engineering stack
Recommended Courses
Deal Score0
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.