Learn your way! Get started

DP-203: Data Engineering in Microsoft Azure, Part 7 of 7: Optimize and Design Azure Data Solutions

with expert Eshant Garg


Watch trailer


Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack

Release date 4/18/2022
Level Advanced
Runtime 2h 56m
Closed captioning N/A
Transcript N/A
eBooks / courseware N/A
Hands-on labs N/A
Sample code Included
Exams Included


Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

The DP-203 Exam is measured in Four domains: Design and implement data storage (40-45%), Design and develop data processing (25-30%), Design and implement data security (10-15%), and Monitor and optimize data storage and data processing (10-15%). This course covers how to Design and Optimize Azure Data Solutions.

Prerequisites

AZ-900 Azure Fundamentals is very helpful but not required. A Candidate for the exam must have strong knowledge of data processing languages such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns.

Meet the expert

Eshant Garg has 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutions, Advanced Analytics, Design and Solution Architect, Reporting, and Cloud Computing Technologies (Azure & AWS). As a developer and architect, he has worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to fortune 500 companies.

Course outline



Module 18

Optimize Azure Data Solutions (25:20)
  • Introduction (00:08)
  • Learning Objectives (02:16)
  • Troubleshoot Data Partitioning Bottlenecks (06:53)
  • Optimization (05:35)
  • Optimizing Stream Analytics (10:19)
  • Summary (00:08)
Optimizing Synapse Analytics Service (23:57)
  • Introduction (00:08)
  • Optimizing Synapse Analytics Service (09:50)
  • Managing The Data Lifecycle (13:50)
  • Summary (00:08)
Types of Data (30:04)
  • Introduction (00:08)
  • Four Types Of Data (11:35)
  • Data Store Types (18:13)
  • Summary (00:08)

Module 19

Select Azure Store for Application (30:23)
  • Introduction (00:08)
  • Select Azure Store For Application (04:04)
  • Azure Data Platform Architecture (05:38)
  • Rto And Rpo (04:07)
  • Designing A Solution That Utilizes Cosmos Db Data (10:11)
  • Designing For Sql DB vs. Dw (06:04)
  • Summary (00:08)
Designing Batch Processing Solutions (29:56)
  • Introduction (00:08)
  • Designing Batch Processing Soluttions (16:54)
  • Data Ingestion Methods (12:46)
  • Summary (00:08)
Real Time Processing (20:24)
  • Introduction (00:08)
  • Real Time Processing (11:26)
  • Design And Provision Compute Resources (08:42)
  • Summary (00:08)
Lambda Architecture (16:49)
  • Introduction (00:08)
  • Lambda Architecture (09:36)
  • Planning For Secure Endpoints (06:56)
  • Summary (00:08)