Azure Data Engineer DP-203
The Azure Database Engineer Associate DP-203 training prepares you for the Azure DP-203 certification exam. On completion of this course, you will acquire a working knowledge of Azure blob storage, Azure SQL, and Azure data factory. You will also develop an in-depth understanding of Azure synapse analytics, Azure databricks, and event hub. You will learn topics such as Azure stream analytics, logic app, and incremental & dynamic data load. Modules on SCD, data migration, data monitoring, and data authorization are also part of this course. The Azure DP-203 contains training materials that ensure you get a complete learning experience.
In This Module We Will Learn :
Introduction
- What is Azure?
- Cloud Concepts
- Type of Clouds
- IaaS, Paas, Saas
- Difference between on-premises & cloud-based
- Job responsibilities as Azure Data Engineer
- Types of Data
- Knowledge Check
Azure Blob Storage
- Job responsibilities as Azure Data Engineer
- Types of Data
- Working with Data Storage
- Choose your account settings
- Azure your Azure Storage account
- Azure DataLake
- Creating ADLS Gen2
- Difference Between DataLake & Storage
- Knowledge Check
Azure SQL
- Azure SQL
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure VM
- SQL Server migration options
- Azure SQL Database benefits
Azure Data Factory
- What is Azure Data Factory?
- Linked Services
- Datasets
- Pipelines
- Demo
Azure Synapse Analytics
- Overview
- Azure Synapse – SQL Analytics
- SQL Analytics Columnstore Tables
- What are table partitions?
Azure Databricks
- What is Azure Databricks?
- Cloud Concepts
- Type of Clouds
- Difference between on-premises & cloud-based
- Job responsibilities as Azure Data Engineer
- Types of Data
- Knowledge Check
Azure Event Hub
- Azure Event Hub
- Scenarios for Event Hubs
Azure Stream Analytics
- What is Azure Streaming Analytics?
- Cloud Concepts
- Type of Clouds
- Difference between on-premises & cloud-based
- Job responsibilities as Azure Data Engineer
- Types of Data
- Knowledge Check
Logic App
- What is Azure Logic Apps?
- Demo
Incremental &Dynamic Data load
- Incremental &Dynamic Data load
- Data loading from database by using a watermark
- Incremental load using ADF Data Flows
SCD
- Types of approaches
Data Migration, Monitor, Authorization
- Tools and services for your migration journey
- Database migration process overview
- The AAA Security Model
- Resource Token
- Azure Data lake Authentication
- SQL Server Authentication
- Azure SQL Database Auditing
- Azure Monitor
- High Availability