Integrate data with Azure Data Factory or Azure Synapse Pipeline-Welcome to the course
Introduction to the course
()
Course syllabus
How to be successful in this course
Integrate data with Azure Data Factory or Azure Synapse Pipeline-Understand Azure Data Factory
Understand Azure Data Factory
()
Data integration patterns
()
Explain the data factory process
()
Understand Azure Data Factory components
()
Azure Data factory Security
()
Integrate data with Azure Data Factory or Azure Synapse Pipeline-Set up and manage Azure Data Factory
Lesson introduction
()
Example - Set-up Azure Data Factory
Example - Create linked services
Example - Create datasets
Example - Create data factory activities and pipelines
Manage integration runtimes
()
Lesson summary
()
Additional resources
Petabyte-scale ingestion with Azure Data Factory or Azure Synapse Pipeline-Ingest source data
Lesson introduction
()
List the data factory ingestion methods
()
Describe data factory connectors
()
Example -Use the data factory copy activity - Example
Example - Manage the self-hosted integration runtime
Set up the Azure integration runtime
Understand data ingestion security considerations
()
Lesson summary
()
Additional resources
Perform code-free transformation at scale with Azure Data Factory or Azure Synapse Pipeline-Lesson introduction
Lesson introduction
()
Explain Azure Data Factory transformation methods
()
Azure Data Factory transformation types
Exercise: Author an Azure Data Factory mapping data flow
Debug 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
Lesson summary
()
Additional resources
Perform code-free transformation at scale with Azure Data Factory or Azure Synapse Pipeline-Populate slowly changing dimensions in Azure Synapse Analytics pipelines
Describe slowly changing dimensions
()
Choose between slowly changing dimension types
()
Exercise - Design and implement a Type 1 slowly changing dimension with mapping data flows
Lesson summary
()
Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipeline-Orchestrate data movement and transformations
Understand data factory control flow
()
Work with data factory pipelines
()
Debug data factory pipelines
()
Add parameters to data factory components
()
Exercise - Integrate a Notebook within Azure Synapse Pipelines
Execute data factory packages
()
Lesson summary
()
Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline-SQL Server Integration Services (SSIS)
Describe SQL Server integration services
()
Understand the Azure SSIS Integration Runtime
()
Example - Setup an Azure-SSIS Integration Runtime
Example - Run SSIS packages in Azure Data Factory
Example - Migrate SSIS packages to Azure Data Factory
Lesson summary
()
Operationalize your Azure Data Factory or Azure Synapse Pipeline-Use Azure Data Factory to build your data integration solutions
Lesson introduction
()
Understand the language support in Azure Data Factory
Manage source control of Azure Data Factory solutions
()
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
Lesson summary
()
Receive data with Azure Data Share and transforming with Azure Data Factory-Ingest data from Azure Data Share into Azure Data Factory pipelines
Module introduction
()
Exercise: Share and receive data using Azure Data Share and transform data using Azure Data Factory
Ingest data into Azure Data Lake Gen 2 using Azure Data Factory
()
Exercise: Ingest data into Azure Data Lake Storage Gen 2 with Azure Data Factory
Receive data with Azure Data Share and transforming with Azure Data Factory-Join and transform shared and owned data
Join and transform shared and owned data with Mapping Flow in Azure Data Factory
()
Exercise: Join and transform shared and current dataset with Mapping Flow in Azure Data Factory
Sink dataset into Azure Synapse Analytics using Azure Data Factory
()
Exercise: Sink dataset into Azure Synapse Analytics with Azure Data Factory
Publish a pipeline run in Azure Data Factory
()
Exercise: Publish a pipeline run in Azure Data Factory
Module summary
()
Additional resources
Course Practice Exam-Practice Exam on Data integration at scale with Azure Data Factory or Azure Synapse Pipeline
Course 3 recap
()
About the practice exam
Course Practice Exam-Course wrap up
Course wrap-up
()
Next steps