DP-203: Data Engineering in Microsoft Azure, Part 2 of 7: Relational Data Stores
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 | Beginner | |
| Runtime | 6h 18m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
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 Data Storage using Relational Data Stores.
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 6
Implement Relational Data (34:33)
- Introduction (00:08)
- Learning Objectives (02:28)
- Why Choosing Sql Server In Azure (02:58)
- Azure Laas Vs Pass Database Offerings (09:22)
- Sql Server Paas Deployment Options (03:50)
- Demo: Single Database (15:37)
- Summary (00:08)
DB Purchasing Models and Service Tiers (31:57)
- Introduction (00:08)
- Purchasing Models And Service Tiers (13:23)
- Elastic Db (04:16)
- Demo: Elastic DB (14:01)
- Summary (00:08)
Module 7
Security (48:07)
- Introduction (00:08)
- Security (08:11)
- Scaling Azure DB (11:14)
- Sql Db HA and DA Options (28:25)
- Summary (00:08)
SQL DB Backup and Restore (33:36)
- Introduction (00:08)
- Sql Db Backup And Restore (18:56)
- Traditional Vs Modern Warehouse Architecture (14:24)
- Summary (00:08)
Module 8
What is Synapse Analytics Service (30:04)
- Introduction (00:08)
- What Is Synapse Analytics Service (08:39)
- Create Dedicated Sql Pool (11:43)
- Connect Sql Pool With Ssms (03:35)
- Create Azure Synapse Analytics Workspace (05:49)
- Summary (00:08)
Explore Synapse Studio (29:11)
- Introduction (00:08)
- Synapse Studio (11:44)
- Create Dedicated Sql Pool And Spark Pool From Ins (08:04)
- Analyse Data Using Dedicated Sql Pool (09:06)
- Summary (00:08)
Analyze Data using Apache Spark Notebook (28:47)
- Introduction (00:08)
- Analyse Data Using Apache Spark Notebook (11:46)
- Analyse Data Using Serverless SQL Pool (07:46)
- Data Factory Copy Tool From Synapse Integrate Tab (08:58)
- Summary (00:08)
Module 9
Azure Synapse Architecture (29:10)
- Introduction (00:08)
- Azure Synapse Architecture (07:10)
- Storage And Sharding Patterns (05:29)
- Data Distribution And Distributing Keys (06:05)
- Data Types And Table Types (05:20)
- Partitioning (04:48)
- Summary (00:08)
Best Practices for Fact and Dimension tables (21:39)
- Introduction (00:08)
- Best Practices For Fact And Dimension Tables (02:49)
- Demo: Analyse Data Distribution Before Migration (12:19)
- Different Loading Methods (02:38)
- Loading With Ssis Vs Polybase (03:35)
- Summary (00:08)
Loading with Polybase (27:26)
- Introduction (00:08)
- Demo: Loading With Polybase (13:22)
- Polybase Setup (13:47)
- Summary (00:08)
Module 10
Scaling Azure DW (16:38)
- Introduction (00:08)
- Scaling Azure Dw (03:17)
- Sql Dw Backup And Restore (10:30)
- Azure DB vs. Dw (02:33)
- Summary (00:08)
Dynamic Data Masking (21:36)
- Introduction (00:08)
- Dynamic Data Masking (14:29)
- Dynamic Data Description (06:51)
- Summary (00:08)
Encryption (25:59)
- Introduction (00:08)
- Encryption (05:57)
- Encryption In Rest (19:45)
- Summary (00:08)