McAfee-Secured Website

Course name Microsoft DP-203: Data Engineering on Microsoft Azure

Corresponding Certification: Microsoft Certified: Azure Data Engineer Associate

DP-203 Video Course

DP-203 Video Course is developed by Microsoft Professionals to help you pass the DP-203 exam.

You Will Learn:

Was 43.99 USD
Now 39.99 USD

Description

This course will improve your knowledge and skills required to pass Data Engineering on Microsoft Azure exam.

Curriculum For This Course

  • 1. Introduction 1 Videos 00:05:00
    • How to keep using Azure Portal for FREE after 12 months? 5:00
  • 2. Design Azure Data Storage Solutions (40-45%) 1 Videos 00:04:00
    • SECTION 1 - Introduction and overview 4:00
  • 3. Recommend an Azure data storage solution based on requirements 7 Videos 00:51:00
    • Learning Objectives 2:00
    • Data Types 12:00
    • Data Storage Types 18:00
    • Select Azure Store for application 4:00
    • Azure Data Platform Architecture 6:00
    • Design and Troubleshoot Partition Distribution type 6:00
    • Learning Outcome and Checklist 3:00
  • 4. Design non-relational cloud data stores 21 Videos 02:44:00
    • Learning Objectives 3:00
    • What is partitioning and partition key 6:00
    • Dedicated vs Shared throughput 7:00
    • Avoiding hot partition 5:00
    • Single partition vs Cross partition 4:00
    • Composite Key 3:00
    • Partition key best practice 8:00
    • Globally Distribution 13:00
    • Multi Master 9:00
    • Manual vs Automatics Failover 8:00
    • Throughput and request units 9:00
    • Cosmos DB - 5 consistent levels 14:00
    • Cosmos DB Multi Model 5 APIs 12:00
    • How Data Lake Gen 2 Evolved? 5:00
    • Data Lake vs Blob 5:00
    • High Availability vs Disaster Recovery 7:00
    • RTO and RPO 4:00
    • Azure Storage - HA and DR Options 12:00
    • Cosmos DB - HA and DR Options 17:00
    • Scenarios - Designing a solution for CosmosDB vs Data Lake vs Blob Storage 10:00
    • Learning Outcome and Checklist 3:00
  • 5. Design relational cloud data stores 14 Videos 02:06:00
    • Learning Objectives 4:00
    • Purchasing models and Service Tier 13:00
    • Storage and Sharding patterns 5:00
    • Data Distribution and Distributing Keys 6:00
    • Data Types and Table Types 5:00
    • Partitioning 5:00
    • Scaling Azure Database 11:00
    • Scaling Azure Datawarehouse 3:00
    • Azure SQL Database High Availability and Disaster Recovery options 29:00
    • Azure SQL Database Backup and Restore 19:00
    • Azure SQL Datawarehouse Backup and Restore 11:00
    • Azure SQL Database vs Data Warehouse 3:00
    • Scenarios - Designing for SQL Database vs Data warehouse 6:00
    • Learning Outcome and Checklist 6:00
  • 6. Design Data Processing Solutions (25-30%) 1 Videos 00:03:00
    • SECTION 2 - Introduction and Overview 3:00
  • 7. Design batch processing solutions 10 Videos 01:34:00
    • Learning Objectives 4:00
    • Design Batch Processing Solutions using Data Factory and DataBricks 17:00
    • Data Ingestion Methods 13:00
    • Tools to Ingest Data 11:00
    • Ingest using Portal and SE 9:00
    • Demo: Ingest Data using azcopy 6:00
    • Demo: Blob to Gen 2 9:00
    • Demo: SQL Server to Gen2 14:00
    • Demo: Amazon S3 to Gen2 8:00
    • Learning Outcome and Checklist 3:00
  • 8. Design real-time processing solutions 11 Videos 00:58:00
    • Learning Objectives 2:00
    • Real Time Processing 12:00
    • Azure Streaming Analytics Service 6:00
    • Streaming Analytics - What is time windowing 2:00
    • Tumbling Window 3:00
    • Hopping Window 2:00
    • Sliding Window 2:00
    • Session Window 6:00
    • Design and Provision Compute Resources 9:00
    • Lambda Architecture 10:00
    • Learning Outcome and Checklist 4:00
  • 9. Design for Data Security and Compliance (25-30%) 1 Videos 00:02:00
    • SECTION 3 - Introduction and Overview 2:00
  • 10. Design security for source data access 7 Videos 00:32:00
    • Learning Objectives 2:00
    • Plan for Secure Endpoints (Public/Private) 7:00
    • Access Keys 3:00
    • Shared Access Signature (SAS) 7:00
    • Active Directory (Azure AD) 5:00
    • Role Based Access Control (RBAC) 6:00
    • Learning Outcome and Checklist 2:00
  • 11. Design security for data policies and standards 7 Videos 01:18:00
    • Learning Objectives 2:00
    • Encrypt data at rest and in transit 26:00
    • Data Auditing 4:00
    • Data Masking 21:00
    • Data Privacy and Data Classification 7:00
    • Data Retention and Archiving Strategy 14:00
    • Learning Outcome and Checklist 4:00