Hi, 
DP-203: Data Engineering on Microsoft Azure
Minimum cohort size: 10 learners
Book a free consultation to enroll & feel free to bring a friend along!
Course
DP-203: Data Engineering on Microsoft Azure
Learn how Azure services work together to enable you to design, implement, operationalize, monitor, optimize, and secure data solutions on Microsoft Azure.
Benefit from instructor-led preparation for the DP-203 certification exam with tips, tricks, guidance, and mentored support.
Online Live Classes
Intermediate Level
Mentor Support
AzureDP-203, is a four-day Data Engineering on Azure course designed for data professionals who want to learn about analytical solutions using Azure data platform technologies.
In this course, you will learn about data engineering with respect to the core compute and storage technologies that are used to build an analytical solution. You will learn how to run interactive queries using serverless SQL pools in Azure Synapse Analytics, and how to perform data exploration and transformation in Azure Databricks and Apache Spark. You will be introduced to the best practices used for data loading in Azure Synapse Analytics. Plus, you will learn about performing petabyte-scale ingestion, working on code-free transformation, and data integration with Azure Data Factory.
You will also explore how to use Azure Synapse Analytics to orchestrate data movement, provide end-to-end security, and design Hybrid Transactional and Analytical Processing (HTAP). You will build your understanding of how to enable and configure Synapse link, and how to query the Azure Cosmos DB analytical store using Apache Spark and SQL serverless. And you will become familiar with how to use Event Hubs and Azure Databricks to create a stream processing solution.
Overall, this course will prepare you for taking the DP-203 certification exam -Microsoft Certified: Azure Data Engineer Associate. Entry for the exam is not included. However, you will get a clear overview of the Microsoft certification process, plus you will get lessons, tips, and useful information.
This course comprises eleven purposely designed modules that take you on a carefully defined learning journey.
It is an instructor-led course which runs to a fixed schedule, with set start and finish dates. It is driven forward by your instructor and features live sessions that are aired at a set time. You will, however, have time to complete certain activities at your own pace outside of the live sessions.
The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include reading material, hands-on labs, and online exam questions.
As part of our mentoring service you will have access to valuable guidance and support throughout the course. We provide a dedicated discussion space where you can ask questions, chat with your peers, and resolve issues.
Once you have successfully completed the course, you will earn your Certificate of Completion.
You will be able to:
- Design and implement data storage.
- Design and develop data processing.
- Design and implement data security.
- Monitor and optimize data storage and data processing.
- Data engineers.
- Data architects.
- Business intelligence professionals.
- Data analysts and data scientists who work with analytical solutions built on Microsoft Azure will also find this useful.
- Professionals who are looking to clear their DP-203 certification exam.
You should have these certifications before starting the course:
- AZ-900 - Azure Fundamentals
- DP-900 - Microsoft Azure Data Fundamentals
- Data Processing Experience: A general understanding of data storage and data processing is recommended but not required.
This course will help you to prepare for the DP-203: Data Engineering on Microsoft Azure exam.
It is ideal for individuals who want to understand the core compute and storage technologies that are used to build an analytical solution.
- You will explore integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions.
- You will learn how to ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a set of business requirements and constraints.
- You will explore Azure Databricks, Data Warehouse, Apache Spark, Azure Synapse, and Stream Analytics.
When you take this course, you will also get information and guidance on the Microsoft certification process, knowledge checks and practice questions, and useful tips on how to pass the exam.
Course Outline
Introduction
Grading Scheme
Pre-Requisite
Exam and Certification Details
About this module
What is data engineering
Important data engineering concepts
Data engineering in Microsoft Azure
Knowledge Check
About this module
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
Knowledge Check
About this module
What is Azure Synapse Analytics
How Azure Synapse Analytics works
When to use Azure Synapse Analytics
Exercise - Explore Azure Synapse Analytics
Unit
Knowledge Check
About this module
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
Knowledge Check
About this module
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
Knowledge Check
About this module
Understand lake database concepts
Explore database templates
Create a lake database
Use a lake database
Exercise - Analyze data in a lake database
Knowledge Check
About this module
Get to know Apache Spark
Use Spark in Azure Synapse Analytics
Analyze data with Spark
Visualize data with Spark
Exercise - Analyze data with Spark
Knowledge Check
About this module
Modify and save dataframes
Partition data files
Transform data with SQL
Exercise: Transform data with Spark in Azure Synapse Analytics
Knowledge Check
About this module
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
Knowledge Check
About this module
Design a data warehouse schema
Create data warehouse tables
Load data warehouse tables
Query a data warehouse
Exercise - Explore a data warehouse
Knowledge Check
About this module
Load staging tables
Load dimension tables
Load time dimension tables
Load slowly changing dimensions
Load fact tables
Perform post load optimization
Exercise - load data into a relational data warehouse
Knowledge Check
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
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
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
Instructions
Data Engineering on Microsoft Azure
null
Why Learn with SkillUp Online?
We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.
Reskilling into tech? We’ll support you.
Upskilling for promotion? We’ll help you.
Cross-skilling for your career? We’ll guide you.
Personalized Mentoring & Support
1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.
Practical Experience
Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.
Best-in-Class Course Content
Designed by the industry for the industry so you can build job-ready skills.
Job-Ready Skills Focus
Competency building and global certifications employers are actively looking for.
FAQs
The steps to gaining certification in Data Engineering on Microsoft Azure are as follows:
Step 1: Work with a Microsoft authorised training partner to complete the DP-203 recommended training. Microsoft has approved SkillUp Online as a training partner.
Step 2: Go to Microsoft's official website when you've finished the course. Register for the Data Engineering on Microsoft Azure test with Pearson VUE and schedule it.
Step 3: Take and pass the exam to become certified.
Candidates for the exam for DP-203: Data Engineering on Microsoft Azure should have a strong understanding of data processing languages like SQL, Python, and Scala, as well as parallel processing and data architecture patterns.
You must also be capable of integrating, transforming, and combining data from a variety of structured and unstructured data systems into a structure that can be used to construct analytics solutions.
The best method to prepare for an exam is to practise the skills that will be tested. To pass the Microsoft DP-203 certification exams, you need to get hands-on experience with Azure Data Engineering topics. However, there are related online courses and instructor-led courses that are designed to teach the skills needed to succeed in the job role, with a subset of those abilities being examined on the exam. For example - our Microsoft Certified Trainers (MCTs) will lead you through all of the modules if you sign up for SkillUp Online.
We recommend that you review the Skills Measured part of the Exam Details page to get a head start on your preparation. Compare your skills to what will be assessed in the exam. And then practice until you no longer face those difficulties.
When you register for your exam, you must pay the exam price to Microsoft. This can be done online through any payment mode (card/UPI/netbanking/ IMPS) and the fee is transferred directly to Microsoft.
To begin with, Azure data engineers assist stakeholders in gaining a better understanding of their data by allowing them to explore it.
Secondly, they utilize various tools and techniques to create and manage secure and compliant data processing pipelines.
Thirdly, they utilize Azure data services and languages for storing and producing analysis datasets.
Fourthly, they make sure that data pipelines and data stores are fast, efficient, well-organized, and dependable.
Type of certificate
Certificate of completion
About this course
11 Modules
03 Skills
Includes
Discussion Space
11 Knowledge checks
01 Practice exam
01 Lab
Create
Virtual machine
Azure SQL database
Azure Synapse Analytics workspace
Storage Account
Create data factory activities and pipelines
Exercises to explore
Add the storage client library to your app
Add Azure Storage configuration to your app
Connect your application to your Azure Storage account
Upload an image to your Azure Storage account
Get blob references
Integrate a Notebook within Azure Synapse Pipelines
You’ll learn with these experts
Microsoft
This course is led by experienced Microsoft Certified Trainers (MCTs).
Newsletters & Updates
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.