DP-203 Exam Preparation: Data Engineering on Microsoft Azure

OverviewStepsAuthor
DifficultyIntermediate
AVG Duration17h
Students815
Ratings
4.6/5
starstarstarstarstar-half
Content
131116

Description

******** PREVIEW *******

This learning path is still in development and requires additional content to cover all of the points assessed in the exam. We are busy working on new content to fill the gaps. Until then, the courses and labs currently available in this Learning Path will allow you to get started in preparing for this certification.

***************************

This learning path is designed to help you prepare for Microsoft's DP-203 Data Engineering on Microsoft Azure exam. Even if you don't plan to take the exam, these courses and hands-on labs will help you learn how to deploy and manage a variety of Azure data solutions.

Candidates who pass the DP-203 exam will earn the Microsoft Certified: Azure Data Engineer Associate certification.

The DP-203 exam tests your knowledge of four subject areas: designing and implementing data storage, designing and developing data processing, designing and implementing data security, and monitoring and optimizing data storage and data processing.

Learning Objectives

  • Design and implement data storage on Azure
  • Design and develop data processing on Azure
  • Design and implement data security on Azure
  • Monitor and optimize data storage and data processing on Azure

Intended Audience

  • People who want to become Azure data engineers
  • People preparing for Microsoft’s DP-203 exam

Prerequisites

  • Basic experience using Microsoft Azure

Certificate

Your certificate for this learning path
lock

Training Content

1
Course - Beginner - 50m
FREE
Overview of Azure Services
This course gives an overview of the services available on Azure and shows how to create virtual machines and web apps using the Azure CLI and Azure Portal.
2
Course - Beginner - 45m
Designing an Azure Data Implementation
In this course, you will learn how to design a data implementation using the appropriate Azure services.
3
Course - Intermediate - 28m
Introduction to Azure Synapse Analytics
This course introduces Microsoft’s Azure Synapse Analytics, covering serverless SQL pools, dedicated SQL pools, Spark pools, and Synapse Pipelines.
4
Course - Intermediate - 18m
Optimizing Dedicated SQL Pools in Azure Synapse Analytics
This course explains how to optimize dedicated SQL pools in Azure Synapse Analytics and provides a quick overview of the security and disaster recovery features of dedicated SQL pools.
5
Course - Intermediate - 42m
Running Spark on Azure Databricks
In this course, we will show you how to set up a Databricks cluster and run interactive queries and Spark jobs on it.
6
Course - Advanced - 39m
Using Azure Data Lake Storage Gen2
In this course, you will follow hands-on examples to import data into Azure Data Lake Storage Gen2 and then securely access it and analyze it using Azure Databricks. You will also learn how to monitor and optimize your Azure Data Lake Storage Gen2.
7
Hands-on Lab - Beginner - 1h
Using Azure Databricks to Import and Analyze Data
Learn to implement lightning-fast analytics by building an Azure Databricks workspace and cluster to interact with Azure Data Lake Store data.
8
Course - Intermediate - 13m
Introduction to Delta Lake on Azure Databricks
This course provides an introduction to Delta Lake in Azure Databricks and shows you how to use it.
9
Course - Beginner - 1h 10m
Designing Data Flows in Azure
In this course, you'll learn the basic principles of designing data flows using the Azure platform.
10
Hands-on Lab - Intermediate - 1h 15m
Using Azure Data Factory Pipelines to Copy Data
Learn how to build and trigger data pipelines in Azure Data Factory in this lab.
11
Hands-on Lab - Intermediate - 1h
Monitor Azure Data Factory using Azure Monitor
In this hands-on lab, you'll learn how to Monitor Azure Data Factory and set up alerts using Azure Monitor
12
Course - Advanced - 30m
Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines
In this course, we’ll explain the concept of slowly changing dimensions and the different approaches to dealing with them.
13
Course - Intermediate - 31m
Managing Azure Blob Storage
The course begins with a brief review of Azure Storage Accounts and then drills down into the details of blobs storage services, highlighting the different kinds of blobs.
14
Course - Intermediate - 50m
Introduction to Azure Stream Analytics
This course includes hands-on examples of how to configure inputs, outputs, and queries in ASA jobs, including ingesting data from Event Hubs and writing results to Data Lake Store.
15
Hands-on Lab - Beginner - 30m
Analyzing IoT Data Using Azure Stream Analytics
Analyze Internet of Things (IoT) sensor data using Azure Stream Analytics to identify if there have been any IoT device failures in this Lab.
16
Course - Intermediate - 55m
Analyzing Resource Utilization on Azure
This course looks into how to capture log data and metrics from Azure services and feed this information into different locations for processing.
17
Hands-on Lab - Beginner - 1h 30m
Monitoring Resources with Azure Monitor
Learn to leverage Azure Monitor to diagnose application and infrastructure with logs, query logs with Azure log queries, and leverage alerts and action groups
18
Course - Intermediate - 50m
FREE
Microsoft Azure Security Solutions
This course provides you with a basic understanding of all of the key security options and features available in Microsoft Azure.
19
Hands-on Lab - Advanced - 1h
Azure Defender for Azure SQL Database
Demonstrate the three capabilities of Azure Defender (AD): data discovery & classification, vulnerability assessment, and advanced threat protection to see how AD provides security as a service for your Azure SQL Databases.
20
Resource - Beginner - 3h
Required Reading for Microsoft DP-203 Exam
21
Hands-on Lab Challenge - Intermediate - 1h
Azure Data Factory Pipeline Challenge
Put your Azure Data Factory Skills to the test in this lab challenge centering around Azure Data Factory Pipelines.
22
Exam - 2h 30m
Cert Prep: Data Engineering on Microsoft Azure (DP-203)
Cert Prep: Data Engineering on Microsoft Azure (DP-203)
About the Author
Students106973
Courses66
Learning paths86

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).