Microsoft DP-203 Certified: Azure Data Engineer Associate
- Description
- Curriculum
- FAQ
- Reviews
This course is ideal for students aspiring to achieve the “Microsoft Certified: Azure Data Engineer Associate” certification.
It includes comprehensive content aligned with the DP-203 exam.
The course objectives focus on the following areas:
-
Design and implement data storage (15–20%)
-
Develop data processing (40–45%)
-
Secure, monitor, and optimize data storage and data processing (30–35%)
This Course structure organizes the course into a logical progression while providing a clear breakdown of the covered topics. Here’s is the structured outline of the course sections:
1. Introduction and Setup
-
Overview of the course and initial setup.
2. Design and Implement Data Storage
-
Azure Data Lake: Understanding and implementing data storage with Azure Data Lake.
-
Azure SQL Server: Designing storage solutions using Azure SQL Server.
-
Cosmos DB: Exploring storage capabilities with Cosmos DB.
-
Azure Synapse Analytics: Building and managing storage in Azure Synapse Analytics.
3. Develop Data Processing
-
Azure Synapse Spark Pool: Leveraging Spark pools in Azure Synapse for data processing.
-
Azure Data Factory: Developing ETL pipelines and data flows in Azure Data Factory.
-
Azure Databricks: Implementing data processing workflows with Azure Databricks.
-
Azure Event Hubs: Streaming and processing real-time data using Azure Event Hubs.
-
Azure Stream Analytics: Real-time data stream processing with SQL-based queries.
4. Secure Your Data
-
Azure Data Lake Security: Implementing security best practices for Azure Data Lake.
-
Azure Synapse Analytics Security: Securing data in Azure Synapse Analytics.
-
Azure Data Factory and Databricks Security: Ensuring secure data workflows in Azure Data Factory and Databricks.
4. Monitor and Optimize
-
Azure Data Lake Storage: Monitoring and optimizing storage performance.
-
Azure Data Factory: Ensuring efficient operations with monitoring tools.
-
Azure Synapse Analytics: Performance tuning and monitoring analytics workloads.
-
Azure Stream Analytics and Cosmos DB: Streamlining data streams and database operations.
-
Data Governance with Microsoft Purview: Managing and governing data using Microsoft Purview.
5. Exam Preparation
-
Past Papers and Practice: Access to 500 exam questions to solidify knowledge and prepare for certification.
-
1
1.1.Overview-Cloud Computing -
2
1.2.Concepts-Introduction to Cloud Computing.mp4
-
3
1.3.Overview-Microsoft Azure.mp4
-
4
1.4.Overview-How we are going to approach the Exam.mp4
-
5
1.5.HandsOn-Create Azure Account.mp4
-
6
1.6.HandsOn-Azure Portal Overview.mp4
-
7
1.7.Overview-IMPORTANT-How to Complete the Course
-
8
Complete Course Files
-
9
2.0.Overview-Data Engineering Basics Concepts
-
10
2.1.Overview of Types of azure Storage Account
-
11
2.2.HandsOn-Create Azure Storage Account
-
12
2.3.Overview of DataLake Gen2 Storage Account
-
13
2.4.HandsOn-Create DataLake Gen2 Storage Account
-
14
2.5.Different Format Types + HandsOn Uploading Files to Azure Storage
-
15
Congrats on Completing a Section
-
16
3.1.1.Overview-Azure SQL Database
-
17
3.1.2.Overview Azure SQL Pricing Tier and Configuration Types
-
18
3.2.Overview SQL Server Creation on Azure
-
19
3.3.HandsOn SQL Server Creation
-
20
3.4.HandsOn-connecting with SQL Server Using SSMS
-
21
3.5.Installing Azure Data Studio
-
22
3.6.1.HandsON - T-SQL Select Statement Basics
-
23
3.6.2.HandsOn T-SQL Multiple Conditioning using Where Clause
-
24
3.6.3.HandsOn T-SQL Order By Clause
-
25
3.6.4.HandsOn T-SQL Aggregate Functions
-
26
3.6.5.HandsOn T-SQL Group By Clause
-
27
3.6.6.HandsOn T-SQL Partition By Statement
-
28
3.6.7.HandsOn T-SQL LEAD and LAG Statement
-
29
3.6.8.HandsOn T-SQL Common Table Expression using WITH Clause
-
30
3.6.9.HandsOn T-SQL CASE Statement
-
31
Congrats on Completing a Section
-
32
4.1.1.Overview-Cosmos DB
-
33
4.1.2.Concepts-CosmosDB use Cases
-
34
4.1.3.Concepts-CosmosDB as a Solution
-
35
4.2.1.Overview-Cosmos DB Pricing
-
36
4.2.2.Concepts-Cosmos DB Throughput Models
-
37
4.3.1.Overview-Cosmos DB APIs
-
38
4.3.2.Concepts-Data Modelling and their APIs
-
39
4.3.3.Concepts-APIs Use-cases for Cosmos DB
-
40
4.4.1.HnadsOn-Cosmos DB Account Creation
-
41
4.5.1.Concepts-Databases, containers, and items in Cosmos DB
-
42
4.5.2.HandsOn-Create Database inside Cosmos DB account
-
43
4.5.3.HandsOn-Create a Container inside Cosmos DB
-
44
4.5.4.HandsOn-Create Items inside Cosmos DB
-
45
4.6.1.Concepts-Physical Partitions in Cosmos DB
-
46
4.6.2.Concepts-Logical Partitions in Cosmos DB
-
47
4.7.1.Concepts-Consistency Levels in Cosmos DB
-
48
4.7.2.HandsOn-Set Consistency for Cosmos DB
-
49
4.8.1.HandsOn-Scaling a Cosmos DB across the Globe
-
50
Congrats on Completing a Section
-
51
5.1.Overview-Azure Synapse Analytics basic Concepts
-
52
5.2.Overview-Azure Synapse Components
-
53
5.3.Overview-Azure Synapse Compute Power
-
54
5.5.Concept-SQL Database vs SQL Data Warehouse
-
55
5.6.Overview-Serverless SQL Pools
-
56
5.7.Overview-Synapse SQL Underlying Architecture
-
57
5.9.HandsOn-Create Synapse Workspace
-
58
5.10.1.HandsOn-Query Csv from Data Lake
-
59
5.10.2.HandsOn-Setting Role Assignment inside Data lake for Reading Data
-
60
5.11.Overview-Dadicated SQL Pool
-
61
5.12.HandsOn-Creating and Pausing Dedicated SQL Pool
-
62
5.13.0.Overview-Data Loading Methods
-
63
5.13.1.HandsOn-External Table Serverless SQL CSV format-part1
-
64
5.13.2.HandsOn- External Table Serverless SQL csv format-part2
-
65
5.13.3.HandsOn- External Table Dedicated SQL csv format-part3
-
66
5.13.4.HandsOn-External table parquet serverless&dedicated
-
67
5.13.5.HandOn-Copying Data using Polybase
-
68
5.13.6.HandsOn-Copying Data using Copy into Statement
-
69
5.13.7.HandsOn-Copying Data with Auto Schema Detection using Copy into Statement
-
70
5.13.8.HandsOn-Copying Data using Pipelines
-
71
5.14.Concepts-Transverse Files and Folders for Hadoop and Native file system
-
72
5.15.1.Overview-OLAP and OLTP systems
-
73
5.15.2.Overview-Fact and Dimension Tables
-
74
5.15.3.Overview-Star and Snow Flake Schema Design
-
75
5.15.4.0.HandsOn-Transfer Data from SQL to Synapse SQL dedicated pool
-
76
5.15.4.1.HandsOn-Transfer Data from SQL to Synapse SQL dedicated pool
-
77
5.16.1.Concepts-Table or Data Distribution Methods
-
78
5.16.2.Concepts-Distribution Selection
-
79
5.16.3.Concepts-Hash and Replicated Distribution
-
80
5.16.4.HandsOn-Creating Table Distribution in Dedicated SQL Pool
-
81
5.16.5.HandsON-Query Performance and Monitor Tab inside Synapse
-
82
5.16.6.Concepts-Slowly Changing Dimension Types
-
83
5.16.7.0.HandsOn-Business Key for Creation for Dimension tables
-
84
5.16.7.1.HandsON-Business Key for Creation for Dimension tables
-
85
5.17.1.Overview-Use of Index on tables
-
86
5.17.2.Concepts-Partition and Partition Switching
-
87
5.18.0.HandsOn-Create a Restore Point and Restoring a Dedicated SQL pool
-
88
5.19.0.Overview-Database Templates for Synapse Analytics
-
89
Congrats on Completing a Section
