AZURE TRAINING PROGRAM

[email protected]
 Abhishek Agrawal, a Microsoft Certified Azure Data Engineer with over 7 years of
immersive hands-on experience, is a catalyst for career transformations in Azure
MEET YOUR MENTOR Cloud. A distinguished NIT Raipur graduate, he specializes in Azure Data Factory,
Databricks, Synapse Analytics, and more.

Abhishek's pedagogy seamlessly integrates theoretical knowledge with practical insights,

offering a holistic learning experience in data engineering.

Renowned for propelling hundreds of individuals into thriving Azure Cloud careers,
Abhishek's teaching philosophy revolves around real-world projects, daily practice, and a
steadfast focus on practical implementation.

His commitment extends beyond conventional learning, providing comprehensive support

for career transitions, interview preparation, and perpetual access to class recordings.

Embark on a transformative learning journey with Abhishek, where his passion for
immersive education ensures that every concept taught is immediately applicable and
relevant.

Join his dynamic classes for a hands-on exploration of the world of data engineering, cloud
solutions, and the pathway to unparalleled career success. Let Abhishek guide you in
constructing your success story in the realm of data engineering.
 What sets us apart?
Real-time Training with Practical Experience
Compact & Interactive Batch Training

Certification Support (AZ-900, DP-900,

Peer-to-Peer Learning Environment
AZ-203)

Professional Resume Building Assistance Mock Interview Sessions

Job Profile Optimization Guidance for International Job Interviews

Lifetime Access to Course Recordings

Comprehensive Interview Questions
from 50+ Companies
Course Completion Certificate
COURSE - DATA ENGINEERING
This Course is ideal for:

Individuals who are new to Azure, requiring zero prerequisites.

Beginners in the field of data analysis.

Those eager to learn Azure Data Factory (ADF), Databricks, and

Synapse.

Professionals currently working with Informatica, SSIS, and Power BI,

seeking to transition into Azure.

Data analysts looking to make a switch to Azure.

 COURSE - DATA ENGINEERING Course duration - 2 months

1) Understanding Azure basics: subscription, resource 6) Copying data to SQL Server: upsert, pre-copy script,
group, and management group creation, and an and AutoCreate table options.
introduction to Azure Data Factory (ADF).
7) Lookup activity and handling multiple files using
2) Exploring Blob and Data Lake Gen2 storage. lookup.

3) Integration runtime, linked services, data sets, pipelines, 8) Delta load strategy for a single file.
and activities in ADF. Copying data for a single file.
9) Delta load for multiple files.
4) Advanced copy data activities: Recursive, wildcard, file
listing, mapping, user properties, and various settings. 10) Git integration and Azure DevOps collaboration.

5) Implementing For Each loop for copying multiple files. 11) Overview of Azure Databricks integration.

12) Delta table and properties of Delta Lake.

13) Azure Active Directory, tenant, subscription, and user 19) JDBC connector and secret scope in Azure
management. Databricks.

14) Advanced activities: If-else, metadata, and web activities. 20) Fact and dimension

15) Triggers: event-based, scheduled, and tumbling window 21) star, snowflake schemas, and data modelling.
triggers.
22) Creating stored procedures for data modelling.
16) Azure Synapse: SQL, serverless pool, and dedicated pool.
23) Sending email alerts using Logic App.
17) Data flow concepts: mapping, wrangling, and processing
CSV, JSON, and XML with Pyspark, Scala, and Python. 24) Advanced data processing with CSV, JSON, and XML
in Pyspark, Scala, and Python.
18) Azure Key Vault and shared integration runtime.
25) Delta Lake principles and best practices.

Includes Resume Building, Mock Interview & Certificate Assistance

Course Fees - Rs 20,000
Architectures Covered Within the Course are as Follows
 A) AZURE DATA FACTORY

Source On Premise Destination Azure SL Server Azure Analysis

OR (Azure Blob (Azure Synapse) Service
Cloud Storage)

Data
Transformation
(Azure Databricks) Power BI
 B) AZURE DATABRICKS

Using secret scope we will extract

credentials from Azure Key Vault

CSV Using secret scope we will extract

credentials from Azure Key Vault

Azure SQL
Landing

Move Files to Archive

JSON
Dashboard

Delta Lake
Delta Tables

XML
 Model & Serve

C) AZURE SYNAPSE
PolyBase
Azure Synapse Azure Analysis
Analytics Services
(Synapse SQL)

Ingest Store Prep & Train

Logs, files and media

(Unstructured)

Azure Azure Power BI

Azure
Synapse Synapse
Data Lake
Analytics Analytics
Storage
Business/Custom (Pipelines) (Apache
apps Spark)
(Structured)
CONTACT US
If you have any questions, feedback, or inquiries, please don't hesitate to get in touch with me.
I strive to respond to all inquiries within 24-48 hours.

www.teacheron.com/tutor-profile/4Lg4 +91 79875 02532

Teacheron WhatsApp

linkedin.com/in/abhishek-agrawal-406105102 +91 7898126426

LinkedIn Call

[email protected]
www.urbanpro.com/bangalore/abhishek-agrawal
[email protected]
UrbanPro Email