Data Engineering on Microsoft Azure

DP-203 | 4 days | €985All prices exclude VAT.

In this course, the student will learn about the data engineering as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies.

The course is replacing DP-200 and DP-201.

Overview

In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.

The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure.

What you’ll learn

Module 1: Introduction to data engineering on Azure

Module 2: Introduction to Azure Data Lake Storage Gen2

Module 3: Introduction to Azure Synapse Analytics

Module 4: Use Azure Synapse serverless SQL pool to query files in a data lake

Module 5: Create a lake database in Azure Synapse Analytics

Module 6: Analyze data with Apache Spark in Azure Synapse Analytics

Module 7: Transform data with Spark in Azure Synapse Analytics

Module 8: Use Delta Lake in Azure Synapse Analytics

Module 9: Analyze data in a relational data warehouse

Module 10: Load data into a relational data warehouse

Module 11: Build a data pipeline in Azure Synapse Analytics

Module 12: Use Spark Notebooks in an Azure Synapse Pipeline

Module 13: Plan hybrid transactional and analytical processing using Azure Synapse Analytics

Module 14: Implement Azure Synapse Link with Azure Cosmos DB

Module 15: Implement Azure Synapse Link for SQL

Module 16: Get started with Azure Stream Analytics

Module 17: Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics

Module 18: Visualize real-time data with Azure Stream Analytics and Power BI

Module 19: Introduction to Microsoft Purview

Module 20: Integrate Microsoft Purview and Azure Synapse Analytics

Module 21: Explore Azure Databricks

Module 22: Use Apache Spark in Azure Databricks

Module 23: Run Azure Databricks Notebooks with Azure Data Factory


    Accreditation

    ITCE is a Certified Microsoft Learning Partner.


    Calendar

    Frequently Asked Questions

    Who should attend?

    The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course data analysts and data scientists who work with analytical solutions built on Microsoft Azure.

    Are there any prerequisites for this course?

    Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. 

    Specifically completing:

    Your Certification Journey Awaits!

    Get more information on how you can get certified through online proctored exam vouchers. Boost your career prospects now!


    Register







      Once you submit your registration, we will get in touch with you to confirm your interest and attendance.

      By continuing to use the site, you agree to the use of cookies. more information

      The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

      Close