5.00
(3 Ratings)

DP-203 – Data Engineering on Microsoft Azure 2023

By databag Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Why Microsoft Azure Data Engineer?

An Azure data engineer helps ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints. This professional deals with unanticipated issues swiftly and minimizes data loss. An Azure data engineer also designs, implements, monitors, and optimizes data platforms to meet the data pipeline needs.

This course is designed for students who want to attain the “Microsoft Certified: Azure Data Engineer Associate” certification

A candidate for this certification must have solid knowledge of data processing languages, such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns.

This course has contents for the Exam DP-203

The objectives covered in this course are

  • Design and implement data storage (40-45%)
  • Design and develop data processing (25-30%)
  • Design and implement data security (10-15%)
  • Monitor and optimize data storage and data processing (10-15%)

In this course students will learn about the various Azure services that pertain to Data Engineering. Some of the important aspects that students will learn include the following

  • What is the purpose of an Azure Data Lake Gen 2 storage account
  • How to work with Azure Synapse. This will include building a data warehouse into a dedicated SQL Pool.
  • How to build an ETL pipeline with the help of Azure Data Factory. There will be various scenarios on how to create mapping data flows.
  • How to stream data with the use of Azure Stream Analytics. You can see how SQL commands can be used for your streaming data.
  • How to work with SPARK, Scala in Azure Databricks. We will see how to work with Notebooks. We will also see how to stream data into Azure Databricks.
  • The different security measures and monitoring aspects to consider when working with Azure services

Who this course is for:

  • Those who want to pursue the Microsoft Certified: Azure Data Engineer Associate
  • Those who want to pass the DP-203 Certification exam
Show More

What Will You Learn?

  • What is the purpose of an Azure Data Lake Gen 2 storage account
  • How to work with Azure Synapse.
  • How to build an ETL pipeline with the help of Azure Data Factory.
  • Various scenarios on how to create mapping data flows in ADF.
  • How to stream data with the use of Azure Stream Analytics.
  • How to work with SPARK, Scala in Azure Databricks.
  • We will see how to work with Notebooks in Databricks.
  • The different security measures and monitoring aspects to consider when working with Azure.

Course Content

Azure Trial Free Account
Steps to register for free Azure Account

  • Steps for Azure Trial Free Account
    00:00

Data Lake Gen 2
Introduction Different Types of Azure Storage Access Tiers Azure Active Directory Security Lifecycle Management Data Redundancy for Storage

Azure SQL / MS SQL Server
SQL Server Architecture Why SQL Server Azure SQL Deployment Options Azure SQL Database Service Tiers On-Premise to Azure Migration Security Disaster Recovery

No SQL- Cosmos DB/ ADF Introduction
Data Lake Quiz No SQL What is No SQL SQL vs No SQL Types of No SQL DB Cosmos DB Cosmos DB Gremlin API Graph Model Decision Criteria for which type of DB to choose Azure Table storage vs Cosmos DB Table API Azure Data Factory

Azure Databricks
Map Reduce & its challenges Hadoop Introduction Spark Introduction Apache Spark API RDDs to Dataset Datasets to DataFrames Databricks Introduction Azure Databricks Architecture Azure Databricks Cluster Types Azure Databricks Workspaces Azure Databricks Notebooks

Azure Stream Analytics
Azure Stream Analytics Introduction Event Processing Live Event Processing Live Data Processing Challenges Azure options for Live Data Processing Azure Stream Analytics Data Flow Azure Stream Analytics Windowing Demo Overview Azure Stream Analytics Data Inputs Azure Stream Analytics Data Outputs Important Metrics - Watermark delay Stream Analytics – Optimization

Azure Data Factory- Continued
Triggers Secure Input and Output,User Properties & Parameters -Demo Perform code-free transformation at scale with Azure Data Factory Mapping Data Flow- Demo Wrangling Data Flow- Demo Monitoring ADF

Azure HDInsight
Why Hadoop is Hard? Hadoop on Cloud How HDInsight makes Hadoop easy ? Important aspects of Hadoop HDInsight Architecture

Azure Synapse Analytics
• Why Warehousing in Cloud • Azure Synapse Service – a Game Changer • Traditional vs Modern DW • Architecture Modern vs Synapse DW • Architecture Azure Synapse Studio – Unified Experience

Course Material

Student Ratings & Reviews

No Review Yet
No Review Yet