Exam DP-203: Microsoft Azure Data Engineer Associate Crash Course
Published by O'Reilly Media, Inc.
Data engineering on Microsoft Azure
Microsoft Azure data engineers use Azure Cosmos DB, Azure SQL Database, Azure Synapse Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage to design and implement data solutions. To become a Microsoft Certified Azure Data Engineer Associate, you’ll need to pass exam DP-203: Data Engineering on Microsoft Azure, which tests a candidate’s ability to design and implement data solutions on Microsoft Azure.
In this crash course, experienced trainer Reza Salehi walks you through the objectives of the DP-203. As you prepare for the exam (following the certification guide published by Microsoft), you’ll gain a holistic understanding of the Microsoft data engineer landscape and get acquainted with Azure’s data platforms at a high level.
What you’ll learn and how you can apply it
By the end of this live online course, you’ll understand:
- How the Azure role-based certifications work
- The topics most likely to appear on the DP-203 exam
- How to do the work of a Microsoft Azure Data Engineer Associate
And you’ll be able to:
- Prepare for the DP-203 certification exam
- Work toward Azure certification to prove your skills and increase your professional credibility
- Use Azure services to implement data solutions
This live event is for you because...
- You’re a developer or data architect with passion for data solutions and pipelines.
- You work or will work with Microsoft Azure.
- You want to become a Microsoft Certified Azure Data Engineer Associate.
Prerequisites
- An Azure account (Free tier is fine.)
- Familiarity with the Azure Portal and Azure data services, such as Azure Cosmos DB, Azure SQL Database, Azure Synapse Analytics (formerly Azure SQL DW), Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage
- A basic understanding of relational and nonrelational data models
Recommended preparation:
- Take Getting Started with Azure (live online training course with Tiago Costa)
- Take Microsoft Azure Data Fundamentals Crash Course (live online training course with Emilio Melo)
- Take Exam DP-900: Microsoft Azure Data Fundamentals Crash Course (live online training course with Tim Warner)
Recommended follow-up:
- Watch Professional Azure SQL Database Administration (video)
- Read Learning Microsoft Azure Storage (book)
- Watch Azure MasterClass: Analyze Data With Azure Stream Analytics (video)
- Watch Getting Started with Microsoft Cosmos DB Using C#: Cloud Database Support for .NET Applications (video)
- Take Exam AZ-304: Microsoft Azure Architect Design Crash Course (live online training course with Tim Warner)
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
DP-203 overview (10 minutes)
- Presentation: What’s covered on the DP-203 certification exam?
Design and implement data storage (70 minutes)
- Presentation and demos: Designing and implementing data storage; designing a partition strategy; designing the serving layer; implementing the serving layer
- Q&A
Break (5 minutes)
Design and develop data processing (60 minutes)
- Presentation and demos: Ingesting and transforming data; designing and developing a batch processing solution; designing and developing a stream processing solution; managing batches and pipelines
- Q&A
Break (5 minutes)
Design and implement data security (45 minutes)
- Presentation: Designing security for data policies and standards; implementing data security
- Q&A
Break (5 minutes)
Monitor and optimize data storage and data processing (30 minutes)
- Presentation and demos: Monitoring data storage and data processing; optimizing and troubleshooting data storage and data processing
- Q&A
What to expect in the exam (10 minutes)
- Presentation: DP-203 certification exam length, topics, etc.; registering for the exam; what’s covered on the DP-203 certification exam; what roles this certification opens up for candidates
- Q&A
Your Instructor
Reza Salehi
Reza Salehi is a consultant, trainer, author and industry expert with over two decades of experience in the professional IT field. Reza has trained thousands of students through various instructional formats, including live sessions, on-demand courses, and in-person training. He is the author of O'Reilly's Azure Cookbook and a 15-year Microsoft Certified Trainer. Reza helps his clients to adopt Microsoft Azure in their solutions to meet the functional, cost, security, and compliance requirements.