Azure Data Engineer DP-203

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 “Mastering Azure” 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

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

Course Content

Expand All
Lesson Content
0% Complete 0/1 Steps

Similar Courses:

Azure Database Admin Associate DP-300

Azure Database Admin Associate DP-300

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

Azure Data Factory

Azure Data Factory

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…

Azure Fundamentals AZ-900

Azure Fundamentals AZ-900

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