What will i 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
Curriculum for this course
152 Lessons
22:25:41 Hours
Introduction to Azure Cloud and Data Engineer Profile
5 Lessons
00:32:59
-
Create Azure Free Subscription
00:06:14
![]( "Not complete")
-
Azure Portal Overview
00:14:45
![]( "Not complete")
-
How did Data Engineer Profile Evolve
00:02:38
![]( "Not complete")
-
Data Engineer Role and Responsibility
00:05:34
![]( "Not complete")
-
Data Engineer Technologies
00:03:48
![]( "Not complete")
Optimize Azure Data Solutions
6 Lessons
00:39:13
-
Learning objectives
00:02:21
![]( "Not complete")
-
Troubleshoot Data Partitioning Bottlenecks
00:06:56
![]( "Not complete")
-
Optimize Data Lake Storage
00:05:39
![]( "Not complete")
-
Optimize Stream Analytics
00:10:23
![]( "Not complete")
-
Optimize Azure Synapse Analytics
00:00:00
![]( "Not complete")
-
Manage the Data Lifecycle
00:13:54
![]( "Not complete")
Data Storage: Non Relational Data Stores
40 Lessons
04:50:54
-
Learning objectives
00:03:04
![]( "Not complete")
-
Azure Storage Services Overview
00:06:03
![]( "Not complete")
-
Demo Provision Azure Storage Account
00:05:13
![]( "Not complete")
-
Data Redundancy Options
00:06:01
![]( "Not complete")
-
Azure Blob Storage
00:06:15
![]( "Not complete")
-
Azure Storage Access Tiers
00:04:52
![]( "Not complete")
-
Azure Table Storage
00:05:05
![]( "Not complete")
-
Azure Queue Storage
00:02:47
![]( "Not complete")
-
Azure File Share Storage
00:05:36
![]( "Not complete")
-
Demo Azure File Share Storage
00:03:51
![]( "Not complete")
-
Azure Disk Storage and demo
00:08:20
![]( "Not complete")
-
Cosmos DB: Problem Statement - How Cosmos DB Evolved?
00:02:38
![]( "Not complete")
-
Cosmos DB: Features
00:11:25
![]( "Not complete")
-
Cosmos DB: Multi Model 5 APIs
00:12:21
![]( "Not complete")
-
Cosmos DB: Provision Account
00:00:00
![]( "Not complete")
-
Cosmos DB: Database Containers and Items
00:04:28
![]( "Not complete")
-
Cosmos DB: Throughput and Request Units
00:09:18
![]( "Not complete")
-
Cosmos DB: Horizontal Scaling
00:02:49
![]( "Not complete")
-
Cosmos DB: What is partitioning and partition key
00:06:10
![]( "Not complete")
-
Cosmos DB: Dedicated vs Shared throughput
00:05:53
![]( "Not complete")
-
Cosmos DB: Avoiding hot partition
00:05:25
![]( "Not complete")
-
Cosmos DB: Single partition vs Cross partition
00:03:33
![]( "Not complete")
-
Cosmos DB: Composite Key
00:03:15
![]( "Not complete")
-
Cosmos DB: Partition key best practice
00:07:49
![]( "Not complete")
-
Cosmos DB: Demo - Insert and query data
00:12:42
![]( "Not complete")
-
Cosmos DB: Time to Live
00:05:48
![]( "Not complete")
-
Cosmos DB: Globally Distribution
00:13:23
![]( "Not complete")
-
Cosmos DB: Multi Master
00:08:39
![]( "Not complete")
-
Cosmos DB: Manual vs Automatics Fail-over
00:07:36
![]( "Not complete")
-
Cosmos DB: 5 consistent level
00:14:16
![]( "Not complete")
-
Cosmos DB: CLI
00:07:02
![]( "Not complete")
-
Cosmos DB: Pricing
00:06:50
![]( "Not complete")
-
Cosmos DB: Security
00:11:34
![]( "Not complete")
-
What is Data Lake?
00:03:55
![]( "Not complete")
-
How Data Lake Gen 2 evolved
00:05:17
![]( "Not complete")
-
Azure Blob Storage vs Azure Data Lake
00:04:38
![]( "Not complete")
-
Azure Blob & Data Lake Security options
00:20:52
![]( "Not complete")
-
High Availability vs Disaster Recovery
00:07:17
![]( "Not complete")
-
Azure Storage - HA and DR Options
00:11:31
![]( "Not complete")
-
Cosmos DB - HA and DR Options
00:17:23
![]( "Not complete")
Designing an Azure Data Solutions
13 Lessons
01:40:13
-
Data Types
00:11:37
![]( "Not complete")
-
Data Storage Types
00:18:17
![]( "Not complete")
-
Select Azure Store for application
00:04:08
![]( "Not complete")
-
Azure Data Platform Architecture
00:05:42
![]( "Not complete")
-
RTO and RPO
00:04:12
![]( "Not complete")
-
Scenarios - Designing a solution for CosmosDB vs Data Lake vs Blob Storage
00:00:00
![]( "Not complete")
-
Scenarios - Designing for SQL Database vs Data warehouse
00:06:11
![]( "Not complete")
-
Design Batch Processing Solutions using Data Factory and DataBricks
00:00:00
![]( "Not complete")
-
Data Ingestion Methods
00:12:56
![]( "Not complete")
-
Real Time Processing
00:11:32
![]( "Not complete")
-
Design and Provision Compute Resources
00:08:51
![]( "Not complete")
-
Lambda Architecture
00:09:45
![]( "Not complete")
-
Plan for Secure Endpoints (Public/Private)
00:07:02
![]( "Not complete")
Data Storage : Relational Data Stores
39 Lessons
06:24:29
-
Learning objectives
00:02:33
![]( "Not complete")
-
Azure SQL: Why?
00:02:59
![]( "Not complete")
-
Azure Iaas vs Pass Database Offerings
00:09:23
![]( "Not complete")
-
Azure SQL: PaaS Deployment Options
00:03:50
![]( "Not complete")
-
Azure SQL Server Demo: Provision Single Database
00:15:37
![]( "Not complete")
-
Azure SQL Server: Purchasing models and service tiers
00:13:24
![]( "Not complete")
-
Azure Elastic Database
00:04:16
![]( "Not complete")
-
Azure Elastic Database Demo: Provision
00:14:01
![]( "Not complete")
-
Azure SQL Database: Security layers
00:08:11
![]( "Not complete")
-
Scaling Azure Database
00:11:21
![]( "Not complete")
-
Azure SQL Database High Availability and Disaster Recovery options
00:28:33
![]( "Not complete")
-
Azure SQL Database Backup and Restore
00:19:08
![]( "Not complete")
-
Traditional vs Modern Warehouse architecture
00:14:25
![]( "Not complete")
-
What is Synapse Analytics Service
00:08:46
![]( "Not complete")
-
Demo: Create Dedicated SQL Pool
00:11:44
![]( "Not complete")
-
Demo: Connect Dedicated SQL Pool with SSMS
00:03:41
![]( "Not complete")
-
Demo: Create Azure Synapse Analytics Studio Workspace
00:05:57
![]( "Not complete")
-
Demo: Explore Synapse Studio
00:11:53
![]( "Not complete")
-
Demo: Create Dedicated SQL Pool and Spark Pool
00:08:12
![]( "Not complete")
-
Demo: Analyse Data using Dedicated SQL Pool
00:09:14
![]( "Not complete")
-
Demo: Analyse Data using Apache Spark Notebook
00:11:52
![]( "Not complete")
-
Demo: Analyse Data using Serverless SQL Pool
00:07:53
![]( "Not complete")
-
Demo: Data Factory from Synapse Analytics Studio
00:09:04
![]( "Not complete")
-
Demo: Monitor Synapse Studio
00:07:37
![]( "Not complete")
-
Azure Synapse: MPP Architecture
00:07:11
![]( "Not complete")
-
Azure Synapse: Storage and Sharding Patterns
00:05:30
![]( "Not complete")
-
Azure Synapse: Data Distribution and Distributing Keys
00:06:05
![]( "Not complete")
-
Azure Synapse: Data Types and Table Types
00:05:20
![]( "Not complete")
-
Azure Synapse: Partitioning
00:04:48
![]( "Not complete")
-
Azure Synapse: Best Practices for Fact and Dimension tables
00:02:50
![]( "Not complete")
-
Demo: Analyze Data distribution before migration to Azure
00:12:20
![]( "Not complete")
-
Azure Synapse: Different loading methods
00:02:39
![]( "Not complete")
-
Azure Synapse: Loading with SSIS vs PolyBase
00:03:36
![]( "Not complete")
-
Azure Synapse Demo: Loading with Polybase
00:27:10
![]( "Not complete")
-
Scaling Azure Datawarehouse
00:03:17
![]( "Not complete")
-
Azure SQL Datawarehouse Backup and Restore
00:10:31
![]( "Not complete")
-
Azure Database vs Azure Datawarehouse (Synapse Data Pool)
00:02:34
![]( "Not complete")
-
Implement Data Masking
00:21:21
![]( "Not complete")
-
Encrypt data at rest and in motion
00:25:43
![]( "Not complete")
Wrapping Up
1 Lessons
00:01:11
-
What's Next?
00:01:11
![]( "Not complete")
Batch Processing (Develop and Design Data Processing)
23 Lessons
04:38:04
-
Learning objectives
00:02:46
![]( "Not complete")
-
What is Data Factory
00:04:40
![]( "Not complete")
-
Data Factory within Azure Eco system
00:09:42
![]( "Not complete")
-
Provision Data Factory
00:08:02
![]( "Not complete")
-
Data Factory - Components
00:07:12
![]( "Not complete")
-
Data Factory - Pipeline and Activities
00:13:21
![]( "Not complete")
-
Data Factory - Linked service and Datasets
00:14:30
![]( "Not complete")
-
Data Factory - Integration Runtime
00:19:22
![]( "Not complete")
-
Data Factory - Triggers
00:19:30
![]( "Not complete")
-
Demo: Copy Data Activity through wizard
00:35:02
![]( "Not complete")
-
Demo: Copy Data Activity using Author page
00:09:21
![]( "Not complete")
-
Data Factory - User Properties
00:03:43
![]( "Not complete")
-
Data Factory - Parameters
00:16:42
![]( "Not complete")
-
Data Factory - Data Flow Concept
00:15:20
![]( "Not complete")
-
Data Factory - Mapping Data Flow
00:28:04
![]( "Not complete")
-
Data Factory - Wrangling Data Flow
00:10:58
![]( "Not complete")
-
What is Azure Databricks
00:08:58
![]( "Not complete")
-
Demo overview
00:04:35
![]( "Not complete")
-
Demo: Provision Databricks, Clusters and workbook
00:11:22
![]( "Not complete")
-
Demo: Mount Data Lake to Databricks DBFS
00:12:24
![]( "Not complete")
-
Demo: Explore, Analyze, Clean, Transform and Load Data in Databricks
00:00:00
![]( "Not complete")
-
Azure Databricks Clusters
00:12:56
![]( "Not complete")
-
Azure Databricks Other Important Components
00:09:34
![]( "Not complete")
Streaming Analytics (Develop and Design Data Processing)
9 Lessons
01:00:50
-
Learning objectives
00:01:23
![]( "Not complete")
-
Introducing Azure Stream Analytics (configure input and output)
00:06:18
![]( "Not complete")
-
Introduction to Windowing Functions
00:02:22
![]( "Not complete")
-
Tumbling Window
00:02:33
![]( "Not complete")
-
Hopping Window
00:02:14
![]( "Not complete")
-
Sliding Window
00:02:22
![]( "Not complete")
-
Session Window
00:06:06
![]( "Not complete")
-
Demo: Processing Blob Storage Input
00:18:43
![]( "Not complete")
-
Demo: Processing IOT Hub Input
00:18:49
![]( "Not complete")
Monitor Data Storage
6 Lessons
01:24:06
-
Learning objectives
00:02:21
![]( "Not complete")
-
Intro to Azure Monitor Service
00:16:22
![]( "Not complete")
-
Demo: Azure Monitor Service
00:23:00
![]( "Not complete")
-
Implementing Blob and Data Lake Storage monitoring
00:17:25
![]( "Not complete")
-
Implement Azure Synapse Analytics monitoring
00:12:15
![]( "Not complete")
-
Implement Cosmos DB monitoring
00:12:43
![]( "Not complete")
Course Introduction
5 Lessons
00:22:09
-
Course Introduction and Set Expectation
Preview 00:05:12
![]( "Not complete")
-
IMP:Everything You Need To Know About Exam and this Course
00:03:39
![]( "Not complete")
-
How to Use Azure Portal for Absolutely Free
00:04:50
![]( "Not complete")
-
Before You Start...
00:01:29
![]( "Not complete")
-
Delete Resources and Set Budget
00:06:59
![]( "Not complete")
Get Certifications
Download Certificate + View more
Course overview
A professional course in Microsoft Azure Data Engineering will help you get through the DP-203 Exam seamlessly. Also, here you will be able to put your already acquired skills and knowledge in SQL DB (Azure), Databricks, and Cosmos DB under evaluation.
Moreover, by the end of this course, you will be able to curate, monitor, and configure data systems within the Azure portal. All you have to be is very clear about the basic concepts of the Azure database and be highly determined to clear off the DP-203 Exam in one go.
Why you should learn DP-203 Data Engineering on Microsoft Azure with MyAssignmenthelp.com?
Here is why you should take the Microsoft Azure DP-203 Data Engineering + Practice Tests course with MyAssignmenthelp.com:
- The course content uploaded is entirely in sync with the latest syllabus of Microsoft DP-203.
- You will get to cover 100% of the entire exam syllabus.
- Also, 2 practice test content is available within the course, making your task a lot easier and offering real-life experience.
- Demo resources and PPT are made available for your help.
- You can have full-time access to the course for the rest of your life.
- The course-specific modules can be accessed from both laptop and mobile.
- The best part is that you can claim the money back in 30-days if unsatisfied with the course content.
- Course-end physical certificates are also available, which are industry accredited.
Here is a complete list of content that you will learn in this course:
-
How to incorporate non-relational data stores
- Blob storage in the non-relational data store.
- Cosmos DB
-
How to integrate non-relational data stores
- SQL Server (Azure)
- Analytics Service (Azure Synapse)
-
Data security management
- Data masking
- Data encryption
-
Development of solutions in batch processing
- Data factory (Azure)
- Databricks (Azure)
- Development of various streaming services in Azure
-
Data storage monitoring
- Blob Storage in Azure
- Data Lake
- SQL Database
- Synapse Analytics
- Cosmos DB
- Monitoring Service (Azure)
-
Data process monitoring
- Data Factory
- Stream Analytics
- Data Factory
-
Optimisation of Azure Data Solutions
- Synapse Analytics
- Data Lake
- SQL Database
- Stream Analytics
What is the importance of DP-203 Data Engineering on Microsoft Azure in your career?
Here is how a course in DP-203 Data Engineering concept will help you with the needed career growth:
- The in-course content will help you prepare for the DP-203 exam and kickstart your career hassle-free.
- If you are already a data engineer handy with Azure-based technicalities, this course will help you resolve unforeseen situations and reduce any potential chances of data loss.
- Also, you will get first-hand knowledge about various data processing languages like Python, Scala, and SQL.
- As per recent studies, about 65% of learners have felt more confident with their place in the industry after taking a professional course in DP-203 Data Engineering.
- Employers are always looking for employees with industry-relevant course experiences. In that case, a professional certification in Microsoft Azure DP-203 Data Engineering offers quick exposure to various job opportunities with an enhanced salary.
Who this course is for:
This course is for:
- A learner who wants to complete the DP-203 certification
- Those who wish to become a Data Engineer specialised in Azure
- Database Developers
- Data Engineers
- Data Scientists
- Administrators in Database
- Data Analyst with similar profiles
- BI Developers
- For technicians on-premises who want to implement technicalities on the Azure Cloud.
What you will learn from this course
Here is a complete list of things that you will learn from this course:
- By the end, you will be completely prepared to pass the DP-203 Microsoft Azure: Data Engineering Exam.
- Fully accustomed to Azure Cosmos DB, including the entire syllabus of DP-203.
- SQL Database of Azure
- All about Data Factory (Azure)
- Analytics services in Azure.
- Data Lake (Azure)
- Datawarehouse, Azure SQL, and Synapse.
- Databricks in Azure.
- Complete overview of Azure monitoring services.
Know your instructor
Eshant Garg is a data analyst with 10+ years of experience. He lives in Edinburg, UK, and helps beginners and professionals with their career goals.
+ View more
Other related courses
About instructor
Eshant Garg | AWS Certified Cloud Practitioner | LearnCloud.Info | 100,000+ Enrollments .
I love to explain complicated things in a simple and effective way.I have 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutio...
Reviews
-
UDUmesh Devidas C.03/04/2022Ultimate course with the nice explanation. In last few sections I felt repeating contents/topics. Otherwise really nice course.
-
JGJavier G.03/02/2022this is great training, I passed my exam last week, Eshant explains everything you need to know to work data engineer in azure and also to pass the exam.
-
EREduardo R.09/12/2021I have not present the exam yet, but I really feel more confident after taking the course as it is clearer than the resources given by Microsoft itself. Just, I think the accent of the tutor could be better. That would be my advice about the course
-
RTRobert T.06/09/2021Great course overall. Very thorough, set at a good pace with meaningful content. Could do with regular tests at the end of each section to reinforce understanding of material.
-
EDEric D.06/04/2021No clear direction hard to tell where the certification learning ends and the just extra info begins. Not clear on what to actually study because of this.
Write a public review