Data Engineering on Microsoft Azure DP203 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 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 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  
  • Digital Delegate Pack

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 DP203. 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.

Unlock your potential with The Knowledge Academy's Data Engineering on Microsoft Azure DP203, 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 DP203. 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 DP203 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 DP203 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 DP203 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 DP203 FAQs

Microsoft Azure is a cloud computing service developed by Microsoft, allowing users to build, manage, and deploy applications on a massive network using their own choice of tools and frameworks.
There are no prerequisites to attend this Data Engineering on Microsoft Azure DP-203 training course. However, delegates having knowledge of data processing languages such as SQL, Python, or Scala can get more out of this certification training.
This Data Engineering on Microsoft Azure DP-203 training course is suitable for all individuals who want to enhance knowledge in optimising data storage and data processing.
After attending this training course, you can work as an Azure Data Engineer to help organisations transform raw data into cleansed and enhanced datasets for analysis. Azure Data Engineers also work to find trends in data sets and develop algorithms.
Data Engineering on Microsoft Azure DP-203 training helps you in several ways, such as getting a reputed job or upgrading your designation, hike in salary, and opening your ways to enter into the Microsoft Professional community.
This course is 3 days.
In this Data Engineering on Microsoft Azure DP-203 training course, delegates will learn various basic and advanced topics, such as designing a partitioning strategy, implementing of serving layer, designing and developing a batch processing solution, managing the batches and pipelines, designing security for data policies and standards, monitoring data storage and data processing.
Yes, this Data Engineering on Microsoft Azure DP-203 training course is fully accredited by Microsoft on behalf of Microsoft Gold Partner.
The price for Data Engineering on Microsoft Azure DP203 certification in the United Kingdom starts from £2495
The Knowledge Academy is the Leading global training provider for Data Engineering on Microsoft Azure DP203.
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

Looking for more information on Microsoft Azure Training?

backBack to course information

Microsoft Azure Data Engineer Associate Certification

Save upto 40%
2 courses

Total without package:  £3290

Package price:  £1995 (Save £1295)

Purchase now
cross

Unlock Exceptional Learning at Unbeatable Prices!

Special Discounts

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.