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: Azure Developer

Format: 1-on-1 or 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: Slack channel, video support calls, or live classroom support

Associated certification: 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

Pricing

The 1-on-1 training is a self-paced training just for you where you can learn at your own pace and in your own time. You can choose the level of support you prefer: we can either use Slack or set up an unlimited number of Microsoft Teams video calls.

The group classroom training is a multi-day training event conducted online or at your place of work. I will be in the classroom with you and your team providing live lessons and live support. We train together as a group during business hours.

1-ON-1 TRAINING
with Chat support

€350

Personal 1-on-1 training with unlimited chat support

Training manual

Online labs

Azure cloud credits

Practice exam

Exam voucher

Chat support

1-ON-1 TRAINING
with Video support

€850

Personal 1-on-1 training with unlimited video support

Training manual

Online labs

Azure cloud credits

Practice exam

Exam voucher

Unlimited video support

GROUP TRAINING
with Live support

€1450/person

Group classroom training with live lessons and lab assignments

Training manual

Online labs

Azure cloud credits

Practice exam

Exam voucher

Live classroom training (4 days)

All listed prices are ex EU VAT. Non-Dutch EU businesses can waive the VAT by providing their tax number during checkout.

Book a Classroom Training

Classroom trainings are conducted during business hours and hosted online or on-site at your place of work. All students need to participate is a laptop, a web browser, and Microsoft Teams.

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

Is this training course not exactly what you’re looking for? No problem, I have many other cloud training courses in my catalog. Take a look at these alternatives.
I have learned so much from your courses, looking forward to more great content. Keep up the amazing work!

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?
Each bespoke training includes prerecorded video content, text lectures, quizzes, and homework assignments.
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?
A Microsoft official training is a training course straight from the official Microsoft training catalog. These courses will prepare you for Microsoft certification exams and include an exam voucher.
What's included in a Microsoft training?
You will receive a course manual, access to an online lab environment, an Azure Pass with cloud credit, a practice exam, and an exam voucher.
How long do I have access to a Microsoft training?
You have unlimited access to the training manual, 180 days access to the online lab environment, and 15 days of access to free Azure credit. The exam voucher is valid for a year.
How can I attend a Microsoft 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 1-on-1?
In a 1-on-1 training, you study the training lectures and work on the lab assignments in your own time and at your own pace. You can spend as many or as little hours per week as you want on the training. This training format is ideal for tech professionals who have irregular work hours and cannot commit to a classroom training.
How am I supported in a 1-on-1 training?
I will support you in a private Slack channel. You can also book an unlimiterd number of 1-hour video support calls with me. I will support you with the training lectures and lab exercises and get you ready for certification exams.
Who should attend a 1-on-1 training?
A 1-on-1 training is ideal for tech professionals who want to set their own learning pace and prefer a healthy mix of guidance and support throughout the training to learn the content and complete the lab exercises.
My colleagues and I want to sign up as a team and learn together. Is this possible?
No, a 1-on-1 training is only for individual students who each learn at their own pace. Please consider a classroom training instead.
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.