Coursera
Coursera Logo

Microsoft - Data Integration with Microsoft Azure Data Factory 

  • Offered byCoursera

Data Integration with Microsoft Azure Data Factory
 at 
Coursera 
Overview

Duration

16 hours

Start from

Start Now

Total fee

Free

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Explore Free Course External Link Icon

Credential

Certificate

Data Integration with Microsoft Azure Data Factory
 at 
Coursera 
Highlights

  • Flexible deadlines Reset deadlines in accordance to your schedule.
  • Shareable Certificate Earn a Certificate upon completion
  • 100% online Start instantly and learn at your own schedule.
  • Course 3 of 10 in the Microsoft Azure Data Engineering Associate DP-203 Exam Prep Specialization
Read more
Details Icon

Data Integration with Microsoft Azure Data Factory
 at 
Coursera 
Course details

Skills you will learn
More about this course
  • In this course, you will learn how to create and manage data pipelines in the cloud using Azure Data Factory.
  • This course is part of a Specialization intended for Data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services. It is ideal for anyone interested in preparing for the DP-203: Data Engineering on Microsoft Azure exam (beta).

Data Integration with Microsoft Azure Data Factory
 at 
Coursera 
Curriculum

Integrate data with Azure Data Factory or Azure Synapse Pipeline

Introduction to the course

Understand Azure Data Factory

Data integration patterns

Explain the data factory process

Understand Azure Data Factory components

Azure Data factory Security

Lesson introduction

Manage integration runtimes

Lesson summary

Course syllabus

How to be successful in this course

Example - Set-up Azure Data Factory

Example - Create linked services

Example - Create datasets

Example - Create data factory activities and pipelines

Additional resources

Knowledge check

Knowledge check

Test prep

Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipeline

Lesson introduction

List the data factory ingestion methods

Describe data factory connectors

Understand data ingestion security considerations

Lesson summary

Example -Use the data factory copy activity - Example

Example - Manage the self-hosted integration runtime

Set up the Azure integration runtime

Additional resources

Knowledge check

Test prep

Perform code-free transformation at scale with Azure Data Factory or Azure Synapse Pipeline

Lesson introduction

Explain Azure Data Factory transformation methods

Debug mapping data flow

Lesson summary

Describe slowly changing dimensions

Choose between slowly changing dimension types

Lesson summary

Azure Data Factory transformation types

Exercise: Author an Azure Data Factory mapping data flow

Use Azure Data Factory wrangling data

Example - Use compute transformations within Azure Data Factory

Integrate SQL server integration services packages within Azure Data Factory

Additional resources

Exercise - Design and implement a Type 1 slowly changing dimension with mapping data flows

Exercise quiz

Knowledge check

Exercise quiz

Knowledge check

Test prep

Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipeline

Understand data factory control flow

Work with data factory pipelines

Debug data factory pipelines

Add parameters to data factory components

Execute data factory packages

Lesson summary

Exercise - Integrate a Notebook within Azure Synapse Pipelines

Excercise quiz

Knowledge check

Test prep

Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline

Describe SQL Server integration services

Understand the Azure SSIS Integration Runtime

Lesson summary

Example - Setup an Azure-SSIS Integration Runtime

Example - Run SSIS packages in Azure Data Factory

Example - Migrate SSIS packages to Azure Data Factory

knowledge check

Test prep

Operationalize your Azure Data Factory or Azure Synapse Pipeline

Lesson introduction

Manage source control of Azure Data Factory solutions

Lesson summary

Understand the language support in Azure Data Factory

Connect to a Git repository

Continuous integration and deployment

Monitor Azure Data Factory pipelines

Set up alerts for Azure Data Factory

Rerun Azure Data Factory pipelines

Knowledge check

Test prep

Receive data with Azure Data Share and transforming with Azure Data Factory

Module introduction

Ingest data into Azure Data Lake Gen 2 using Azure Data Factory?

Join and transform shared and owned data with Mapping Flow in Azure Data Factory

Sink dataset into Azure Synapse Analytics using Azure Data Factory

Publish a pipeline run in Azure Data Factory

Module summary

Exercise: Share and receive data using Azure Data Share and transform data using Azure Data Factory

Exercise: Ingest data into Azure Data Lake Storage Gen 2 with Azure Data Factory

Exercise: Join and transform shared and current dataset with Mapping Flow in Azure Data Factory

Exercise: Sink dataset into Azure Synapse Analytics with Azure Data Factory

Exercise: Publish a pipeline run in Azure Data Factory

Additional resources

Exercise quiz

Exercise quiz

Knowledge check

Exercise quiz

Exercise quiz

Knowledge check

Test prep

Course Practice Exam

Course 3 recap

Course wrap-up

About the practice exam

Next steps

Course practice exam

Data Integration with Microsoft Azure Data Factory
 at 
Coursera 
Admission Process

    Important Dates

    May 25, 2024
    Course Commencement Date

    Other courses offered by Coursera

    – / –
    3 months
    Beginner
    – / –
    20 hours
    Beginner
    – / –
    2 months
    Beginner
    – / –
    3 months
    Beginner
    View Other 6715 CoursesRight Arrow Icon
    qna

    Data Integration with Microsoft Azure Data Factory
     at 
    Coursera 

    Student Forum

    chatAnything you would want to ask experts?
    Write here...