Microsoft Certified Azure Data Engineer Associate (DP-203) - eLearning

450,00 EUR

  • 40 hours
eLearning

Become a skilled data engineer in the cloud with the Microsoft Certified Azure Data Engineer Associate (DP-203) training. This comprehensive course is designed to help you build, manage, and optimize data solutions using Microsoft Azure’s powerful data services.

Key Features

Language

Course and material in English

Level

Beginner - Intermediate level

Access

1 Year access to the learning platform

23 Hours of On-Demand Videos

with 40+ hours recommended study time

6 Hands-On Exercises

12 Auto Graded Assessments

4 Real-World Projects

4 Comprehensive Assignments

No Exam Voucher

Program completion certification included

Hero

Learning Outcomes

At the end of this Course, you will be able to:

Design

Design and implement scalable data storage solutions on Azure

Pipeline

Build and manage data pipelines for batch and real-time processing

Azure Data Lake

Work with Azure Data Lake, Synapse Analytics, and Data Factory

Integration

Implement data transformation and integration workflows

Secure

Secure and monitor data storage and processing systems

Optimize

Optimize data performance and troubleshoot issues

Apply

Apply data engineering best practices in cloud environments

Data security

Develop end-to-end analytics solutions using Azure services

Hero

Course timeline

  1. Introduction to Azure Cloud and Data Engineer Profile

    Lesson 01

    • How to Create Azure Subscription
    • Azure Portal Overview
    • How to Delete Resources and Set Budget
    • How Did Data Engineer Profile Evolve
    • Understand Data Engineer's Role and Responsibility
    • Explore Data Engineer Technologies
  2. Data Storage Non-Relational Data Stores

    Lesson 02

    • Overview of Azure Storage Services
    • Demo Provision Azure Storage Account
    • Explore Data Redundancy Options
    • Overview Azure Blob Storage
    • Learn about Azure Storage Access Tiers
    • Overview Azure Table Storage
    • Overview of Azure Queue Storage
    • Understand Azure File Share Storage
    • Demo Azure File Share Storage
    • Azure Disk Storage and Demo
    • Explore Cosmos DB and its Various Features
    • What is Data Lake?
    • How Data Lake Gen 2 Evolved
    • Azure Blob Storage vs Azure Data Lake
    • Explore Azure Blob and Data Lake Security Options
    • High Availability vs Disaster Recovery
    • Azure Storage - HA and DR Options
    • Cosmos DB - HA and DR Options
  3. Data Storage Relational Data Stores

    Lesson 03

    • Module Introduction
    • Features of Azure SQL
    • Explore Azure SQL and its Various Features
    • Learn the Difference between Traditional vs Modern Warehouse Architecture
    • What is Synapse Analytics Service
    • Demo: Create Dedicated SQL Pool
    • Demo: Connect Dedicated SQL Pool with SSMS
    • Demo: Create Azure Synapse Analytics Studio Workspace
    • Demo: Explore Synapse Studio
    • Demo: Create Dedicated SQL Pool and Spark Pool
    • Demo: Analyse Data using Dedicated SQL Pool
    • Demo: Analyse Data using Apache Spark Notebook
    • Demo: Analyse Data using Serverless SQL Pool
    • Demo: Data Factory from Synapse Analytics Studio
    • Demo: Monitor Synapse Studio
    • Explore Azure Synapse and its Various Features
    • Understand the Scaling Azure Datawarehouse
    • Azure SQL Datawarehouse Backup and Restore
    • Azure Database vs Azure Datawarehouse (Synapse Data Pool)
    • How to Implement Data Masking
    • Learn to Encrypt Data at Rest and in Motion
  4. Batch Processing

    Lesson 04

    • Explore Azure Data Factory and its Features
    • What is Azure Databricks
    • Demo Overview
    • Demo: Provision Databricks, Clusters and Workbook
    • Demo: Mount Data Lake to Databricks DBFS
    • Demo: Explore, Analyze, Clean, Transform and Load Data in Databricks
    • Learn About Spark Basics
    • Explore Azure Databricks Clusters
    • Azure Databricks Other Important Components
  5. Streaming Analytics

    Lesson 05

    • Module Introduction
    • What is Live Event Processing
    • Introducing Azure Stream Analytics (Configure Input and Output)
    • Introduction to Windowing Functions
    • What is Tumbling Window
    • What is Hopping Window
    • What is Sliding Window
    • What is Session Window
    • Demo: Processing Blob Storage Input
    • Demo: Processing IOT Hub Input
  6. Monitor Data Storage

    Lesson 06

    • Intro to Azure Monitor Service
    • Demo: Azure Monitor Service
    • Implementing Blob and Data Lake Storage Monitoring
    • Implement Azure Synapse Analytics Monitoring
    • Implement Cosmos DB Monitoring
  7. Monitor Data Processing

    Lesson 07

    • Monitor Data Factory Pipelines
    • Monitor Data Factory - Metrics, Alerts, Diagnostic Settings
    • Monitor Azure Databricks
    • Monitor Stream Analytics
  8. Optimize Azure Data Solutions

    Lesson 08

    • Troubleshoot Data Partitioning Bottlenecks
    • Optimize Data Lake Storage
    • Optimize Stream Analytics
    • Optimize Azure Synapse Analytics
    • Manage the Data Lifecycle
  9. Designing an Azure Data Solution

    Lesson 09

    • Different Types of Data Types
    • Data Storage Types
    • Select Azure Store for Application
    • Azure Data Platform Architecture
    • Understand RTO and RPO
    • Scenarios - Designing a Solution for CosmosDB vs Data Lake vs Blob Storage
    • Scenarios - Designing for SQL Database vs Data warehouse
    • Design Batch Processing Solutions Using Data Factory and DataBricks
    • Learn Data Ingestion Methods
    • Explore Real Time Processing
    • Design and Provision Compute Resources
    • Explore Lambda Architecture
    • Plan for Secure Endpoints (Public/Private)
Microsoft Certified Azure Data Engineer Associate

Who Should Enroll in This Program?

Aspiring data engineers

Cloud solutions architects

Azure developers and administrators

Data professionals transitioning to cloud platforms

DevOps and IT professionals working with data systems

Business intelligence and analytics professionals

Start Course Now

Prerequisites

  • Basic understanding of data formats such as CSV and JSON
  • Fundamental knowledge of databases and data processing concepts
  • Familiarity with cloud computing concepts is helpful
  • Experience with SQL or programming languages (optional but beneficial)

Statements

Licensing and accreditation

This course is offered according to Partner Program Agreement and complies with the License Agreement requirements

Equity Policy

Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.


Frequently Asked Questions

Contact background

Need corporate solutions or LMS integration?

Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!