All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 3 Days!

Browse Library

Azure Data Factory V2: A Premium Practical Guide to Mas

Master Azure Data Factory, Azure Integration Tool, Azure Cloud ETL & ELT Tool, Microsoft Certification DP-200 & DP-201

Instructed by Sujeet Singh

7 days left at this price!
Get Unlimited Courses Access $29
It Includes
  • Get Full Access to the platform
  • Access to 16000+ online courses
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Free Instructor Support
  • Access valid for 1 user only
  • Cancel Anytime
  • Student will learn how to utilize Azure Data Factory ,a cloud based integration service to design and develop different pipelines to move data from on premise to Azure Cloud and inter cloud sources.
  • One and only course on Udemy which covers best practices with respect to design performance oriented and efficient data movement pipelines and transformations using Azure Data Factory tool.
  • DP-200 Exam Topics: Implement the integration runtime for Data Factory, Implement Copy Activity within Azure Data Factory, Create linked services and datasets, Create pipelines and activities, Implement Mapping Data Flows in Azure Data Factory, Create and schedule triggers, Monitor Data Factory pipelines
  • This course is packed with different assignments and hand on practical to enable students get expertise in designing different pipelines to meet day to day need of a cloud data engineer.

In this course, students will learn how to use Azure Data Factory V2 (cloud based data integration service) to design data movement pipelines and transformation workloads. This course is a complete guide to data enthusiasts to understand each and every building blocks of Azure Data Factory. They will get practical exposure to use and implement different components of Azure Data Factory with basic overview of their settings and configuration. This course is enriched with best practices and recommended steps to design optimized data pipelines. After completing this course, one can easily design basic to medium complex level data movement pipelines with competency of using best practices and recommended techniques to build efficient data movement workloads.  This course will enable students to qualify Microsoft Certification Exam DP 200 & DP 201 and make them capable of solving scenario based questions asked in these exams.  This course covers industry level implementation and use cases.

  • Basic concept of data and data bases.
  • Requires laptop and internet connectivity.
  • Need to opt for Azure Trial Subscription (free of cost) to practice.
  • ETL Developer, Data Engineers, Data Architect, Data Integration Engineers and Cloud Enthusiasts
View More...

Section 1 : Introduction to Azure Data Factory

  • Lecture 1 :
  • What is Azure Data Factory? Preview
  • Lecture 2 :
  • Provisioning Azure Data Factory V2 in Azure Portal
  • Lecture 3 :
  • Lab Spin-Up Azure Data Factory V2 in Azure Portal
  • Lecture 4 :
  • Check what You have Learnt
  • Test quiz on basic fundamentals we learned in this Section

Section 2 : Basic Entities and Building Blocks of Azure Data Factory V2

  • Lecture 1 :
  • Basic Overview of ETL and ELT
  • Lecture 2 :
  • Azure Data Factory Building Blocks and Fundamental Entities
  • Lecture 3 :
  • What is Integration Runtime?
  • Lecture 4 :
  • Lab: Steps to Setup Integration Runtime
  • Lecture 5 :
  • Repository Integration in Azure Data Factory
  • Lecture 6 :
  • Lab : Walkthrough the Azure Data Factory Workspace
  • Lecture 7 :
  • Basic Overview of Data Integration Unit (DIU)

Section 3 : Practical & Theoretical Lesson on Control Flow Activities

  • Lecture 1 :
  • Copy Data Activity
  • Lecture 2 :
  • Data Flow Activity
  • Lecture 3 :
  • Lookup Activity
  • Lecture 4 :
  • GET Metadata Activity
  • Lecture 5 :
  • Execute Pipeline Activity
  • Lecture 6 :
  • Execute SSIS Package Activity
  • Lecture 7 :
  • Stored Procedure Activity
  • Lecture 8 :
  • Validation Activity
  • Lecture 9 :
  • Wait Activity
  • Lecture 10 :
  • Web Activity
  • Lecture 11 :
  • Web Hook Activity
  • Lecture 12 :
  • For Each Activity
  • Lecture 13 :
  • If Condition Activity
  • Lecture 14 :
  • Switch Activity
  • Lecture 15 :
  • Until Activity
  • Lecture 16 :
  • Assignment for Control Flow Activities

Section 4 : Data Flow Transformation

  • Lecture 1 :
  • Data Flow Introduction
  • Lecture 2 :
  • Data Flow Source And Sink
  • Lecture 3 :
  • How to spin your first Data Flow in Data Factory
  • Lecture 4 :
  • How to Execute Data Flow
  • Lecture 5 :
  • Sorting, Alter and Aggregation Transformation in Mapping Data Flow
  • Lecture 6 :
  • Derived Column Transformation
  • Lecture 7 :
  • JOIN Transformation
  • Lecture 8 :
  • Assignment

Section 5 : Trigger, Scheduling and Monitoring Pipelines

  • Lecture 1 :
  • Monitoring Data Factory Pipelines
  • Lecture 2 :
  • Manage Data Factory Visually
  • Lecture 3 :
  • Triggers and Scheduling
  • Lecture 4 :
  • Lab: Create Triggers
  • Lecture 5 :
  • Lab: Monitor Pipeline Execution
  • Lecture 6 :
  • Lab: Create Alerts and Notifications

Section 6 : Best Practices in Azure Data Factory

  • Lecture 1 :
  • Best Practices Part - 1
  • Lecture 2 :
  • Best Practices Part - 2
  • Lecture 3 :
  • Bulk Table Load (Concepts)
  • Lecture 4 :
  • Lab: Bulk SQL Table Load
  • Lecture 5 :
  • Incremental Load ( Walk Through)

Section 7 : Industry Use Cases and Real World Examples

  • Lecture 1 :
  • Lab: Incremental Load
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Sujeet Singh,

- Microsoft Certified Solution Expert: Data Management and Analytics & Microsoft Certified Cloud Data Engineer - Expertise of working on cloud based technologies like Azure Synapse, Azure Data Factory and Azure Databricks. Experience of designing data solution in Azure Cloud to support Analytics and Business Intelligence need. - Experience of designing ELT and ETL solution and implementing Data Warehouse in cloud as well as on premise. - 8 + years of experience of working on Microsoft BI suite, Microsoft Azure and Big Data Ecosystems - Have worked on more than 5 enterprise level migration projects to migrate Big Data architectures from on premise to Big Data cloud platform. - Work as freelancer, consultant and trainer.
View More...

Administering System Center Config...

By : Microsoft

Lecture 12


Deploying Windows Desktops and Ent...

By : Microsoft

Lecture 12


Planning for and Managing Devices i...

By : Microsoft

Lecture 13


Cisco CCNA R/S (200-125): The Compl...

By : Lazaro (Laz) Diaz

Lecture 153


Implementing & Configuring Cisco Ro...

By : Dariusz Lipski

Lecture 10


CCNP Switch (300-115): The Complete...

By : Lazaro (Laz) Diaz

Lecture 93

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email address and we'll send you a link to reset your password.