Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Data integration at scale with Azure Data Factory or Azure Synapse Pipeline

Microsoft via Microsoft Learn

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
  • Integrate data with Azure Data Factory

    In this module, you will:

    • Understand Azure Data Factory
    • Describe data integration patterns
    • Explain the data factory process
    • Understand Azure Data Factory components
    • Azure Data Factory security
    • Set up Azure Data Factory
    • Create linked services
    • Create datasets
    • Create data factory activities and pipelines
    • Manage integration runtime
  • Petabyte-scale ingestion with Azure Data Factory
    • Introduction
    • List the data factory ingestion methods
    • Describe data factory connectors
    • Exercise: Use the data factory copy activity
    • Exercise: Manage the self hosted integration runtime
    • Exercise: Set up the Azure integration runtime
    • Understand data ingestion security considerations
    • Knowledge check
    • Summary
  • Perform code-free transformation at scale with Azure Data Factory
    • Introduction
    • Explain Data Factory transformation methods
    • Describe Data Factory transformation types
    • Use Data Factory mapping data flow
    • Debug mapping data flow
    • Use Data Factory wrangling data
    • Use compute transformations within Data Factory
    • Integrate SQL Server Integration Services packages within Data Factory
    • Knowledge check
    • Summary
  • Orchestrate data movement and transformation in Azure Data Factory
    • Introduction
    • Understand data factory control flow
    • Work with data factory pipelines
    • Debug data factory pipelines
    • Add parameters to data factory components
    • Execute data factory packages
    • Knowledge check
    • Summary
  • Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
    • Introduction
    • Describe SQL Server Integration Services
    • Understand the Azure-SIS integration runtime
    • Set-up Azure-SIS integration runtime
    • Run SSIS packages in Azure Data Factory
    • Migrate SSIS packages to Azure Data Factory
    • Knowledge check
    • Summary
  • Operationalize your Azure Data Factory pipelines

    In this module, you will:

    • Configure a git repository with a development factory
    • Create and merge a feature branch
    • Deploy a release pipeline
    • Visually monitor pipeline runs
    • Integrate with Azure Monitor
    • Set up alerts
    • Rerun pipeline runs
    • Learn about Azure Data Factory security

Syllabus

  • Integrate data with Azure Data Factory
    • Introduction
    • Understand Azure Data Factory
    • Describe data integration patterns
    • Explain the data factory process
    • Understand Azure Data Factory components
    • Azure Data Factory security
    • Set-up Azure Data Factory
    • Create linked services
    • Create datasets
    • Create data factory activities and pipelines
    • Manage integration runtimes
    • Module assessment
    • Summary
  • Petabyte-scale ingestion with Azure Data Factory
    • Introduction
    • List the data factory ingestion methods
    • Describe data factory connectors
    • Exercise - Use the data factory copy activity
    • Exercise - Manage the self-hosted integration runtime
    • Exercise - Set up the Azure integration runtime
    • Understand data ingestion security considerations
    • Module assessment
    • Summary
  • Perform code-free transformation at scale with Azure Data Factory
    • Introduction
    • Explain Azure Data Factory transformation methods
    • Describe Azure Data Factory transformation types
    • Exercise - Author an Azure Data Factory mapping data flow
    • Debug mapping data flow
    • Exercise - Use Azure Data Factory wrangling data
    • Exercise - Use compute transformations within Azure Data Factory
    • Exercise - Integrate SQL server integration services packages within Azure Data Factory
    • Module assessment
    • Summary
  • Orchestrate data movement and transformation in Azure Data Factory
    • Introduction
    • Understand data factory control flow
    • Work with data factory pipelines
    • Debug data factory pipelines
    • Add parameters to data factory components
    • Execute data factory packages
    • Module assessment
    • Summary
  • Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
    • Introduction
    • Describe SQL Server integration services
    • Understand the Azure SSIS Integration Runtime
    • Set-up Azure SSIS Integration Runtime
    • Run SSIS packages in Azure Data Factory
    • Migrate SSIS packages to Azure Data Factory
    • Module assessment
    • Summary
  • Operationalize your Azure Data Factory pipelines
    • Introduction
    • Understand the language support in Azure Data Factory
    • Manage source control of Azure Data Factory solutions
    • Continuous integration and deployment
    • Monitor Azure Data Factory pipelines
    • Set up alerts for Azure Data Factory
    • Rerun Azure Data Factory pipelines
    • Understand Azure Data Factory security
    • Module assessment
    • Summary

Reviews

Start your review of Data integration at scale with Azure Data Factory or Azure Synapse Pipeline

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.