DP-203: Microsoft Azure Data Engineer
In this four-day training, you will learn about data engineering an use batch- and real-time analytical solutions using Azure data platform technologies.
The training will introduce you to Azure core compute and storage technologies, how to ingest data into Azure Synapse Analytics or Azure Databricks, and how to design data loading pipelines with Azure Data Factory or Azure Synapse pipelines. You’ll also learn various ways to transform and analyze data, how to secure your data infrastructure, and how to create real-time analytical solutions in the Azure cloud.
This training prepares you for the Azure Data Engineer exam and certification.
Here’s What You’ll Get
Training Manual
Hands-On Lab
Cloud Credit
Private Slack Channel
Unlimited Teams Calls
Exam Voucher
Certificate of Completion
Self-Paced or Classroom Training
180-day Lab Access
Training Details
In this four-day training, you will learn about data engineering and work with batch- and real-time analytical solutions using Azure data platform technologies.
The training will introduce you to Azure compute and storage services that you’ll use to build an analytical solution. You’ll learn how to ingest data into Azure Synapse Analytics or Azure Databricks using Azure Data Factory or Azure Synapse pipelines. You’ll also learn how to extract, transform and load data into a data warehouse and how to secure your data infrastructure in the cloud.
As part of this training, you’ll receive an Azure Pass with credits to spend on your own cloud services. The pass is valid for 30 days.
Name: DP-203: Microsoft Azure Data Engineer
Format: Classroom
Content: training manual, online lab, Azure cloud credit, practice exam, and an exam voucher
Requirements: a laptop with a web browser installed. Chrome or Edge is recommended.
Support: Live classroom support
Associated certification: Microsoft Azure Data Engineer
Training Curriculum
Explore Azure data services
Azure Synapse Analytics
Azure Databricks
Azure Data Lake
The Delta Lake architecture
Azure Stream Analytics
Lab exercises
Build a streaming & batch pipeline
Create a Delta Lake
Index data lake storage
Synapse Analytics serverless pools
Synapse Analytics pool capabilities
The serverless SQL pool
Querying data
Creating and using external tables
Securing data
Lab exercises
Query Parquet data
Create external tables to read data
Create views
Secure access to data
Configure role-based access control
Azure Databricks
Azure Databricks
Read and write data
Working with DataFrames
Advanced dataframe functions
Lab exercises
Explore data with DataFrames
Cache data for faster queries
Remove duplicate data
Working with date/time values
Remove and rename columns
Aggregate data
Apache Spark notebooks
Apache Spark in Azure Synapse Analytics
Ingest data into Spark notebooks
Transform data with DataFrames
Integrate Spark and SQL pools
Lab exercises
Explore data in Synapse Studio
Ingest data into a Spark notebook
Transform data with DataFrames
Integrate Spark and SQL pools
Ingest & load data warehouse data
Data loading best practices
Petabyte-scale data ingestion with Azure Data Factory
Lab exercises
Ingest data with Azure Synapse pipelines
Import data with Polybase and COPY
Use data loading best practices
Azure pipelines
Data Factory and Synapse pipelines
Code-free data transformation at scale
Lab exercises
Transform data with Azure pipelines
Build a pipeline to load a malformed CSV file
Create a mapping data flow
Data orchestration in Azure pipelines
Orchestrate data movement & transformation
Set up linked services
Execute notebooks from a pipeline
Lab exercises
Integrate data from notebooks in an Azure Data Factory or Synapse pipeline
End-to-end security
Secure a data warehouse
Configure & manage secrets in Key Vault
Implement compliance controls
Lab exercises
Secure Synapse Analytics infrastructure
Secure workspace & managed services
Secure workspace data
Hybrid Transactional Analytical Processing (HTAP)
Designing HTAP solutions
Configure HTAP in Cosmos DB
Query Cosmos with a Spark pool
Query Cosmos with a SQL pool
Lab exercises
Configure HTAP in Cosmos DB
Query Cosmos with Apache Spark
Query Cosmos with serverless SQL pools
Azure Stream Analytics
Azure Event Hub
Azure Stream Analytics
Ingest data with Stream Analytics
Lab exercises
Process real-time data
Using windowing functions
Scaling Stream Analytics jobs
Repartitioning input streams
Real-time data in Azure Databricks
Process real-time data with Databricks
Lab exercises
Explore structured streaming
Stream a file to HDFS
Using sliding windows
Applying watermarking
Connecting to Event Hubs
Book a Classroom Training
Please use the form below to book a call with me to set up your classroom training. We’ll discuss your business requirements, team size, and preferred location of the training (online or on-site) and make sure you get what you need. A typical classroom training can usually be scheduled within 30 days and can accomodate up to 15 people on-site and 30 people online.
Looking For Something Else?
CHECK OUT MY OTHER DATA TRAINING
Is this training course not exactly what you’re looking for? No problem, I have many other data training courses in my catalog. Take a look at these alternatives.
Adam Lindqvist
Frequently Asked Questions
- Bespoke Training
- Microsoft Training
- 1-on-1
- Classroom
What is a bespoke training?
An bespoke training is an in-house developed training that teaches unique skills not covered in official Microsoft training courses. You can learn about AI and machine learning, how to develop leadership skills and prepare for senior IT roles, how to improve your code quality with robust software design patterns, how to write high-performance C# code… and much more!
What's included in a bespoke training?
How long do I have access to the training content?
You have lifetime access to all training content.
How can I attend a bespoke training?
You can either participate in a 1-on-1 training with me and work through the lectures at your own pace and in your own time with me supporting you through chat or video calls. Or you can join a classroom training where I will present the training lectures live and guide you through the lab exercises in a multi-day session.
What is a Microsoft training?
What's included in a Microsoft training?
How long do I have access to a Microsoft training?
How can I attend a Microsoft training?
What is 1-on-1?
How am I supported in a 1-on-1 training?
Who should attend a 1-on-1 training?
My colleagues and I want to sign up as a team and learn together. Is this possible?
What is a classroom training?
A classroom training is a live event in which I will present the training lectures, help you complete the lab exercises and get you ready for the certification exam. Classroom trainings are conducted online in full-day Microsoft Teams calls held during business hours in the Central European timezone. You will be sharing the classroom with other students and learn together as a group.
When and where is classroom training conducted?
Classroom trainings are conducted online during Central European business hours. You will receive a Microsoft Teams link when you sign up for a class. Please note that classroom trainings can also be held on-site at your place of work. Please book a discovery call with me if you're interested, and we can discuss your requirements.
How am I supported in a classroom training?
I will continuously support you live, because we'll both be in the same virtual classroom together.
Who should attend a classroom training?
A classroom training is ideal for tech professionals who can commit to full days of learning and want to learn together as a group.
My colleagues and I want to sign up as a team and learn together. Is this possible?
Yes, absolutely. Please book a discovery call with me to discuss your requirements. I can offer group discounts to business teams.