Curriculum:
- What is ETL
- What is DWH
- What is Data Engineering
- What is cloud
- Advantage of Azure cloud
- Azure basics
- introduction to cloud computing
- Different cloud computing models like SaaS, PaaS and laas .
- Design , publish and Trigger options in ADF.
- ETL Concepts , ADF Architecture and pipelining .
- Compression option ; mapping data flow & wrangling data flow .
- What is Microsoft Azure data factory ?
- Use of ETL Difference between SSIS and ADF.
- What is SSIS package.
- What is SSIS Connection manager , SSIS data flow .
- ADF pipe lines with stored procedures for ETL.
- What is ADF integration runtime
- What is SSIS source and destination.
- Implementing storage
- Understand cloud storage
- Azure Files
- Blobs , Storage Queues , Tables
- Azure BLOB Storage Container – incremental Data Load
- Types of Storage Container – incremental Data Load
- Types of storage accounts, Storage Replications ,Storage access tiers .
- Transforming Data from blob to blob
- What is filepath in dataset .
- What is wildcard file path
- What is prefix.
- List of files
- Use of parameters
- What is dynamic content
- Working with dataset and pipeline parameters
- Use of SQl Database
- What is RDBMS
- How many types of data’s available ?
- Creating SQL Server, SQL Data Base, creating table , inserting data .
- Transforming data from Azure SQL to blob.
- Blob to Azure SQL.
- With schema how to transform ?
- Without schema how to transform data.
- Copy data , Get metadata , for each
- Until, if condition , switch, Set variable
- Auto resolve integration runtime.
- Self-hosted integration runtime .
- SSIS integration runtime .
- Self-hosted configuration types.
- Working with self-hosted integration runtime
- Onprem SQL Data to Azure SQL, Azure Storage file system
- What is Azure storage
- What is Azure data lake storage
- What is use of distributed file system ?
- What is cluster .
- HDFS, name node , data node
- Job tracker, Task tracker , Data node
- Working with GIT.
- Differences between GIT and TFVC.
- Master Brach
- Collaboration Brach
- Github.com
- Creating account in Github.com Git integration with ADF>
- What is trigger
- What is use of synchronize event & Asyncronized event?
- Working with storage event , working with schedule event .
- Working with tumbling window Trigger .
- What is offset, window Size , Self Dependency
- What is other trigger dependency
- What is use of data flow ?
- Working with joins
- Working with conditional split , with unions
- Working with select , working with derived column.
- Working with pivot
- Use of My SQL
- Creating My SQL
- Transforming data from My SQL.
- Use of cosmos DB
- SQL VS No SQL
- Creating Cosmos DB
- Transforming data from cosmos DB
- Understand the data Masking
- Implement data masking
- Encrypt data at rest and in motion
- Monitoring in Azure data factory
- What is Azure motion?
- Why use Azure Motion ?
- Understanding Azure Log analytics ?
- Why Azure Log analytics ?
- Use of error handling
- Success
- Failure
- Skipped
- Complition
- Use of key voult
- Access Policies
- Secret key
- How to work with Azure key vault
- Project 1
- Project 2
Fee:
Online Virtual Class Room
Enroll in any above batch and attend live class at scheduled time
18000Upcoming Batches:
FAQ:
1.Where we can use Azure Data Engineering?
We can use this concept any where in any company whether it is a small company or big company . but mostly it is used for collection of big data
2.Any Prerequisite to learn Azure Data Engineering?
There is no prerequisite to learn Azore Data Engineering. If you are familiar with computer or have basic concept of any other programming language it would be an added advantage to you. By the way, we will start this training from scratch.
3.Recommend Audience for Azure Data Engineering course:
Anyone who is interested to learn Azure Data Engineering can join this course like students and working professionals
4.In case of my absence, how can I manage my class?
You will get access of LMS (Learning management System), if you missed your class you can refer the recorded session in your LMS. If you have any doubt you can ask in your next class whenever you will join.
5.Who is the Instructor?
Our instructors are industry experts having more than 10 years of corporate experience. Since they have rich experience in their domain they will train as per the industry standards.
6.Will you help us in Job placement?
We have tied up with more than 100+ companies in corporate industry. We will schedule your interview after successful completion of our course.
7.Will you help us in resume creation?
Yes, we will help you in creating your resume so that it can shortlist easily for interview.
8.Will you help us to get the software?
Yes, we will help you with Trial version of software.
9.How long can I access my (LMS) learning management System?
Once you will enroll for the course, you can access the LMS for life long.
10.How can I get the certification?
Once you will complete your course, you will appear for an online test. Basis on your score we will issue the certificate.
11.What is Self-paced course?
If you will enroll for self-paced course you can access the pre recorded sessions and you can do self-learning. You can complete your course as per your availability.
12.What is Instructor driven course?
This is online virtual class room training, since this is live class, you can clear your doubts in the class.
13.What if I have more queries or concerns?
You can write an email at info@wifilearning.com or you can contact us at our Office numbers at 91-9999468661.
Recommended Courses:
Recommended courses
Data Science with Python
AWS Solutions Architect Certification Course
Data Analyst
Reviews:
Contact us
Phone: +91-9999468662 +91-9999468661
Email: info@wifilearning.com
