Data Integration with Microsoft Azure Data Factory
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).
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- المدة 16 ساعات hours
- الطبع بواسطة Microsoft
-
Offered by
عن
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). This is the third course in a program of 10 courses to help prepare you to take the exam so that you can have expertise in designing and implementing data solutions that use Microsoft Azure data services. The Data Engineering on Microsoft Azure exam is an opportunity to prove knowledge expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. Each course teaches you the concepts and skills that are measured by the exam. By the end of this Specialization, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure (beta).الوحدات
Welcome to the course
-
1
Videos
-
2
Readings
-
1
Discussion
1
Discussions
- Meet and greet
1
Videos
- Introduction to the course
2
Readings
- Course syllabus
- How to be successful in this course
Understand Azure Data Factory
-
5
Videos
-
1
Plugin
-
1
Assignment
1
Assignment
- Knowledge check
5
Videos
- Understand Azure Data Factory
- Data integration patterns
- Explain the data factory process
- Understand Azure Data Factory components
- Azure Data factory Security
Set up and manage Azure Data Factory
-
3
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
3
Videos
- Lesson introduction
- Manage integration runtimes
- Lesson summary
5
Readings
- Example - Set-up Azure Data Factory
- Example - Create linked services
- Example - Create datasets
- Example - Create data factory activities and pipelines
- Additional resources
Ingest source data
-
5
Videos
-
4
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
5
Videos
- Lesson introduction
- List the data factory ingestion methods
- Describe data factory connectors
- Understand data ingestion security considerations
- Lesson summary
4
Readings
- Example -Use the data factory copy activity - Example
- Example - Manage the self-hosted integration runtime
- Set up the Azure integration runtime
- Additional resources
Lesson introduction
-
4
Videos
-
6
Readings
-
1
Plugin
-
2
Assignment
2
Assignment
- Exercise quiz
- Knowledge check
4
Videos
- Lesson introduction
- Explain Azure Data Factory transformation methods
- Debug mapping data flow
- Lesson summary
6
Readings
- 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
Populate slowly changing dimensions in Azure Synapse Analytics pipelines
-
3
Videos
-
1
Readings
-
3
Assignment
3
Assignment
- Exercise quiz
- Knowledge check
- Test prep
3
Videos
- Describe slowly changing dimensions
- Choose between slowly changing dimension types
- Lesson summary
1
Readings
- Exercise - Design and implement a Type 1 slowly changing dimension with mapping data flows
Orchestrate data movement and transformations
-
6
Videos
-
1
Readings
-
3
Assignment
3
Assignment
- Excercise quiz
- Knowledge check
- Test prep
6
Videos
- 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
1
Readings
- Exercise - Integrate a Notebook within Azure Synapse Pipelines
SQL Server Integration Services (SSIS)
-
3
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- knowledge check
- Test prep
3
Videos
- Describe SQL Server integration services
- Understand the Azure SSIS Integration Runtime
- Lesson summary
3
Readings
- Example - Setup an Azure-SSIS Integration Runtime
- Example - Run SSIS packages in Azure Data Factory
- Example - Migrate SSIS packages to Azure Data Factory
Use Azure Data Factory to build your data integration solutions
-
3
Videos
-
6
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
3
Videos
- Lesson introduction
- Manage source control of Azure Data Factory solutions
- Lesson summary
6
Readings
- 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
Ingest data from Azure Data Share into Azure Data Factory pipelines
-
2
Videos
-
2
Readings
-
3
Assignment
3
Assignment
- Exercise quiz
- Exercise quiz
- Knowledge check
2
Videos
- Module introduction
- Ingest data into Azure Data Lake Gen 2 using Azure Data Factory
2
Readings
- 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
Join and transform shared and owned data
-
4
Videos
-
4
Readings
-
4
Assignment
4
Assignment
- Exercise quiz
- Exercise quiz
- Knowledge check
- Test prep
4
Videos
- 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
4
Readings
- 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
Practice Exam on Data integration at scale with Azure Data Factory or Azure Synapse Pipeline
-
1
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Course practice exam
1
Videos
- Course 3 recap
1
Readings
- About the practice exam
Course wrap up
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Course wrap-up
1
Readings
- Next steps
Auto Summary
Enhance your data engineering skills with "Data Integration with Microsoft Azure Data Factory," a course focused on creating and managing cloud data pipelines using Azure Data Factory. Led by Coursera, this professional-level course is part of a 10-course specialization aimed at data engineers and developers preparing for the DP-203: Data Engineering on Microsoft Azure exam. Over 960 minutes, you'll gain expertise in integrating, transforming, and consolidating data for analytics solutions. Subscription options include Starter and Professional plans. Ideal for those seeking to demonstrate their proficiency in Microsoft Azure data services.
Microsoft