DP-203 Exam Preparation: Data Engineering on Microsoft Azure

DifficultyIntermediate
AVG Duration17h
Students3524
Ratings
4.7/5
starstarstarstarstar-half
Content
141117

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 - Beginner - 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.
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.
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 - Beginner - 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.
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
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 - Beginner - 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.
18
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.
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
20
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.
21
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.
22
Resource - Not defined - 2h 50m
Required Reading for Microsoft DP-203 Exam
23
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.
24
Exam - 2h 30m
Cert Prep: Data Engineering on Microsoft Azure (DP-203)
Cert Prep: Data Engineering on Microsoft Azure (DP-203)
About the Author
Students175108
Courses98
Learning paths148

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