Dp-203: Data Engineering On Microsoft Azure + Practice Tests (updated 11/2022)

Exam DP-203: Data Engineering on Microsoft Azure || 25+ hrs of videos || Practice Tests || 100% Syllabus || Demos

What you'll learn

Prepare to pass the Microsoft exam DP-203: Data Engineering on Microsoft Azure

Azure Storage (Blob Storage) (DP-203 Syllabus)

Azure Cosmos DB (DP-203 Syllabus)

Azure Data Lake (DP-203 Syllabus)

Azure SQL Database (DP-203 Syllabus)

Azure SQL Datawarehouse, Synapse (DP-200203 Syllabus)

Azure Data Factory (DP-203 Syllabus)

Azure Databricks (DP-203 Syllabus)

Azure Analytics Services (DP-203 Syllabus)

Azure Monitoring Service (DP-203 Syllabus)

Requirements

Basic Database Concepts

Enthusiasm and determination to clear DP-203 Exam

Description

This course is designed to help you and your team develop the skills necessary to pass the Microsoft Azure DP-203 certification exam.DP-203 is intended for Azure data engineers. This exam is all about implementation and configuration, so you need to know how to create, manage, use, and configure data services in the Azure portal. Why one should take DP-203 certification? According to the 2019 dice dot com report, there was an 88 percent year over year growth in the job postings for data engineers which was the highest growth rate among all the technological jobs. According to a recent study by pearsonvue, after taking the certification, 65% of people say they feel more confident in their current job. And 35% of people say that their salary has increased.Highlights of courseCourse is completely up-to-date with the latest syllabus released by Microsoft for DP-203Course covers 100% exam syllabusCourse include25+ hrs of content2 practice testQuiz - specially designed to clear concepts of objectives.Further study materialPPT and Demo resourcesCourse includes:Full lifetime access with all future updates30-Day Money-Back GuaranteeCertificate of course completionIntended AudienceAnyone who wants to prepare for DP-203 examAnyone who wants to become an Azure Data EngineerMicrosoft Azure Data EngineersMicrosoft Azure Data ScientistDatabase and BI developersDatabase AdministratorsData Analyst or similar profilesOn-Premises Database related profiles who want to learn how to implement these technologies in Azure Cloud.Anyone who wants to become an Azure Data EngineerPrerequisitesBasic Database conceptsLanguageEnglishPlease make sure you are comfortable in English, captions are not good enough to understand the course.Technologies covered in DP-203 certification ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Implement non-relational data storesNon-relational data stores (Blob Storage)Cosmos DBImplement relational data storesAzure SQL ServerAzure Synapse Analytics ServiceManage data securityData masking Data EncryptionDevelop batch processing solutionsAzure Data FactoryAzure DatabricksDevelop streaming solutionsAzure Streaming ServiceMonitor data storageMonitoring for Azure Blob StorageMonitoring for Azure Data LakeMonitoring for Azure SQL DatabaseMonitoring for Azure Synapse AnalyticsMonitoring for Azure Cosmos DBAzure Monitoring ServiceMonitor data processingMonitoring for Azure Data FactoryMonitoring for Azure DatabricksMonitoring for Azure Stream AnalyticsOptimize Azure data solutionsOptimize Azure Data LakeOptimize Azure Stream AnalyticsOptimize Azure Synapse AnalyticsOptimize Azure SQL DatabaseSome students FeedbackOne of the most amazing courses i have ever taken on Udemy. Please don't hesitate to take this course. The instructor is really professional and has a great experience about the subject of the course. - Khadija BadaryVery nicely explained most of the concepts. a must have course for beginners - Manoranjan SwainI appreciate this course explaining everything in great detail for a beginner. This will assist me in overcoming challenges at my work - Benjamin CurtisGood course for Beginners. Labs are really helpful to grasp the concept. Thank you - Sapna

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction and set expectation

Lecture 2 IMP: Everything you need to know about exam and this course

Lecture 3 IMP: Instructions

Lecture 4 How to keep using Azure Portal for FREE after 12 months?

Lecture 5 How to get FREE credits for Azure Portal

Lecture 6 PPT and Demo Resources

Lecture 7 Before you start…

Lecture 8 Practice Questions and Quizzes

Section 2: Introduction to Azure Cloud and Data Engineer Profile

Lecture 9 Absolute new to Cloud Computing? Here is FREE course for you

Lecture 10 Create Azure Subscription

Lecture 11 Azure Portal Overview

Lecture 12 Delete Resources and Set Budget

Lecture 13 How did Data Engineer Profile Evolve

Lecture 14 Data Engineer Role and Responsibility

Lecture 15 Data Engineer Technologies

Lecture 16 Summary of Data Engineering Profile and Technologies

Lecture 17 Further Study Material

Section 3: Data Storage: Non-Relational Data Stores

Lecture 18 Learning objectives

Lecture 19 Azure Storage Services Overview

Lecture 20 Demo Provision Azure Storage Account

Lecture 21 Data Redundancy Options

Lecture 22 Azure Blob Storage

Lecture 23 Azure Storage Access Tiers

Lecture 24 Azure Table Storage

Lecture 25 Azure Queue Storage

Lecture 26 Azure File Share Storage

Lecture 27 Demo Azure File Share Storage

Lecture 28 Azure Disk Storage and demo

Lecture 29 IMP Note: Cosmos DB is Not in exam

Lecture 30 Cosmos DB: Problem Statement - How Cosmos DB Evolved?

Lecture 31 Cosmos DB: Features

Lecture 32 Cosmos DB: Multi Model 5 APIs

Lecture 33 Cosmos DB: Provision Account

Lecture 34 Cosmos DB: Database containers and items

Lecture 35 Cosmos DB: Throughput and request units

Lecture 36 Cosmos DB: Horizontal Scaling

Lecture 37 Cosmos DB: What is partitioning and partition key

Lecture 38 Cosmos DB: Dedicated vs Shared throughput

Lecture 39 Cosmos DB: Avoiding hot partition

Lecture 40 Cosmos DB: Single partition vs Cross partition

Lecture 41 Cosmos DB: Composite Key

Lecture 42 Cosmos DB: Partition key best practice

Lecture 43 Cosmos DB: Demo - Insert and query data

Lecture 44 Cosmos DB: Time to Live

Lecture 45 Cosmos DB: Globally Distribution

Lecture 46 Cosmos DB: Multi Master

Lecture 47 Cosmos DB: Manual vs Automatics Fail-over

Lecture 48 Cosmos DB: 5 consistent level

Lecture 49 Cosmos DB: CLI

Lecture 50 What is Data Lake?

Lecture 51 How Data Lake Gen 2 evolved

Lecture 52 Azure Blob Storage vs Azure Data Lake

Lecture 53 Azure Blob & Data Lake Security options

Lecture 54 High Availability vs Disaster Recovery

Lecture 55 Azure Storage - HA and DR Options

Lecture 56 Cosmos DB - HA and DR Options

Lecture 57 Further Study Material

Lecture 58 My Notes on this section

Lecture 59 Practice Tests

Section 4: Data Storage: Relational Data Stores

Lecture 60 Learning objectives

Lecture 61 Azure SQL: Why?

Lecture 62 Azure Iaas vs Pass Database Offerings

Lecture 63 Azure SQL: PaaS Deployment Options

Lecture 64 Azure SQL Server Demo: Provision Single Database

Lecture 65 Azure SQL Server: Purchasing models and service tiers

Lecture 66 Azure Elastic Database

Lecture 67 Azure Elastic Database Demo: Provision

Lecture 68 Azure SQL Database: Security layers

Lecture 69 Scaling Azure Database

Lecture 70 Azure SQL Database High Availability and Disaster Recovery options

Lecture 71 Azure SQL Database Backup and Restore

Lecture 72 Traditional vs Modern Warehouse architecture

Lecture 73 What is Synapse Analytics Service

Lecture 74 Demo: Create Dedicated SQL Pool

Lecture 75 Demo: Connect Dedicated SQL Pool with SSMS

Lecture 76 Demo: Create Azure Synapse Analytics Studio Workspace

Lecture 77 Demo: Explore Synapse Studio

Lecture 78 Demo: Create Dedicated SQL Pool and Spark Pool

Lecture 79 Demo: Analyse Data using Dedicated SQL Pool

Lecture 80 Demo: Analyse Data using Apache Spark Notebook

Lecture 81 Demo: Analyse Data using Serverless SQL Pool

Lecture 82 Demo: Data Factory from Synapse Analytics Studio

Lecture 83 Demo: Monitor Synapse Studio

Lecture 84 Azure Synapse: MPP Architecture

Lecture 85 Azure Synapse: Storage and Sharding Patterns

Lecture 86 Azure Synapse: Data Distribution and Distributing Keys

Lecture 87 Azure Synapse: Data Types and Table Types

Lecture 88 Azure Synapse: Partitioning

Lecture 89 Azure Synapse: Best Practices for Fact and Dimension tables

Lecture 90 Demo: Analyze Data distribution before migration to Azure

Lecture 91 Azure Synapse: Different loading methods

Lecture 92 Azure Synapse: Loading with SSIS vs PolyBase

Lecture 93 Azure Synapse Demo: Loading with Polybase

Lecture 94 Scaling Azure Datawarehouse

Lecture 95 Azure SQL Datawarehouse Backup and Restore

Lecture 96 Azure Database vs Azure Datawarehouse (Synapse Data Pool)

Lecture 97 Implement data masking

Lecture 98 Encrypt data at rest and in motion

Lecture 99 Further Study Material

Lecture 100 My Notes on this section

Lecture 101 Practice Tests

Section 5: Batch Processing [Design and develop data processing]

Lecture 102 Learning objectives

Lecture 103 What is Data Factory

Lecture 104 Data Factory within Azure Eco system

Lecture 105 Provision Data Factory

Lecture 106 Data Factory - Components

Lecture 107 Data Factory - Pipeline and Activities

Lecture 108 Data Factory - Linked service and Datasets

Lecture 109 Data Factory - Integration Runtime

Lecture 110 Data Factory - Triggers

Lecture 111 Demo: Copy Data Activity through wizard

Lecture 112 Demo: Copy Data Activity using Author page

Lecture 113 Data Factory - User Properties

Lecture 114 Data Factory - Parameters

Lecture 115 Data Factory - Data Flow Concept

Lecture 116 Data Factory - Mapping Data Flow

Lecture 117 Data Factory - Wrangling Data Flow

Lecture 118 What is Azure Databricks

Lecture 119 How to save Databricks demo Cost

Lecture 120 Demo overview

Lecture 121 Demo: Provision Databricks, Clusters and workbook

Lecture 122 Demo: Mount Data Lake to Databricks DBFS

Lecture 123 Demo: Explore, Analyze, Clean, Transform and Load Data in Databricks

Lecture 124 Spark Basics

Lecture 125 Azure Databricks Clusters

Lecture 126 Azure Databricks Other Important Components

Lecture 127 Further Study Material

Lecture 128 My Notes on this section

Lecture 129 Practice Tests

Section 6: Streaming Analytics [Design and develop data processing]

Lecture 130 Learning objectives

Lecture 131 What is Live Event Processing

Lecture 132 Introducing Azure Stream Analytics (configure input and output)

Lecture 133 Introduction to Windowing Functions

Lecture 134 Tumbling Window

Lecture 135 Hopping Window

Lecture 136 Sliding Window

Lecture 137 Session Window

Lecture 138 Demo: Processing Blob Storage Input

Lecture 139 Demo: Processing IOT Hub Input

Lecture 140 Further Study Material

Lecture 141 My Notes on this Section

Lecture 142 Practice Tests

Section 7: Monitor Data Storage

Lecture 143 Learning objectives

Lecture 144 Intro to Azure Monitor Service

Lecture 145 Demo: Azure Monitor Service

Lecture 146 Implementing Blob and Data Lake Storage monitoring

Lecture 147 Implement Azure Synapse Analytics monitoring

Lecture 148 Implement Cosmos DB monitoring

Lecture 149 Further Study Material

Lecture 150 My Notes on this Section

Lecture 151 Practice Tests

Section 8: Monitor Data Processing

Lecture 152 Learning objectives

Lecture 153 Monitor Data Factory Pipelines

Lecture 154 Monitor Data Factory - Metrics, Alerts, Diagnostic Settings

Lecture 155 Monitor Azure Databricks

Lecture 156 Monitor Stream Analytics

Lecture 157 Further Study Material

Lecture 158 My Notes on this Section

Lecture 159 Practice Tests

Section 9: Optimize Azure Data Solutions

Lecture 160 Learning objectives

Lecture 161 Troubleshoot Data Partitioning Bottlenecks

Lecture 162 Optimize Data Lake Storage

Lecture 163 Optimize Stream Analytics

Lecture 164 Optimize Azure Synapse Analytics

Lecture 165 Manage the Data Lifecycle

Lecture 166 Further Study Material

Lecture 167 My Notes on this Section

Lecture 168 Practice Tests

Section 10: Designing an Azure Data Solution

Lecture 169 Data Types

Lecture 170 Data Storage Types

Lecture 171 Select Azure Store for application

Lecture 172 Azure Data Platform Architecture

Lecture 173 RTO and RPO

Lecture 174 Scenarios - Designing a solution for CosmosDB vs Data Lake vs Blob Storage

Lecture 175 Scenarios - Designing for SQL Database vs Data warehouse

Lecture 176 Design Batch Processing Solutions using Data Factory and DataBricks

Lecture 177 Data Ingestion Methods

Lecture 178 Real Time Processing

Lecture 179 Design and Provision Compute Resources

Lecture 180 Lambda Architecture

Lecture 181 Plan for Secure Endpoints (Public/Private)

Lecture 182 Practice Tests

Section 11: Practice Tests

Lecture 183 DP-203 Practice Test Questions Resources

Lecture 184 DP-200/201 Practice Test Questions Resource

Lecture 185 Exam Tips

Section 12: Wrapping up

Lecture 186 What's Next?

Lecture 187 Bonus Section

Anyone who wants to clear DP-203 certification,Anyone who wants to become Azure Data Engineer,Database Developer,Database Administrators (DBA),Business Intelligence (BI) Developers,Data Engineers,Data Scientist,Data Analyst or similar profiles,Other on-premises Database related profiles who want to learn how to implement these technologies in Azure Cloud.