Dp200exam Course
Tags: Microsoft Certification
Exam DP-203: Data Engineering on Microsoft Azure || 25+ hrs of videos || Practice Tests || 100% Syllabus || Demos
Last updated 2022-01-10 | 4.5
- 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)
What you'll learn
* 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 course
Course is completely up-to-date with the latest syllabus released by Microsoft for DP-203
Course covers 100% exam syllabus
Course include
25+ hrs of content
2 practice test
Quiz - specially designed to clear concepts of objectives.
Further study material
PPT and Demo resources
Course includes:
Full lifetime access with all future updates
30-Day Money-Back Guarantee
Certificate of course completion
Intended Audience
Anyone who wants to prepare for DP-203 exam
Anyone who wants to become an Azure Data Engineer
Microsoft Azure Data Engineers
Microsoft Azure Data Scientist
Database and BI developers
Database Administrators
Data Analyst or similar profiles
On-Premises Database related profiles who want to learn how to implement these technologies in Azure Cloud.
Anyone who wants to become an Azure Data Engineer
Prerequisites
Basic Database concepts
Language
English
Please 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 stores
Non-relational data stores (Blob Storage)
Cosmos DB
Implement relational data stores
Azure SQL Server
Azure Synapse Analytics Service
Manage data security
Data masking
Data Encryption
Develop batch processing solutions
Azure Data Factory
Azure Databricks
Develop streaming solutions
Azure Streaming Service
Monitor data storage
Monitoring for Azure Blob Storage
Monitoring for Azure Data Lake
Monitoring for Azure SQL Database
Monitoring for Azure Synapse Analytics
Monitoring for Azure Cosmos DB
Azure Monitoring Service
Monitor data processing
Monitoring for Azure Data Factory
Monitoring for Azure Databricks
Monitoring for Azure Stream Analytics
Optimize Azure data solutions
Optimize Azure Data Lake
Optimize Azure Stream Analytics
Optimize Azure Synapse Analytics
Optimize Azure SQL Database
Some students Feedback
One 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 Badary
Very nicely explained most of the concepts. a must have course for beginners - Manoranjan Swain
I appreciate this course explaining everything in great detail for a beginner. This will assist me in overcoming challenges at my work - Benjamin Curtis
Good course for Beginners. Labs are really helpful to grasp the concept. Thank you - Sapna
Who this course is for:
- 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.
Course content
12 sections • 184 lectures
Course Introduction and set expectation Preview 05:11
IMP: Everything you need to know about exam and this course Preview 03:38
IMP: Instructions Preview 01:33
How to keep using Azure Portal for FREE after 12 months? Preview 04:49
How to get FREE credits for Azure Portal Preview 01:39
PPT and Demo Resources Preview 00:15
Before you start... Preview 01:29
Practice Questions and Quizzes Preview 00:03
Absolute new to Cloud Computing? Here is FREE course for you Preview 00:11
Create Azure Subscription Preview 06:13
Azure Portal Overview Preview 14:45
Delete Resources and Set Budget Preview 06:59
How did Data Engineer Profile Evolve Preview 02:38
Data Engineer Role and Responsibility Preview 05:33
Data Engineer Technologies Preview 03:48
Summary of Data Engineering Profile and Technologies Preview 00:00
Further Study Material Preview 00:07
Learning objectives Preview 03:03
NoSQL Offerings by Microsoft Azure Preview 09:06
Azure Storage Introduction Preview 06:28
Demo Part 1 Provision Azure Storage Account Preview 17:44
Demo Part 2 Replication Preview 12:57
Demo Part 3 Continue Provisioning Storage account Preview 20:33
Azure Blob Storage Preview 10:50
Cosmos DB: Problem Statement - How Cosmos DB Evolved? Preview 02:38
Cosmos DB: Features Preview 11:24
Cosmos DB: Multi Model 5 APIs Preview 12:20
Cosmos DB: Provision Account Preview 10:34
Cosmos DB: Database containers and items Preview 04:27
Cosmos DB: Throughput and request units Preview 09:18
Cosmos DB: Horizontal Scaling Preview 02:49
Cosmos DB: What is partitioning and partition key Preview 06:10
Cosmos DB: Dedicated vs Shared throughput Preview 05:52
Cosmos DB: Avoiding hot partition Preview 05:24
Cosmos DB: Single partition vs Cross partition Preview 03:32
Cosmos DB: Composite Key Preview 03:14
Cosmos DB: Partition key best practice Preview 07:48
Cosmos DB: Demo - Insert and query data Preview 12:41
Cosmos DB: Time to Live Preview 05:48
Cosmos DB: Globally Distribution Preview 13:23
Cosmos DB: Multi Master Preview 08:38
Cosmos DB: Manual vs Automatics Fail-over Preview 07:36
Cosmos DB: 5 consistent level Preview 14:16
Cosmos DB: CLI Preview 07:02
Cosmos DB: Pricing Preview 06:50
Cosmos DB: Security Preview 11:28
What is Data Lake? Preview 03:54
How Data Lake Gen 2 evolved Preview 05:17
Azure Blob Storage vs Azure Data Lake Preview 04:37
Azure Blob & Data Lake Security options Preview 20:52
High Availability vs Disaster Recovery Preview 07:16
Azure Storage - HA and DR Options Preview 11:31
Cosmos DB - HA and DR Options Preview 17:22
Further Study Material Preview 00:33
My Notes on this section Preview 03:07
Practice Tests Preview 00:03
Learning objectives Preview 02:33
Azure SQL: Why? Preview 02:58
Azure Iaas vs Pass Database Offerings Preview 09:22
Azure SQL: PaaS Deployment Options Preview 03:50
Azure SQL Server Demo: Provision Single Database Preview 15:37
Azure SQL Server: Purchasing models and service tiers Preview 13:23
Azure Elastic Database Preview 04:16
Azure Elastic Database Demo: Provision Preview 14:01
Azure SQL Database: Security layers Preview 08:11
Scaling Azure Database Preview 11:20
Azure SQL Database High Availability and Disaster Recovery options Preview 28:32
Azure SQL Database Backup and Restore Preview 19:07
Traditional vs Modern Warehouse architecture Preview 14:24
What is Synapse Analytics Service Preview 08:45
Demo: Create Dedicated SQL Pool Preview 11:43
Demo: Connect Dedicated SQL Pool with SSMS Preview 03:40
Demo: Create Azure Synapse Analytics Studio Workspace Preview 05:57
Demo: Explore Synapse Studio Preview 11:53
Demo: Create Dedicated SQL Pool and Spark Pool Preview 08:12
Demo: Analyse Data using Dedicated SQL Pool Preview 09:14
Demo: Analyse Data using Apache Spark Notebook Preview 11:52
Demo: Analyse Data using Serverless SQL Pool Preview 07:52
Demo: Data Factory from Synapse Analytics Studio Preview 09:03
Demo: Monitor Synapse Studio Preview 07:36
Azure Synapse: MPP Architecture Preview 07:10
Azure Synapse: Storage and Sharding Patterns Preview 05:29
Azure Synapse: Data Distribution and Distributing Keys Preview 06:05
Azure Synapse: Data Types and Table Types Preview 05:20
Azure Synapse: Partitioning Preview 04:48
Azure Synapse: Best Practices for Fact and Dimension tables Preview 02:49
Demo: Analyze Data distribution before migration to Azure Preview 12:19
Azure Synapse: Different loading methods Preview 02:38
Azure Synapse: Loading with SSIS vs PolyBase Preview 03:35
Azure Synapse Demo: Loading with Polybase Preview 27:10
Scaling Azure Datawarehouse Preview 03:17
Azure SQL Datawarehouse Backup and Restore Preview 10:30
Azure Database vs Azure Datawarehouse (Synapse Data Pool) Preview 02:33
Implement data masking Preview 21:20
Encrypt data at rest and in motion Preview 25:43
Further Study Material Preview 00:38
My Notes on this section Preview 04:10
Practice Tests Preview 00:03
Learning objectives Preview 02:45
What is Data Factory Preview 04:39
Data Factory within Azure Eco system Preview 09:42
Provision Data Factory Preview 08:02
Data Factory - Components Preview 07:12
Data Factory - Pipeline and Activities Preview 13:21
Data Factory - Linked service and Datasets Preview 14:30
Data Factory - Integration Runtime Preview 19:22
Data Factory - Triggers Preview 19:30
Demo: Copy Data Activity through wizard Preview 35:02
Demo: Copy Data Activity using Author page Preview 09:21
Data Factory - User Properties Preview 03:42
Data Factory - Parameters Preview 16:42
Data Factory - Data Flow Concept Preview 15:19
Data Factory - Mapping Data Flow Preview 28:04
Data Factory - Wrangling Data Flow Preview 10:58
What is Azure Databricks Preview 08:58
How to save Databricks demo Cost Preview 01:07
Demo overview Preview 04:35
Demo: Provision Databricks, Clusters and workbook Preview 11:22
Demo: Mount Data Lake to Databricks DBFS Preview 12:24
Demo: Explore, Analyze, Clean, Transform and Load Data in Databricks Preview 18:04
Azure Databricks Clusters Preview 12:56
Azure Databricks Other Important Components Preview 09:34
Further Study Material Preview 00:35
My Notes on this section Preview 01:25
Practice Tests Preview 00:03
Learning objectives Preview 01:22
Introducing Azure Stream Analytics (configure input and output) Preview 06:18
Introduction to Windowing Functions Preview 02:22
Tumbling Window Preview 02:33
Hopping Window Preview 02:13
Sliding Window Preview 02:22
Session Window Preview 06:06
Demo: Processing Blob Storage Input Preview 18:43
Demo: Processing IOT Hub Input Preview 18:49
Further Study Material Preview 00:18
My Notes on this Section Preview 02:43
Practice Tests Preview 00:03
Learning objectives Preview 02:21
Intro to Azure Monitor Service Preview 16:22
Demo: Azure Monitor Service Preview 22:59
Implementing Blob and Data Lake Storage monitoring Preview 17:25
Implement Azure Synapse Analytics monitoring Preview 12:15
Implement Cosmos DB monitoring Preview 12:43
Further Study Material Preview 00:21
My Notes on this Section Preview 02:02
Practice Tests Preview 00:03
Learning objectives Preview 01:41
Monitor Data Factory Pipelines Preview 15:18
Monitor Data Factory - Metrics, Alerts, Diagnostic Settings Preview 13:39
Monitor Azure Databricks Preview 06:39
Monitor Stream Analytics Preview 14:12
Further Study Material Preview 00:13
My Notes on this Section Preview 01:36
Practice Tests Preview 00:03
Learning objectives Preview 02:21
Troubleshoot Data Partitioning Bottlenecks Preview 06:56
Optimize Data Lake Storage Preview 05:39
Optimize Stream Analytics Preview 10:22
Optimize Azure Synapse Analytics Preview 09:54
Manage the Data Lifecycle Preview 13:54
Further Study Material Preview 00:21
My Notes on this Section Preview 02:08
Practice Tests Preview 00:03
Data Types Preview 11:36
Data Storage Types Preview 18:16
Select Azure Store for application Preview 04:08
Azure Data Platform Architecture Preview 05:41
RTO and RPO Preview 04:11
Scenarios - Designing a solution for CosmosDB vs Data Lake vs Blob Storage Preview 10:25
Scenarios - Designing for SQL Database vs Data warehouse Preview 06:10
Design Batch Processing Solutions using Data Factory and DataBricks Preview 17:04
Data Ingestion Methods Preview 12:56
Real Time Processing Preview 11:31
Design and Provision Compute Resources Preview 08:51
Lambda Architecture Preview 09:44
Plan for Secure Endpoints (Public/Private) Preview 07:01
Practice Tests Preview 00:03
DP-203 Practice Test Questions Resources Preview 00:03
DP-200/201 Practice Test Questions Resource Preview 00:08
Exam Tips Preview 02:10
Sample Questions 1
Sample Questions 2
What's Next? Preview 01:10
Bonus Preview 00:32
This course includes:
- 24 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Recent Posts
Valuable Experiences To Prepare For Financial Investment
Finance is an attractive field, which has been attracting a lot of people to learn and participate. But like any other field, before entering a ...Read more
Sales Email vs. Cold Call: When to Use Each According to Data
The initial contact with the potential clients is a delicate art for the sales representatives. You will hardly ever get a second chance to make ...Read more
10 Essential Elements to Look For in an Online FE Course
If you are trying to invest your time in an online FE course, this article is great to help. We’ll uncover the 10 essential elements ...Read more
Everything you need to know about SQL
We all know that raw data isn’t helpful on its own, right? Despite the ongoing buzz, it is essential to have meaningful data. This is ...Read more
Anthropology majors can take these career paths: Six best options
What is Anthropology? Anthropology is a thorough study of human life. Human study includes studying of: – ● Genetic changes of human genes ● Socialization ...Read more
