Instructor Led Training 36 Hours
Exercises & Project Work 30 Hours
May 30th Sat & Sun 7 AM IST (GMT +5:30) ENROLL NOW
June 7th Sat & Sun 5 PM IST (GMT +5:30) ENROLL NOW
June 13th Sat & Sun 5 PM IST (GMT +5:30) ENROLL NOW

Microsoft Azure Data Factory certification training by Eduranz is designed and structured by industry experts, based on Microsoft DP-200 & DP-201 exam outlines. This intense training program covers everything, from scratch to advanced level. Eduranz’s industry oriented training program on Microsoft Azure Data Factory not only prepares you for the certification exams but makes you industry-ready by guiding you with multiple hands-on activity, assignments, and a real world scenario-based capstone project.

Course Syllabus

Introduction to Azure Data factory Details FREE 00:25:00
Capabilities in the Data Flow Details 00:25:00
Blocking and Non blocking Concept Details 00:25:00
Lookup Task Details 00:25:00
Configuration External Part , Parameters of SSIS , Administrating the SSIS Packages Details 00:25:00
Data Warehouse , OLTD , Transactional Database , ER Model Details 00:25:00
Snow Flake Schema , Star Schema , DIM Details 00:25:00
Data Flow Task , Fact, Dimensions , Businesskey Types Details 00:25:00
Tabular Queue in SSIS , Infrastructure of SSIS Details 00:25:00
Azure Storage , File Share , Queue and Table Storage , Blob Details 00:25:00
Database , Data Tire Application , Pipeline , SQL Details 00:25:00
section 12
Azure data lake , BLOB vs DWH vs ADL , Azure data lake storage , Ingest store analyse , Ingest data , Install azure CLI , Azure data lake analytics Details 00:25:00
testing Details 00:00:00

About Course

Today, data has become a fuel for companies all across the industry. In the time when every business is moving to the cloud, data integration has become a major issue. But Microsoft Azure Data Factory makes the process smooth and efficient. That’s why Azure Data factory is booming right now, so is the demand for Microsoft Azure Data Engineers. This training helps you clear Microsoft DP-200 and DP-201 exams, so that you can earn the Microsoft Azure Data Engineer Associate certification.

  • • Introducing Azure cloud
  • • Azure security
  • • Azure SQL DB
  • • Azure data factory
  • • Blob
  • • Azure data lake storage
  • • Azure SQL Data Warehouse
  • • Data bricks
  • • Azure stream analytics
  • • Cosmos DB
  • • Hive and Spark integration

  • • Anyone who’s interested in making a career in cloud computing
  • • Anyone who is familiar with or having work experience in the following domains wanting to upskill or shift career: Big Data Hadoop, MSBI, Informatica, Tableau, MS SQL Server/Desktop and Data warehouse.

  • • Basic knowledge of cloud computing is enough. Although it is not necessary. You leave it on us. Our training program covers everything from scratch to advanced levels.

Companies today are moving to cloud to meet customer expectations faster, which is helping businesses grow and stay ahead in the competition. Microsoft Azure is one of the top players when it comes to the Cloud Computing market and is growing at an unprecedented pace. According to Goldman Sachs’ December 2019, report on an information-technology spending survey of 100 IT executives at Global 2000 companies, 56 executives are using Azure for cloud infrastructure, and 48 are using AWS. Therefore, there is an urgent need for certified Azure Professionals.

According to a recent study by Indeed, In India, the average salary of a Certified Azure Data Engineer ranges from 10 lac to 15 lac per year and in the US, it ranges from $120k to $145k per year.

Upon completion of the training Program along with mini projects, hands-on activities, and assignments, you will be working on the industry-oriented capstone project. After you successfully complete the capstone project, you will be awarded with an industry-recognized certificate by Eduranz.

  • • GE Renewable Energy
  • • Microsoft
  • • Loyalytics Consulting and many more (Source: Indeed)

Microsoft Data Factory Engineer designs and implements the management, monitoring, security, and privacy of data using the full stack of Azure data services to satisfy business needs.


Introduction to cloud computing

• Why Cloud Computing?

• Different Cloud Computing Models like SaaS, PaaS and Iaas

• Understanding Hybrid Cloud

• How is azure a leader in the cloud market?

• Importance of of Data Warehouse, ETL and Analytics with cloud

• What is Microsoft Azure Data Factory? 

• Overview of its workflow and different services in it

  • • Intro to non-relational data stores
  • • Intro to Cosmos DB, Data Lake Storage and Blob Storage
  • • Why Cosmos DB?
  • • Working with Cosmos DB
  • • Implement a solution that uses Cosmos DB
  • • Why Data Lake?
  • • Working with Data Lake
  • • Implement a solution that uses Data Lake Storage Gen2
  • • Why Blob Storage?
  • • Working with Blob Storage
  • • Implement a solution that uses Blob storage
  • • Implement data distribution and partitions
  • • Implement a consistency model in Cosmos DB
  • • Provision a non-relational data store
  • • Provide access to data to meet security requirements
  • • Understanding High Availability, disaster recovery and global distribution
  • • Implement for high availability, disaster recovery, and global distribution

  • • Intro to relational database and data stores
  • • Understand elastic pools in a data store
  • • Configuring elastic pools
  • • Configuring geo-replication
  • • Provide access to data for meeting the security requirements
  • • Implement for high availability, disaster recovery, and global distribution in relational data stores
  • • What is Azure Synapse Analytics and why is it important?
  • • Implement data distribution and partitions for Azure Synapse Analytics
  • • Understanding the relevance of PolyBase
  • • Implement PolyBase

  • • Understand the data masking
  • • Implement data masking
  • • Encrypt data at rest and in motion

  • • What is Azure Databricks?
  • • What is Azure Data Factory?
  • • Why Azure Databricks?
  • • Why Azure Data Factory?
  • • Develop batch processing solutions by using Data Factory and Azure Databricks
  • • Understanding the concept behind data ingestion
  • • What is PolyBase?
  • • Understanding the workflow of PolyBase
  • • Ingest data by using PolyBase
  • • Implement the integration runtime for Data Factory
  • • Implement Copy Activity within Azure Data Factory
  • • Create linked services and datasets
  • • Create pipelines and activities in Data Factory
  • • Implement Mapping Data Flows in Azure Data Factory
  • • Create and schedule triggers in Azure Data Factory
  • • Implement Azure Databricks clusters, notebooks, jobs, and autoscaling
  • • Ingest data into Azure Databricks
  • • Creating the whole data lifecycle in Azure Data Factory

  • • What is Azure Stream Analytics?
  • • Why Azure Stream Analytics?
  • • Configure input and output
  • • Select the appropriate windowing functions
  • • Implement event processing by using Stream Analytics

  • • Monitoring in Azure Data Factory
  • • What is Azure Monitor?
  • • Why use Azure Monitor?
  • • Understanding Azure Log Analytics
  • • Why Azure Log Analytics?
  • • Implement monitoring in Blob Storage
  • • Implement monitoring in Data Lake Storage 
  • • Implement monitoring in SQL Database 
  • • Implement monitoring in Azure Synapse Analytics
  • • Implement monitoring in Cosmos DB 
  • • Configuring alerts in Azure Monitor 
  • • Implement auditing by using Azure Log Analytics

  • • Monitoring Data Factory pipelines
  • • Monitoring Azure Databricks
  • • Monitoring Stream Analytics
  • • Configuring alerts in Azure Monitor in the data processing
  • • Implement auditing by using Azure Log Analytics in the data processing

  • • Troubleshoot data partitioning bottlenecks
  • • Optimize Data Lake Storage
  • • Optimize Stream Analytics
  • • Optimize Azure Synapse Analytics
  • • Optimize SQL Database
  • • Manage the data lifecycle


Project: In order to promote marketing advertisements, identify the videos with maximum traffic from selected channels based on real-time YouTube data.`

Industry: Internet

Problem Statement: You work for a company called AzureSure. They are planning to run some advertisement campaigns on YouTube in order to promote the latest version of the products. But before investing in the campaign, your task is to study the traffic in selected YouTube channels. In other words, you need to identify YouTube channels in the same domain as your product and monitor the analytics of traffic on those channels. But the whole process should be automated. So, as a Microsoft Azure Data Engineer, you are supposed to automate the transformation of a real-time video list from those YouTube channels. Remember the data has to be studied on a weekly basis. 

Data can be collected from YouTube API. Also, take a look at the parameters for selecting the potential target YouTube channels and analyzing traffic. 

  • • Number of subscribers
  • • Number of views
  • • Number of likes and comments


John Martis

Head Sales - Fujitsu

Passionate Instructors

Eduranz Serves its purpose very well. I enrolled for Azure Data Factory with very High Expectations because Eduranz was referred by one of my colleagues.
Questions and answers with the instructor were particularly helpful. Very nice training. The instructor was passionate about the course, was helpful in understanding the requirements for setting up plans and approval processes; helpful knowing what applies to my specific situation.

Haitham Foda

Founder & CEO - Etqan-Tech

Awesome learning methodology

Awesome learning methodology. I have taken Azure Data Factory online training from Eduranz and it was worth of every penny i spent.

Prashant Gera

Software Development Manager - Amazon USA

Enjoyed the training

I always enjoyed the training classes at eduranz!. The exciting part of the lectures was always the Q&A session at the end of the lecture where I got to hear some practical/real-world tips and directions from the instructor.

Rajeev Kathuria

West Head-Partner Management - Samsung

Good Work eduranz!

The instructor was very good and prompt in responding to questions. Excellent virtual class experience. Good Work eduranz!

Avni Ahuja

Assistant Vice President - GENPACT

Awesome learning methodology

Awesome learning methodology. Instructors are directly from IT Industry to share the real challenges to stand and maintain required skills in current IT Industry.



Personal Mentor

At the time of enrollment team Eduranz will assign one mentor for you and he will be guiding you in this lifetime Journey.

24/7 Tech Adviser Support

Lifetime 24/7 Technical and Non Technical Support from team Eduranz.

Lifetime Access

Get Lifetime opportunity to access and attend the live sessions multiple times.

Assignments & Quizzes

Every module will be followed by certification based assessment and quiz.


Become a Certified Professional.

Job Assistance

Team Eduranz will update your Resume before forwarding it to our 60+ global Clients.


Eduranz offers unique online Azure Data Factory course for professionals who are willing to expand their knowledge as well as skills in Azure, and kick-start their career in this rousing domain. There are many reasons to choose Eduranz:
• Interactive online instructor-led live classes conducted by SMEs
• Personal mentors who will keep a stage track of your progress in Azure Data Factory course
• A Substantial LMS which allows the users to view their recorded sessions from their live classes along with the self-recorded courses
• Real-time exercises, assignments, industry-based use cases and real-world projects
• 24/7 learning support by the Eduranz’s dedicated tech support team
• Large community of learners from across the globe
• Industrially as well as globally recognized certificate by Eduranz
• Personalized job support, resume and interview preparation

You never miss any lecture at Eduranz, because you will be provided with the recorded sessions of the live class on your LMS within 24 hours and despite that, you can also attend any different live session to cover up the missed topic and ask your doubts from the trainer or you can simply re-schedule your batch and get yourself a new batch assigned.

Live Virtual Classes or Online Classes: With online class training, you can access courses via video conferencing from your desktop to increase productivity and reduce work time and personal time. Independent study online: In this mode, you will receive videos with lectures and can continue the course as you wish.

Eduranz offers a 24/7 request solution and you can pick up your tickets at any time from our dedicated support team. You can use email support for all your questions. If your request is not answered via email, we can also arrange one-on-one discussions with the faculty. You will be glad to know that you can switch to Eduranz support after completing the training. We also don’t limit the number of tickets you can collect when solving questions and doubts.

Eduranz actively supports all trainees who have successfully completed the training. That’s why we are involved in more than 80 top MNCs worldwide. This way you can be in exclusive organizations such as Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, Cisco and other similar-sized companies. We also support you during job interviews and preparation of your CV. Is it possible to switch from independent training to teacher-led training? In any case, you can switch from self-directed self-training to online training only by paying an additional amount and participating in the next set of training that will be specifically notified to you.

Our job assistance program will help you reach the job that you have been seeking. In our support program, we help you by sharing your resume with the companies that we have tie ups with, along with helping you in resume building, getting your prepared for the interviews through mock sessions by our industry experts (from various companies like IBM, Microsoft, Accenture, Deloitte etc.), also by providing you with mock interview questions and exhaustive session by Eduranz. However, Eduranz is not a recruitment or job agency, we do not guarantee you a job, we simply direct your resumes to different companies, then after that, entire process is handled by the employer and company and the result is totally based on the employer’s decision.

After completing the Eduranz Training Program along with all real projects, tests and assignments and achieving at least 60% points in the qualification exam; You will receive an industrial recognized certificate by Eduranz. This certification is recognized by Eduranz’s partner organizations, which includes a lot of top MNCs worldwide that are also part of the Fortune 500 list

Our job assistance program will help you reach the job that you have been seeking. In our support program, we help you by sharing your resume with the companies that we have tie ups with, along with helping you in resume building, getting your prepared for the interviews through mock sessions by our industry experts (from various companies like IBM, Microsoft, Accenture, Deloitte etc.), also by providing you with mock interview questions and exhaustive session by Eduranz. However, Eduranz is not a recruitment or job agency, we do not guarantee you a job, we simply direct your resumes to different companies, then after that, entire process is handled by the employer and company and the result is totally based on the employer’s decision.

All the instructors at Eduranz are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are the subject matter experts and are trained by Eduranz itself for providing an awesome learning experience.

  • 29,999 14,999
  • Average Rating5
  • I am a custom Detail
  • Prince Pandey
  • Lifetime Access with Up-gradation
  • 24*7 Lifetime Support
  • Flexible Schedule
  • Certification with Job Assistance

© 2019 Eduranz. All rights Reserved.  

Terms & Condition | Privacy Policy | Refund Policy | Contact Us | Blog

Open chat
Powered by