Microsoft Azure Exam DP-200 - Implementing an Azure Data Solution

By Brian Roehm

Develop the skills necessary to pass the Microsoft Azure DP-200 certification exam and become comfortable with Azure big data and analytics.

12 hours
  • 62 Lessons
  • 6 Hands-On Labs
  • 1 Practice Exam

About the course

This course is designed to help develop the skills necessary to pass the Microsoft Azure DP-200 certification exam. This exam measures one’s ability to do the following:

  • Implement data storage solutions
  • Manage and develop data processing
  • Monitor data solutions
  • Manage and troubleshoot Azure data solutions

We will dive into each of these topics to prepare you for the exam and get comfortable with Azure big data and analytics.

  • Chapter 1 6 Lessons Course Introduction 13:13

    An Important Note about A Cloud Guru and Linux Academy Courses

    1:19

    Course Introduction

    1:48

    About the Training Architect

    1:16

    About the Exam

    5:34

    Important Timeline information about the Data Engineering Associate Certification

    2:06

    Microsoft Learn

    1:10
  • Chapter 2 4 Lessons Introductory Concepts 21:00

    Designing a Data Schema

    3:30

    Introduction to SQL and NoSQL Databases

    6:14

    Introduction to ETL and ELT in Data Engineering

    6:47

    Introduction to Data Orchestration in Azure

    4:29
  • Chapter 3 9 Lessons Implement Non-Relational Data Stores 3:57:49

    Azure Data Lake Introduction

    9:00

    Cosmos DB Essentials

    15:07

    Implementing Consistency in Cosmos DB

    10:05

    Partitioning and Horizontal Scaling in Cosmos DB

    7:19

    Selecting and Implementing API in Cosmos DB

    6:35

    Implementing Security in Cosmos DB

    9:43

    Intro to Using Azure Blob Storage

    45:00 Hands-On Lab

    Provisioning a Cosmos DB Instance in Azure

    1:30:00 Hands-On Lab

    Provisioning a Gen 2 Azure Data Lake

    45:00 Hands-On Lab
  • Chapter 4 8 Lessons Implement Relational Data Stores 1:42:25

    Introduction to Azure Synapse Analytics

    7:05

    High Availability, Disaster Recovery, and Global Distribution in Azure Synapse Analytics

    4:41

    Data Distribution and Partitioning in Azure Synapse

    10:29

    Introduction to PolyBase

    3:02

    Ingesting Data in PolyBase

    6:03

    Azure Synapse Analytics Studio

    5:20

    Exam Essentials and References

    5:45

    Provisioning an Azure Synapse Analytics Instance

    1:00:00 Hands-On Lab
  • Chapter 5 2 Lessons Managing Data Security 16:14

    Implement Data Masking

    6:20

    Encrypt Data at Rest and in Motion

    9:54
  • Chapter 6 5 Lessons Develop Batch Processing Solutions 39:03

    Batch Processing Overview

    6:30

    Databricks Introduction

    7:26

    Implementing Azure Databricks Clusters Part 1

    8:17

    Implementing Azure Databricks Clusters Part 2

    5:50

    Working With Notebooks in Databricks

    11:00
  • Chapter 7 4 Lessons Develop Streaming Solutions 38:00

    Introduction to Azure Stream Analytics

    12:14

    Azure Stream Windowing Functions

    13:10

    Creating a Job in Stream Analytics

    6:12

    Using Reference Data for Lookups in Stream Analytics

    6:24
  • Chapter 8 6 Lessons Develop Integration Solutions 1:32:25

    Introduction to Azure Data Factory

    5:20

    Create and Schedule Triggers

    5:35

    Developing Pipelines in Azure Data Factory

    9:23

    Implementing Integration Runtime for Data Factory

    6:56

    Exam Essentials and References

    5:11

    Developing a Pipeline in Azure Data Factory

    1:00:00 Hands-On Lab
  • Chapter 9 8 Lessons Monitor Data Storage 1:38:39

    Monitoring a Storage Account in the Azure Portal

    5:17

    An Introduction to Azure Monitor

    4:56

    Azure Storage Metrics in Azure Monitor

    13:19

    Implement Cosmos DB Monitoring

    5:08

    Implement Monitoring in Blob Storage

    8:20

    Implement Monitoring in Azure Synapse Analytics

    9:03

    Working with Azure Log Analytics

    7:36

    Implementing Azure Monitor

    45:00 Hands-On Lab
  • Chapter 10 3 Lessons Monitor Data Processing 19:10

    Monitoring Stream Analytics

    6:53

    Monitoring Data Factory

    8:14

    Monitoring Azure Databricks

    4:03
  • Chapter 11 4 Lessons Manage Optimization 26:24

    Optimizing Data Lake Performance

    7:10

    Optimizing Azure Stream Analytics

    5:39

    Optimizing Azure Synapse Analytics

    7:55

    Managing the Data Lifecycle

    5:40
  • Chapter 12 1 Lesson Practice Exam 1:30:00

    DP-200: Implementing an Azure Data Solution

    1:30:00 Quiz
  • Chapter 13 3 Lessons Course Conclusion 8:15

    Exam Essentials and References

    2:55

    What's Next

    4:04

    Microsoft Learn Conclusion

    1:16

What you will need

  • Before taking the DP-200 course please have familiarity with the concepts in the AZ-900 course. Basic database knowledge is also helpful but not required.

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!