Azure Data Engineer Course

Overview

Learning Objectives

In most organizations, a data engineer is the primary role responsible for integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions. An Azure data engineer also helps ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints.

Prerequisites

Before starting this learning path, you should have completed the Microsoft Azure Data Fundamentals certification or have equivalent knowledge and experience.

Course Outline

Module 1. Get started with data engineering on Azure

What is data engineering

Important data engineering concepts

Data engineering in Microsoft Azure

Module 2. Build data analytics solutions using Azure Synapse serverless SQL pools

Understand Azure Synapse serverless SQL pool capabilities and use cases

Query files using a serverless SQL pool

Create external database objects

Exercise - Query files using a serverless SQL pool

Module 3. Build data ana Perform data engineering with Azure Synapse Apache Spark Pools

Get to know Apache Spark

Use Spark in Azure Synapse Analytics

Analyze data with Spark

Visualize data with Spark

Exercise - Analyze data with Spark

Module 4. Transfer and transform data with Azure Synapse Analytics pipelines

Get to know Apache Spark

Use Spark in Azure Synapse Analytics

Analyze data with Spark

Visualize data with Spark

Exercise - Analyze data with Spark

Module 5. Implement a Data Analytics Solution with Azure Synapse Analytics

What is Azure Synapse Analytics

How Azure Synapse Analytics works

When to use Azure Synapse Analytics

Exercise - Explore Azure Synapse Analytics

Module 6. Work with Data Warehouses using Azure Synapse Analytics

Design a data warehouse schema

Create data warehouse tables

Load data warehouse tables

Query a data warehouse

Exercise - Explore a data warehouse

Module 7.Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics

Understand hybrid transactional and analytical processing patterns

Describe Azure Synapse Link

. . .