Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
21 Hour(s) 20 Minute(s)
Language
English
Taught by
Alan Rodrigues
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Preparation for DP-203 Data Engineering on Microsoft Azure exam
Release v3.0 - May 2024
The entire course has been updated and refreshed. All chapters have been re-recorded. This has been done to ensure that all contents now reflect the most recent changes to the services on the Azure platform.
All course contents have also been aligned as per any changes to the course objectives.
Release v2.0 - May 2023
The entire course has been updated and refreshed. All chapters have been re-recorded. This has been done to ensure that all contents now reflect the most recent changes to the services on the Azure platform.
All course contents have also been aligned as per any changes to the course objectives.
Additional questions have been also added to the Practice Tests.
Release v1.0 Initial Release
This course is designed for students who want to attain the "Microsoft Certified: Azure Data Engineer Associate" certification
This course has contents for the Exam DP-203
The objectives covered in this course are
Design and implement data storage (40-45%)
Design and develop data processing (25-30%)
Design and implement data security (10-15%)
Monitor and optimize data storage and data processing (10-15%)
In this course students will learn about the various Azure services that pertain to Data Engineering. Few of the important aspects that students will learn along the way includes the following
What is the purpose of an Azure Data Lake Gen 2 storage account
Basics on Transact-SQL commands
How to work with Azure Synapse. This will include building a data warehouse into a dedicated SQL Pool.
How to build an ETL pipeline with the help of Azure Data Factory. There will be various scenarios on how to create mapping data flows.
How to stream data with the use of Azure Stream Analytics. You can see how SQL commands can be used for your streaming data.
Basics on the Scala programming language, and SPARK
How to work with SPARK, Scala in Azure Databricks. We will see how to work with Notebooks. We will also see how to stream data into Azure Databricks.
The different security measures and monitoring aspects to consider when working with Azure services
Course Content
- 11 section(s)
- 279 lecture(s)
- Section 1 Introduction
- Section 2 Design and implement data storage - Basics
- Section 3 UPDATED - Design and implement data storage - Overview on Transact-SQL
- Section 4 Design and implement data storage - Azure Synapse Analytics
- Section 5 Design and Develop Data Processing - Azure Data Factory
- Section 6 Design and Develop Data Processing - Azure Event Hubs ,Stream Analytics
- Section 7 Design and Develop Data Processing - A look at Spark
- Section 8 Design and Develop Data Processing - Azure Synapse and Azure Databricks
- Section 9 Design and Implement Data Security
- Section 10 Monitor and optimize data storage and data processing
- Section 11 Practice Section
What You’ll Learn
- Student will learn how to implement & manage data engineering workloads on Microsoft Azure.
- Students will learn the various Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks
- Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks
- Individuals interested in Data Engineering field can pursue DP 203
Skills covered in this course
Reviews
-
LLucie Milotova
very structured, into detail an covers a large techstack
-
NNavneet Kumar Yadav
The training contents format and syllabus is great, the trainer is great as well however the trainer uses "you know" a lot and this confuses most of the time by understanding the whole sentence. So I have to go to transcript to understand it.
-
PParag
Well designed, effective content selection and presentation.
-
RRamya R
I can understand the topics but somewhere, I feel the continuity is missing. Overall, it is one of the best courses available to learn in depth
