Training The Digital Workforce of Tomorrow.
DP-203T00 | Data Engineering on Microsoft Azure

DP-203T00

DP-203

4 Day(s)

Instructor-Led Training

from SGD $2600*

Course Schedules

05 Feb 2024 - 08 Feb 2024
15 Apr 2024 - 18 Apr 2024
18 Jun 2024 - 21 Jun 2024
05 Aug 2024 - 08 Aug 2024
02 Oct 2023 - 05 Oct 2023

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

In this course, the student will learn about the data engineering as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. Students will begin by understanding the core compute and storage technologies that are used to build an analytical solution. The students will learn how to interactively explore data stored in files in a data lake. They will learn the various ingestion techniques that can be used to load data using the Apache Spark capability found in Azure Synapse Analytics or Azure Databricks, or how to ingest using Azure Data Factory or Azure Synapse pipelines. The students will also learn the various ways they can transform the data using the same technologies that is used to ingest data. They will understand the importance of implementing security to ensure that the data is protected at rest or in transit. The student will then show how to create a realtime analytical system to create real-time analytical solutions.

Who Should Enrol?

The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course data analysts and data scientists who work with analytical solutions built on Microsoft Azure.

Course Outcome

• Explore compute and storage options for data engineering workloads in Azure
• Run interactive queries using serverless SQL pools
• Perform data Exploration and Transformation in Azure Databricks
• Explore, transform, and load data into the Data Warehouse using Apache Spark
• Ingest and load Data into the Data Warehouse
• Transform Data with Azure Data Factory or Azure Synapse Pipelines
• Integrate Data from Notebooks with Azure Data Factory or Azure Synapse Pipelines
• Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
• Perform end-to-end security with Azure Synapse Analytics
• Perform real-time Stream Processing with Stream Analytics
• Create a Stream Processing Solution with Event Hubs and Azure Databricks

LEARNING PATHWAY

Module 1: Explore compute and storage options for data engineering workloads

Module 2: Run interactive queries using Azure Synapse Analytics serverless SQL pools

Module 3: Data exploration and transformation in Azure Databricks

Module 4: Explore, transform, and load data into the Data Warehouse using Apache Spark

Module 5: Ingest and load data into the data warehouse

Module 6: Transform data with Azure Data Factory or Azure Synapse Pipelines

Module 7: Orchestrate data movement and transformation in Azure Synapse Pipelines

Module 8: End-to-end security with Azure Synapse Analytics

Module 9: Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link

Module 10: Real-time Stream Processing with Stream Analytics

Module 11: Create a Stream Processing Solution with Event Hubs and Azure Databricks

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

DP-300_administering-microsoft-azure-sql-solutions_banner
DP-300T00 | Administering Microsoft Azure SQL Solutions
wsq-ms-azure-admin
AVWSQ-AZ-104 | WSQ - Microsoft Azure Administrator
Designing-Microsoft-Azure-Infrastructure-Solutions
AZ-305T00 | Designing Microsoft Azure Infrastructure Solutions
Azure-developing-solutions-for-microsoft-azure
AZ-204T00 | Developing Solutions for Microsoft Azure
Automating Administration with PowerShell
AZ-040T00 | Automating Administration with PowerShell
Configuring Windows Server Hybrid Advanced Services
AZ-801T00 | Configuring Windows Server Hybrid Advanced Services