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
  • 59 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 4 Lessons Course Introduction 9:57

    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
  • 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 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

    0:00 Hands-On Lab

    Provisioning a Cosmos DB Instance in Azure

    0:00 Hands-On Lab

    Provisioning a Gen 2 Azure Data Lake

    0:00 Hands-On Lab
  • Chapter 4 8 Lessons Implement Relational Data Stores 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

    0: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 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

    0:00 Hands-On Lab
  • Chapter 9 8 Lessons Monitor Data Storage 53: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

    0: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 2 Lessons Course Conclusion 6:20

    What's Next

    3:25

    Exam Essentials and References

    2:55

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.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

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