Microsoft Certified Azure Data Engineer Associate (DP-203) - eLearning
450,00 EUR
- 40 hours
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

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

Course timeline
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
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
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
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
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
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
Monitor Data Processing
Lesson 07
- Monitor Data Factory Pipelines
- Monitor Data Factory - Metrics, Alerts, Diagnostic Settings
- Monitor Azure Databricks
- Monitor Stream Analytics
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
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)

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

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!
