1. Home
  2. Training Library
  3. Microsoft Azure
  4. Learning Paths

DP-201 Exam Preparation: Designing an Azure Data Solution

DifficultyIntermediate
AVG Duration13h
Students1790
Ratings
4.8/5
starstarstarstarstar-half
Content
1315

Description

This Learning Path is designed to help you and your team prepare for Microsoft's DP-201 Designing an Azure Data Solution exam. Even if you don't plan to take the exam, these courses and hands-on labs will help you learn how to design a variety of Azure data solutions.

Candidates who pass both the DP-200 and DP-201 exams will earn the Microsoft Certified: Azure Data Engineer Associate certification.

The DP-201 exam tests your knowledge of three subject areas: designing data storage solutions, designing data processing solutions, and designing for data security and compliance. 

Learning Objectives

  • Design Azure data storage solutions
  • Design data processing solutions
  • Design for data security and compliance

Intended Audience

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

Prerequisites

  • Basic experience using Microsoft Azure

Certificate

Your certificate for this learning path

Training Content

1
Course - Intermediate - 3m
DP-201 Exam Prep - Introduction
This course introduces the DP-201 Exam Preparation: Designing an Azure Data Solution learning path.
Show details
Go to course
2
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.
Show details
Go to course
3
Course - Beginner - 50m
FREE
Introduction to Azure Storage
In this course, you will learn how to use the core Azure Storage services as building blocks for Azure applications and virtual machines.
Show details
Go to course
4
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.
Show details
Go to course
5
Hands-on Lab - Intermediate - 2h 10m
Working with Azure Storage Using PowerShell
Working with Azure Storage using PowerShell, you will explore the different storage types, manage storage account keys, and generate shared access signatures.
Show details
Go to hands-on lab
6
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.
Show details
Go to course
7
Course - Intermediate - 1h 8m
Introduction to Azure Cosmos DB
This course shows how to make use of Cosmos DB's incredible flexibility and performance tools on Microsoft Azure.
Show details
Go to course
8
Hands-on Lab - Intermediate - 1h 30m
Developing with the Cosmos DB Core API and Change Feed
In this Lab, you will learn how to manage Cosmos DB using the Azure Portal and Azure CLI as you integrate Azure Functions with Cosmos DB change feed triggers to buy and sell fictitious stocks.
Show details
Go to hands-on lab
9
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.
Show details
Go to course
10
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.
Show details
Go to course
11
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.
Show details
Go to course
12
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.
Show details
Go to course
13
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.
Show details
Go to hands-on lab
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.
Show details
Go to course
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.
Show details
Go to hands-on lab
16
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.
Show details
Go to course
17
Course - Intermediate - 3m
DP-201 Exam Prep - Additional Topics
This course covers Table Storage in Azure with a focus on how to choose a partition key, which is important to know if you're preparing for DP-201 exam.
Show details
Go to course
18
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.
Show details
Go to hands-on lab
19
Exam - 2h 30m
Cert Prep: Designing an Azure Data Solution (DP-201)
Cert Prep: Designing an Azure Data Solution (DP-201)
Show details
Go to exam
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

NoSQLBig DataMachine LearningSQLSecurityStorageDatabasesAnalyticsArtificial IntelligenceMicrosoft AzureDatabases for AzureSecurity for AzureStorage for AzureAnalytics for AzureArtificial Intelligence for AzureAzure Stream AnalyticsAzure StorageAzure Data FactoryAzure DatabricksAzure Synapse AnalyticsAzure Cosmos DBAzure SQL Database