DP-203 Exam Preparation: Data Engineering on Microsoft Azure

Overview Steps Author

Start Learning Path

DifficultyIntermediate

AVG Duration15h

Students4052

Ratings

4.7/5

Content

151117

Description

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

Training Content

1

Course - Beginner - 5m

DP-203 Exam Prep - Introduction

This course introduces the DP-203 Exam Preparation: Data Engineering on Microsoft Azure learning path, which explores the main subject areas covered in Microsoft's DP-203 exam.

2

Course - Beginner - 51m

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.

3

Course - Intermediate - 45m

Designing an Azure Data Implementation

In this Course, you will learn how to design a data implementation using the appropriate Azure services.

4

Course - Intermediate - 28m

FREE

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.

5

Hands-on Lab - Intermediate - 1h 45m

Using Azure Synapse Analytics to Query Data Lake

Learn how to deploy and use Azure Synapse Analytics to query data stored in a data lake through T-SQL statements using a serverless SQL pool in this hands-on lab.

Go to hands-on lab

6

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.

7

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.

8

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.

9

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.

Go to hands-on lab

10

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.

11

Course - Intermediate - 1h 5m

Designing Data Flows in Azure

In this Course, we're going to review the features, concepts, and requirements that are necessary for designing data flows and how to implement them in Microsoft Azure.

12

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.

Go to hands-on lab

13

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

Go to hands-on lab

14

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.

15

Course - Intermediate - 10m

Configuring Azure Blob Storage Lifecycle Management

In this course, I’ll explain how you can save money by setting up lifecycle management policies that automatically move your blobs to less expensive access tiers when certain conditions are met.

16

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.

17

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.

Go to hands-on lab

18

Course - Intermediate - 27m

Configuring Azure Monitor Metrics, Logs, and Alerts

In this course, we'll take an overview of Azure Monitor metrics and logs and show you how to install virtual machine agents and create alerts.

19

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

Go to hands-on lab

20

Course - Beginner - 14m

Introduction to Azure Networking

In this course, I’ll give an overview of Azure Virtual Networks, virtual subnets, VNet peering, Azure DNS, Azure VPN Gateway, Azure ExpressRoute, and private endpoints.

21

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.

22

Hands-on Lab - Advanced - 1h

Enabling Microsoft 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.

Go to hands-on lab

23

Resource - Not defined - 1h 35m

Required Reading for Microsoft DP-203 Exam

24

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.

Go to hands-on lab challenge

25

Exam - 2h 30m

Cert Prep: Data Engineering on Microsoft Azure (DP-203)

Cert Prep: Data Engineering on Microsoft Azure (DP-203)

About the Author

instructor-image

Guy Hummel

Azure and Google Cloud Content Lead

Students191375

Courses98

Learning paths169

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).

Covered Topics

Big Data Machine Learning SQL Storage Databases Analytics Artificial Intelligence Microsoft Azure Databases for Azure Storage for Azure Analytics for Azure Artificial Intelligence for Azure Azure Stream Analytics Azure Data Factory Azure Data Lake Storage Azure Databricks Azure Synapse Analytics