• Stars
    star
    351
  • Rank 120,906 (Top 3 %)
  • Language
    PowerShell
  • License
    MIT License
  • Created almost 2 years ago
  • Updated 3 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Exercise files for Microsoft Data Engineer curriculum

DP-203: Azure Data Engineer

This repository contains instructions and assets for hands-on exercises in the Microsoft Official Courseware to support the Microsoft Certified: Azure Data Engineer Associate certification. The exercises are designed to complement the associated training modules on Microsoft Learn, and a subset of these exercises comprises the hands-on labs in the official DP-203T00: Data Engineering on Microsoft Azure instructor-led training course.

Exercise design principles

The exercises in the repo are designed to support both self-paced learners on Microsoft Learn, and students in official instructor-led training deliveries. In most cases, self-paced learners must provide their own cloud subscription, while students attending official instructor-led courses are typically provided with subscriptions they can use to complete each individual exercise that is included in the course. Note that Microsoft does not support instructor-led deliveries of the exercises in this repo in environments other than those provided by Microsoft authorized lab hosters (ALHs).

The exercises are designed to stand alone, independently of one another. Most labs begin with instructions to clone the repo and run an exercise-specific setup script to prepare the environment, which can take anywhere between 2 and 20 minutes depending on the resources required in the exercise. While this can result in a repetitive experience that requires some patience as the setup script runs, it is necessary to minimize cloud service costs (for both self-paced learners and hosted lab environments in instructor-led deliveries), and to support self-paced learners choosing their own path through the associated training modules on Microsoft Learn.

The numbering of the exercises in this repo indicates a suggested logical sequence that reflects the flow of modules in the official learning paths and the instructor-led materials. The numbers do not indicate the corresponding slide deck or "lab" in an instructor-led course.

Some of the exercises are suggested as instructor demo's in classroom deliveries. Trainers can follow these suggestions or demonstrate any of the exercises at their discretion. Note however that hosted lab profiles and cloud subscriptions may not be provided for exercises that are not included as student labs in courses; and the exercise-specific hosted subscriptions that are provided in lab profiles may have policies applied that prevent completion of other exercises. Trainers are advised to test available lab profiles and to use their own cloud subscriptions for demonstrations if necessary.

Contributing to this repo

Microsoft Certified Trainers (MCTs) are welcome to submit issues and PRs related to content or assets in this repo, subject to the guidance in the GitHub User Guide for MCTs. Trainers should bear in mind that the repo is designed to support self-paced learners on Microsoft Learn as well as students in instructor-led courses, and that some of the exercises in the repo are not included in the hosted lab profiles for classroom delivery. Issues relating to configuration or performance of lab environments provided by ALHs are not supported here - contact your ALH if you experience problems related to the hosted lab environment.

More Repositories

1

AZ-104-MicrosoftAzureAdministrator

AZ-104 Microsoft Azure Administrator
PowerShell
3,408
star
2

AZ-204-DevelopingSolutionsforMicrosoftAzure

AZ-204: Developing solutions for Microsoft Azure
C#
2,242
star
3

AZ500-AzureSecurityTechnologies

Microsoft Azure Security Technologies
Bicep
835
star
4

AI-102-AIEngineer

Lab files for AI-102 - AI Engineer
C#
714
star
5

mslearn-dp100

Lab files for Azure Machine Learning exercises
Jupyter Notebook
614
star
6

DP100

Labs for Course DP-100: Designing and Implementing Data Science Solutions on Microsoft Azure
Jupyter Notebook
614
star
7

AZ400-DesigningandImplementingMicrosoftDevOpsSolutions

AZ-400 Course Repository for Labs and Demos.
537
star
8

AZ-303-Microsoft-Azure-Architect-Technologies

PowerShell
475
star
9

mslearn-ai900

Lab files for AI-900: Azure AI Fundamentals
Jupyter Notebook
451
star
10

DP-203-Data-Engineer

440
star
11

PL-300-Microsoft-Power-BI-Data-Analyst

PowerShell
422
star
12

DA-100-Analyzing-Data-with-Power-BI

TSQL
375
star
13

AZ-304-Microsoft-Azure-Architect-Design

Dockerfile
358
star
14

Principles-of-Machine-Learning-Python

Principles of Machine Learning Python
Jupyter Notebook
348
star
15

Lab-Demo-Recordings

Recordings and Demos of Labs
324
star
16

AI-900-AIFundamentals

Includes labs for AI Fundamentals.
PowerShell
319
star
17

DP-900T00A-Azure-Data-Fundamentals

DP-900 ILT lab instructions
Jupyter Notebook
276
star
18

SC-200T00A-Microsoft-Security-Operations-Analyst

PowerShell
275
star
19

PL-900-Microsoft-Power-Platform-Fundamentals

PL-900 Microsoft Power Platform Fundamentals
255
star
20

AZ-700-Designing-and-Implementing-Microsoft-Azure-Networking-Solutions

Bicep
211
star
21

mslearn-openai

C#
210
star
22

Data-Science-Essentials

Course files for the Microsoft data Science Essentials Course
209
star
23

AZ-305-DesigningMicrosoftAzureInfrastructureSolutions

AZ-305: Designing Microsoft Azure Infrastructure Solutions
201
star
24

MS-500-Microsoft-365-Security

MS-500 Microsoft 365 Security Administrator courses
201
star
25

SC-300-Identity-and-Access-Administrator

PowerShell
197
star
26

DP-203T00-Data-Engineering-on-Microsoft-Azure

C#
183
star
27

mslearn-azure-ml

Jupyter Notebook
174
star
28

mslearn-fabric

This repository hosts content related to Microsoft Fabric content on Microsoft Learn.
Jupyter Notebook
170
star
29

PL-400_Microsoft-Power-Platform-Developer

C#
163
star
30

PL-200-Power-Platform-Functional-Consultant

PL-200 Power Platform Functional Consultant
PowerShell
142
star
31

EntityFramework

Entity Framework and MVC MVA
C#
140
star
32

PL-100-Microsoft-Power-Platform-App-Maker

139
star
33

DP-300T00-Administering-Relational-Databases-on-Azure

TSQL
137
star
34

WebAPIDesign

Web API Design MVA
C#
134
star
35

eShopOnWeb

Repository maintained by AZ-400 course and Learn content community. Project used for AZ-400 Labs. Forked from: https://github.com/dotnet-architecture/eShopOnWeb Sample - ASP.NET Core 8.0 reference application, powered by Microsoft, demonstrating a layered application architecture with monolithic deployment model.
C#
128
star
36

MS-700-Managing-Microsoft-Teams

124
star
37

MVAAngular

Slides and demos from AngularJS MVA
HTML
124
star
38

AZ-100-MicrosoftAzureInfrastructureDeployment

121
star
39

Research-Methods-for-Data-Science-with-Python

Research Methods for Data Science with Python
Jupyter Notebook
120
star
40

mslearn-ai-fundamentals

Azure AI Fundamentals exercises
111
star
41

AZ-140-Configuring-and-Operating-Microsoft-Azure-Virtual-Desktop

109
star
42

SC-900-Microsoft-Security-Compliance-and-Identity-Fundamentals

98
star
43

Programming-in-R-for-Data-Science

R
97
star
44

Introduction-to-Data-Analysis-using-Excel

89
star
45

Deep-Learning-Explained

This repository contains the lab files for Microsoft course DAT236x: Deep Learning Explained
Jupyter Notebook
89
star
46

dp-420-cosmos-db-dev

DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
C#
80
star
47

SC-100-Microsoft-Cybersecurity-Architect

76
star
48

Speech-Recognition

Hosted files for DEV287x-Speech Recognition Systems
Roff
74
star
49

Principles-of-Machine-Learning-R

Principles of Machine Learning R
Jupyter Notebook
73
star
50

Data-Analysis-for-Absolute-Beginners

First course of the Data Analysis Professional Program, Data Analysis: A Practical Approach for Absolute Beginners
66
star
51

DP-500-Azure-Data-Analyst

Lab files for DP-500
TSQL
66
star
52

AZ-101-MicrosoftAzureIntegrationandSecurity

PowerShell
64
star
53

AZ-120-Planning-and-Administering-Microsoft-Azure-for-SAP-Workloads

Labs for AZ-120 Planning and administering Microsoft Azure for SAP workloads
64
star
54

Implementing-ETL

57
star
55

Reinforcement-Learning-Explained

This repository contains the lab files for Microsoft course DAT257x: Reinforcement Learning Explained
Jupyter Notebook
54
star
56

MS-600-Building-Applications-and-Solutions-with-Microsoft-365-Core-Services

C#
51
star
57

Essential-Math-R

Essential-Math-R
Jupyter Notebook
50
star
58

Django

Repository for the Django MVA
Python
46
star
59

MCT-User-Guide

GitHub User Guide for MCTs
45
star
60

Processing-Big-Data-with-Hadoop-in-Azure-HDInsight

Shared files for Processing Big Data with Hadoop in Azure HDInsight course
44
star
61

AZ-040T00-Automating-Administration-with-PowerShell

44
star
62

INF99X-SampleCourse

INF99X: Sample Course (Sample Repository)
44
star
63

MB-800-Business-Central-Functional-Consultant

43
star
64

Essential-Math

Lab files for Essential Math course
Jupyter Notebook
43
star
65

databricks-intro

An introduction to analyzing data using Spark in Azure Databricks
43
star
66

PL-600-Microsoft-Power-Platform-Solution-Architect

42
star
67

PythonSqlFlask

Code demos and slides for SQL, Python, Flask MVA
Python
41
star
68

AZ-900T0xES-MicrosoftAzureFundamentals

AZ-900T00 y AZ-900T01: Fundamentos de Microsoft Azure
40
star
69

Essential-Math-for-Data-Analysis

Learn the essentials of math for data analysis using Excel Online - Part of the Data Analyst Microsoft Professional Program
40
star
70

mslearn-ai-language

Lab files for Azure AI Language modules
C#
40
star
71

AZ-104JA-MicrosoftAzureAdministrator

AZ-104: Microsoft Azure ็ฎก็†่€…
PowerShell
39
star
72

AZ-800-Administering-Windows-Server-Hybrid-Core-Infrastructure

AZ-800
PowerShell
39
star
73

SC-400T00A-Microsoft-Information-Protection-Administrator

37
star
74

edX-DEV212x-Intro-to-DevOps

The repository for the edX course: Introduction to DevOps.
JavaScript
35
star
75

MS-203T00-Microsoft-365-Messaging

34
star
76

dp-300-database-administrator

Repository for lab exercises and instructions for Microsoft DP-300 learning content
TSQL
34
star
77

mslearn-ai-services

Lab files for Azure AI Services modules
C#
32
star
78

Introduction-to-Data-Science

Course files for DAT101x: Introduction to Data Science
32
star
79

WS-011-Windows-Server-2019-Administration

31
star
80

mslearn-ai-vision

Lab files for Azure AI Vision modules
C#
31
star
81

dp-080-Transact-SQL

TSQL
30
star
82

JavaScript-Experienced-Developers

A repository for the MVA course on JavaScript for experienced developers.
JavaScript
30
star
83

Data-Science-Orientation

29
star
84

databricks-ml

Machine Learning with Azure Databricks
28
star
85

AZ-104ZH-MicrosoftAzureAdministrator

AZ-104๏ผšMicrosoft Azure ็ฎก็†ๅ‘˜
PowerShell
28
star
86

Research-Methods-for-Data-Science-with-R

Research Methods for Data Science with R
Jupyter Notebook
27
star
87

mslearn-databricks

PowerShell
26
star
88

MB-820-Business-Central-Developer-Certification

AL
26
star
89

mslearn-ai-document-intelligence

Lab files for Azure AI Document Intelligence modules
Python
25
star
90

ReactJS

25
star
91

PL-500T00-Microsoft-Power-Automate-RPA-Developer

PL-500T00-Microsoft-Power-Automate-RPA-Developer
25
star
92

MB-230-Dynamics365forCustomerService

MB-230 Dynamics 365 Customer Service
23
star
93

MB-220-Dynamics365forMarketing

MB-220 Dynamics 365 Marketing
21
star
94

MVA-42339-PowerShell-for-SQL-Data-Professionals

Scripts and demo files for MVA course.
PowerShell
21
star
95

mslearn-ai-studio

Practical exercises for Azure AI Studio training
21
star
96

MS-720-Microsoft-Teams-Voice-Engineer

20
star
97

MB-910T00A-Microsoft-Dynamics-365-Fundamentals-Customer-Engagement-Apps

MB-910: Microsoft Dynamics 365 Fundamentals (CRM)
20
star
98

advanced-gen-ai

Shell
19
star
99

mslearn-knowledge-mining

Lab files for Azure AI Knowledge Mining modules
C#
19
star
100

WS-013T00-Azure-Stack-HCI

Create git repo
PowerShell
18
star