Data Engineering On Microsoft Azure DP-203 Certification Overview

Data Engineering on Microsoft Azure DP203 Course Outline

Module 1: Introduction to Data Engineering on Azure

  • Introduction
  • What Is Data Engineering?
  • Important Data Engineering Concepts
  • Data Engineering in Microsoft Azure

Module 2: Introduction to Azure Data Lake Storage Gen2

  • Introduction
  • Understand Azure Data Lake Storage Gen2
  • Enable Azure Data Lake Storage Gen2 in Azure Storage
  • Compare Azure Data Lake Store to Azure Blob Storage
  • Understand the Stages for Processing Big Data
  • Use Azure Data Lake Storage Gen2 in Data Analytics Workloads

Module 3: Introduction to Azure Synapse Analytics

  • Introduction
  • What is Azure Synapse Analytics?
  • How Azure Synapse Analytics Works?
  • When to Use Azure Synapse Analytics?
  • Exercise: Explore Azure Synapse Analytics

Module 4: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

  • Introduction
  • 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 5: Use Azure Synapse Serverless SQL Pools to Transform Data in a Data Lake

  • Introduction
  • Transform Data Files with the CREATE EXTERNAL TABLE AS SELECT Statement
  • Encapsulate Data Transformations in a Stored Procedure
  • Include a Data Transformation Stored Procedure in a Pipeline
  • Exercise: Transform Files Using a Serverless SQL Pool

Module 6: Create a Lake Database in Azure Synapse Analytics

  • Introduction
  • Understand Lake Database Concepts
  • Explore Database Templates
  • Create a Lake Database
  • Use a Lake Database
  • Exercise: Analyse Data in a Lake Database

Module 7: Analyse Data with Apache Spark in Azure Synapse Analytics

  • Introduction
  • Get to Know Apache Spark
  • Use Spark in Azure Synapse Analytics
  • Analyse Data with Spark
  • Visualise Data with Spark
  • Exercise: Analyse Data with Spark

Module 8: Transform Data with Spark in Azure Synapse Analytics

  • Introduction
  • Modify and Save Dataframes
  • Partition Data Files
  • Transform Data with SQL
  • Exercise: Transform Data with Spark in Azure Synapse Analytics

Module 9: Use Delta Lake in Azure Synapse Analytics

  • Introduction
  • Understand Delta Lake
  • Create Delta Lake Tables
  • Create Catalog Tables
  • Use Delta Lake with Streaming Data
  • Use Delta Lake in a SQL Pool
  • Exercise: Use Delta Lake in Azure Synapse Analytics

Module 10: Analyse Data in a Relational Data Warehouse

  • Introduction
  • Design a Data Warehouse Schema
  • Create Data Warehouse Tables
  • Load Data Warehouse Tables
  • Query a Data Warehouse
  • Exercise: Explore a Data Warehouse

Module 11: Load Data into a Relational Data Warehouse

  • Introduction
  • Load Staging Tables
  • Load Dimension Tables
  • Load Time Dimension Tables
  • Load Slowly Changing Dimensions
  • Load Fact Tables
  • Perform Post-Load Optimisation
  • Exercise: Load Data into a Relational Data Warehouse

Module 12: Build a Data Pipeline in Azure Synapse Analytics

  • Introduction
  • Understand Pipelines in Azure Synapse Analytics
  • Create a Pipeline in Azure Synapse Studio
  • Define Data Flows
  • Run a Pipeline
  • Exercise: Build a Data Pipeline in Azure Synapse Analytics

Module 13: Use Spark Notebooks in an Azure Synapse Pipeline

  • Introduction
  • Understand Synapse Notebooks and Pipelines
  • Use a Synapse Notebook Activity in a Pipeline
  • Use Parameters in a Notebook
  • Exercise: Use an Apache Spark Notebook in a Pipeline

Module 14: Plan Hybrid Transactional and Analytical Processing Using Azure Synapse Analytics

  • Introduction
  • Understand Hybrid Transactional and Analytical Processing Patterns
  • Describe Azure Synapse Link

Module 15: Implement Azure Synapse Link with Azure Cosmos DB

  • Introduction
  • Enable Cosmos DB Account to Use Azure Synapse Link
  • Create an Analytical Store Enabled Container
  • Create a Linked Service for Cosmos DB
  • Query Cosmos DB Data with Spark
  • Query Cosmos DB with Synapse SQL
  • Exercise: Implement Azure Synapse Link for Cosmos DB

Module 16: Implement Azure Synapse Link for SQL

  • Introduction
  • What Is Azure Synapse Link for SQL?
  • Configure Azure Synapse Link for Azure SQL Database
  • Configure Azure Synapse Link for SQL Server 2022
  • Exercise: Implement Azure Synapse Link for SQL

Module 17: Get Started with Azure Stream Analytics

  • Introduction
  • Understand Data Streams
  • Understand Event Processing
  • Understand Window Functions
  • Exercise: Get Started with Azure Stream Analytics

Module 18: Ingest Streaming Data Using Azure Stream Analytics and Azure Synapse Analytics

  • Introduction
  • Stream Ingestion Scenarios
  • Configure Inputs and Outputs
  • Define a Query to Select, Filter, and Aggregate Data
  • Run a Job to Ingest Data
  • Exercise: Ingest Streaming Data into Azure Synapse Analytics

Module 19: Visualize Real-Time Data with Azure Stream Analytics and Power BI

  • Introduction
  • Use a Power BI Output in Azure Stream Analytics
  • Create a Query for Real-Time Visualization
  • Create Real-Time Data Visualizations in Power BI
  • Exercise: Create a Real-Time Data Visualization

Module 20: Introduction to Microsoft Purview

  • Introduction
  • What Is Microsoft Purview?
  • How Microsoft Purview Works?
  • When to Use Microsoft Purview?

Module 21: Integrate Microsoft Purview and Azure Synapse Analytics

  • Introduction
  • Catalog Azure Synapse Analytics Data Assets in Microsoft Purview
  • Connect Microsoft Purview to an Azure Synapse Analytics Workspace
  • Search a Purview Catalog in Synapse Studio
  • Track Data Lineage in Pipelines
  • Exercise: Integrate Azure Synapse Analytics and Microsoft Purview

Module 22: Explore Azure Databricks

  • Introduction
  • Get Started with Azure Databricks
  • Identify Azure Databricks Workloads
  • Understand Key Concepts
  • Exercise: Explore Azure Databricks

Module 23: Use Apache Spark in Azure Databricks

  • Introduction
  • Get to Know Spark
  • Create a Spark Cluster
  • Use Spark in Notebooks
  • Use Spark to Work with Data Files
  • Visualise Data
  • Exercise: Use Spark in Azure Databricks

Module 24: Run Azure Databricks Notebooks with Azure Data Factory

  • Introduction
  • Understand Azure Databricks Notebooks and Pipelines
  • Create a Linked Service for Azure Databricks
  • Use a Notebook Activity in a Pipeline
  • Use Parameters in a Notebook
  • Exercise: Run an Azure Databricks Notebook with Azure Data Factory

Show moredowndown

Who should attend this Data Engineering on Microsoft Azure DP203 Training Course?

The Data Engineering on Microsoft Azure DP-203 Training Course is designed for individuals who want to learn how to design and implement data solutions using Microsoft Azure's data engineering services and tools. This Microsoft Training Course can be beneficial to a wide range of professionals, including:

  • Data Engineers
  • Database Administrators
  • Data Integration Specialists
  • Data Architects
  • Database Developers
  • Technical Consultants
  • BI (Business Intelligence) Developers

Prerequisites of the Data Engineering on Microsoft Azure DP203 Training Course

The required prerequisites for attending the Data Engineering on Microsoft Azure DP203 Training Course are to have a knowledge of cloud computing with core data concepts and professional experience with data solutions necessary and also completing AZ-900 Azure Fundamentals and DP-900 Microsoft Azure Data Fundamentals would be beneficial for the delegates.

Data Engineering on Microsoft Azure DP-203 Course Overview

This Data Engineering on Microsoft Azure DP-203 Training Course provides a comprehensive understanding of this vital discipline. With an emphasis on the power of Microsoft Azure, this course equips professionals with the knowledge and skills necessary to harness, process, and manage data effectively. As data becomes increasingly central to decision-making across various industries, this course serves as a gateway to harness the potential of Azure for Data Engineering solutions.

Proficiency in designing and implementing Microsoft Azure networking solutions is essential for professionals aspiring to excel in roles related to network architecture, cloud infrastructure, and IT management. This Microsoft Azure Certification Course is particularly beneficial for network engineers, cloud architects, IT managers, and system administrators. As organisations increasingly migrate to cloud-based solutions, this Azure Certification course becomes imperative.

The Knowledge Academy's 4-day training on Designing and Implementing Microsoft Azure Networking Solutions AZ700 offers an accelerated path to expertise in Azure networking. Delegates will engage in hands-on learning, gaining practical experience with Azure tools to design and implement effective networking solutions. This course serves as a key entry point for professionals seeking to leverage the power of Azure for networking solutions.

Course Objectives

  • To understand Azure data services and their role in Data Engineering
  • To design and implement data storage solutions using Azure Data Storage Services
  • To develop data processing solutions using Azure Data Factory
  • To implement data transformation and data integration techniques
  • To ensure data security and compliance within Azure data solutions
  • To optimise and monitor data pipelines for efficiency
  • To leverage Azure Databricks for Data Analytics and Machine Learning

After completing this Microsoft Azure Certification Course, delegates will gain the practical skills and knowledge to harness the power of Microsoft Azure for effective Data Engineering solutions.

Show moredowndown

What’s included in this Data Engineering on Microsoft Azure DP203 Training Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Data Engineering on Microsoft Azure DP203 Certificate
  • Digital Delegate Pack
Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.

Show moredowndown

Why choose us

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Data Engineering On Microsoft Azure DP-203 Certification. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

live-classes

Live classes

Join a scheduled class with a live instructor and other delegates.

interactive

Interactive

Engage in activities, and communicate with your trainer and peers.

best-trainers

Global Pool of the Best Trainers

We handpick from a global pool of expert trainers for our Online Instructor-led courses.

enterprise

Expertise

With 10+ years of quality, instructor-led training, we equip professionals with lasting skills for success.

global

Global Reach

With classes running in all timezones, access any of our courses and course material from anywhere, anytime.

Unlock your potential with The Knowledge Academy's Data Engineering On Microsoft Azure DP-203 Certification, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Experience the most sought-after learning style with The Knowledge Academy's Data Engineering On Microsoft Azure DP-203 Certification. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Data Engineering On Microsoft Azure DP-203 Certification sessions.

best_trainers

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

value_for_money

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Streamline large-scale training requirements with The Knowledge Academy’s In-house/Onsite Data Engineering On Microsoft Azure DP-203 Certification at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

tailored_learning_experience

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

Our Data Engineering On Microsoft Azure DP-203 Certification offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

monitor_progress

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

What our customers are saying

Data Engineering On Microsoft Azure DP-203 Certification FAQs

Microsoft Azure is a cloud computing platform and set of services provided by Microsoft, offering solutions for computing, storage, networking, databases, analytics, and more.
The required prerequisites for attending the Data Engineering on Microsoft Azure DP203 Training Course are to have a knowledge of cloud computing with core data concepts and professional experience with data solutions.
This course is ideal for data engineers, data architects, database administrators, and IT professionals seeking to enhance their skills in designing and implementing data solutions on Microsoft Azure.
This training course will equip you with the knowledge and skills to design and implement data solutions using Microsoft Azure services, enabling you to leverage the power of the cloud for data management, processing, and analytics.
The duration of this Azure DP 203 Course is 3 days.
Participants will learn to design and implement data storage solutions, data processing solutions, and data security and compliance solutions on Microsoft Azure. The course covers various Azure services such as Azure Data Lake Storage, Azure Databricks, Azure Synapse Analytics, and more.
Yes, this training course is accredited and aligned with the objectives of the Microsoft DP-203 certification exam.
Data Engineering on Microsoft Azure DP-203 Certification holds relevance across industries such as finance, healthcare, retail, manufacturing, and technology, where effective data management and analytics are critical for business success.
Yes, individuals with non-technical backgrounds can benefit from this certification by gaining valuable skills in data engineering and cloud computing, opening up opportunities for career advancement in roles such as data analyst, business analyst, or project manager.
After completing the course and obtaining the DP-203 certification, career opportunities may include data engineer, data architect, cloud engineer, data scientist, or Azure solutions architect, with demand across industries for professionals skilled in designing and implementing data solutions on Microsoft Azure.
The Knowledge Academy stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking Data Engineering on Microsoft Azure DP-203 Certification.
The training fees for Data Engineering On Microsoft Azure DP-203 Certificationin the United Kingdom starts from £2495
The Knowledge Academy is the Leading global training provider for Data Engineering On Microsoft Azure DP-203 Certification.
Show more down

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Azure Training

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
backBack to course information

Microsoft Azure Data Engineer Associate Certification

Save upto 40%
2 courses

Total without package:  £3790

Package price:  £2295 (Save £1495)

Purchase now
cross

BIGGEST
Cyber Monday SALE!

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.