Azure Data Engineer DP-203 Training

Current Status
Not Enrolled
Price
Closed
Get Started

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.

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years of Azure expertise, the course “Azure Data Engineer DP-203 Training” provides learners with a comprehensive curriculum to acquire comprehensive knowledge and proficiency in this domain.

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

AZUER 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 ANALYSIS

  • 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 & DYNAMIN 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

Course Content

Expand All
Lesson Content
0% Complete 0/1 Steps

Similar Courses:

Azure Database Admin Associate DP-300 Training

Azure Database Admin Associate DP-300 Training

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…

Azure Data Factory Training

Azure Data Factory Training

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…

Azure Fundamentals AZ-900 – (Free)

Azure Fundamentals AZ-900 – (Free)

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…

Azure Fundamentals AZ-900

Azure Fundamentals AZ-900

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…