Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Beginning Azure Data Factory - Build Data Ingestion

person icon Thulani Mngadi

4.1

Beginning Azure Data Factory - Build Data Ingestion

Learn Azure Data Factory by building a Metadata-driven Ingestion Framework as an industry standard

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Thulani Mngadi

English [CC]

category icon Microsoft Azure,IT & Software

Lectures -64

Resources -3

Duration -6 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

The main objective of this course is to help you to learn Data Engineering techniques of building Metadata-Driven frameworks with Azure Data Engineering tools such as Data Factory, Azure SQL, and others.

Building Frameworks are now an industry norm and it has become an important skill to know how to visualize, design, plan and implement data frameworks.

The framework that we are going to build together is referred to as the Metadata-Driven Ingestion Framework. 

Data ingestion into the data lake from the disparate source systems is a key requirement for a company that aspires to be data-driven, and finding a common way to ingest the data is a desirable and necessary requirement. 

Metadata-Driven Frameworks allow a company to develop the system just once and it can be adopted and reused by various business clusters without the need for additional development, thus saving the business time and costs. Think of it as a plug-and-play system.

The objective of the course is to onboard you onto the Azure Data Factory platform to help you assemble your first Azure Data Factory Pipeline. Once you get a good grip of the Azure Data Factory development pattern, then it becomes easier to adopt the same pattern to onboard other sources and data sinks.

Once you are comfortable with building a basic azure data factory pipeline,  as a second objective we then move on to building a fully-fledged and working metadata-driven framework to make the ingestion more dynamic. Furthermore, we will build the framework in such a way that you can audit every batch orchestration and individual pipeline runs for business intelligence and operational monitoring.

Goals

What will you learn in this course:

  • Introduction to Azure Data Factory
  • Unpack the requirements and technical architecture
  • Create an Azure Data Factory Resource
  • Create an Azure Blob Storage account
  • Create an Azure Data Lake Gen 2 Storage account
  • Learn how to use the Storage Explorer
  • Create Your First Azure Pipeline.
  • Metadata Driven Ingestion
  • Unpack the theory on Metadata Driven Ingestion
  • Describing the High-Level Plan for building the User
  • Creation of a dedicated Active Directory User and assigning appropriate permissions
  • Using Azure Data Studio
  • Creation of the Metadata Driven Database (Tables and T-SQL Stored Procedure)
  • Event-Driven Ingestion
  • Enabling the Event Grid Provider
  • Use the Getmetadata Activity
  • Use the Filter Activity
  • Create Event-Based Triggers
  • Create and Merge new DevOps Branches

Prerequisites

What are the prerequisites for this course?

  • Basic PC / Laptop
Beginning Azure Data Factory - Build Data Ingestion

Curriculum

Check out the detailed breakdown of what’s inside the course

First Azure Pipeline
9 Lectures
  • play icon Introduction 05:05 05:05
  • play icon Register Free Azure Account 04:14 04:14
  • play icon Introduction to Azure Data Factory 03:43 03:43
  • play icon Discuss Requirement and Technical Architecture 02:09 02:09
  • play icon Create A Data Factory Resource 08:39 08:39
  • play icon Create Storage Account and Upload Data 07:32 07:32
  • play icon Create Data Lake Gen 2 Storage Account 05:51 05:51
  • play icon Download Storage Explorer 04:28 04:28
  • play icon Create Your First Azure Pipeline 16:28 16:28
Metadata Driven Ingestion
35 Lectures
Tutorialspoint
Event Driven Ingestion
19 Lectures
Tutorialspoint
Resources
1 Lectures
Tutorialspoint

Instructor Details

user profile image

Thulani Mngadi

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515