Azure

Data Engineering · Azure & Microsoft Fabric

Microsoft Fabric Data Engineer (DP-700) prep

Build modern data platforms with Azure & Microsoft Fabric

Start from SQL and Python, then build pipelines with Data Factory, process data at scale with Databricks and Spark, and land it in Delta Lake and Fabric lakehouses the way enterprise teams do.

Program fee
₹25,000
EMI available on credit cards
Next batch
Coming soon
Timings
7 to 8:15 AM IST
Weekday
Duration
2.5 Months
Live classes
syllabus modules
20
syllabus modules
Azure & Fabric tools
15+
Azure & Fabric tools
certification prep
DP-700
certification prep

Databricks · customers_scd2

[3]
(silver.alias("t")
  .merge(updates.alias("s"),
    "t.customer_id = s.customer_id")
  .whenMatchedUpdate(set=expire)
  .whenNotMatchedInsertAll()
  .execute())
Delta table updatedversion 42
  1. ADLS Gen2
  2. Databricks
  3. Delta Lake
  4. Fabric

Our alumni work at leading companies worldwide

  • Amazon
  • DXC Technology
  • HCL
  • Infosys
  • Lloyds Banking Group
  • NCR Corporation
  • Novartis
  • Tech Mahindra
  • Wells Fargo
  • Wipro
  • Yahoo
+

many more companies across India, the US & beyond

The stack

The Azure and Fabric data stack you will use

Today’s Azure data platforms and Microsoft’s newer unified Fabric platform, side by side, hands-on.

  1. Ingest & orchestrate

    • Azure Data Factory
    • Fabric pipelines
    • Dataflows Gen2
    • Data Gateway
  2. Store

    • ADLS Gen2
    • Blob Storage
    • OneLake
  3. Process

    • Azure Databricks
    • Apache Spark
    • Spark SQL
    • Spark Streaming
  4. Lakehouse & warehouse

    • Delta Lake
    • Fabric Lakehouse
    • Fabric Warehouse
    • Synapse SQL pools
Security & CI/CDAzure Key VaultService principalsSecret scopesGitHubAzure DevOps GitADF CI/CD

Hands-on in Microsoft Fabric

Real ingestion scenarios, end to end

The Fabric module is built around the scenarios data engineers hit on real projects. Alongside these you build mini projects and capstone projects across Azure and Fabric.

Azure
  1. Step 01

    APIs into the lakehouse

    Copy data from a REST API into a Fabric Lakehouse using bearer-token authentication, and move folders over from ADLS Gen2.

  2. Step 02

    On-premises SQL Server to Fabric

    Ingest from on-premises SQL Server through the data gateway, into a Lakehouse and incrementally into a Warehouse.

  3. Step 03

    Dynamic multi-table loads

    Copy many tables from Azure SQL Database into the Lakehouse with one parameterized, dynamic pipeline.

  4. Step 04

    Logged, end-to-end pipelines

    Log pipeline runs to a Warehouse table with stored procedures, and tie it together with Data Factory pipelines and Dataflows Gen2.

Who it's for

Built for people moving into data engineering

  • Database engineers

    Move beyond traditional RDBMS into Azure SQL, Synapse, and Fabric Lakehouse.

  • Big data / Hadoop engineers

    Upskill into Azure Databricks, Delta Lake, and Fabric pipelines.

  • ETL / data warehouse engineers

    Design scalable pipelines with Azure Data Factory and Fabric Dataflows.

  • Application programmers

    Work with streaming data and analytics.

  • Test engineers

    Transition into high-growth data engineering roles on Azure.

  • Data analysts / Power BI developers

    Step into end-to-end engineering and automation with Fabric.

Fresh graduates with an interest in cloud and data can join too: we start from fundamentals and build step by step.

Curriculum

What you'll learn

20 syllabus modules, from SQL and Python to DP-700, grouped into nine areas.

  1. 01

    Data engineering, SQL, and Python foundations

    Syllabus M1–M3

    Understand the role, get started on Azure, and build the SQL and Python every data engineer needs.

    • Azure & big data intro
    • Joins & CTEs
    • Window functions
    • Query optimization
    • Python collections & OOP
  2. 02

    Azure Data Factory pipelines

    Syllabus M4

    Build, parameterize, schedule, and monitor production pipelines.

    • Linked services & datasets
    • Schedule, tumbling & event triggers
    • Self-hosted integration runtime
    • Control-flow activities
    • Alerts & monitoring
  3. 03

    Mapping Data Flows and ADF CI/CD

    Syllabus M4

    Transform data visually at scale, and ship factories through Git and CI/CD.

    • Joins, lookups & aggregates
    • Pivot, window & alter row
    • Schema drift
    • Flowlets
    • GitHub / Azure DevOps Git
    • CI/CD
  4. 04

    Azure Synapse Analytics

    Syllabus M5

    Query and model data with serverless and dedicated SQL pools and Spark pools.

    • Serverless & dedicated SQL pools
    • Spark pools
    • Distributions
    • External tables
    • CETAS / CTAS
  5. 05

    Azure Databricks

    Syllabus M6

    Work in Databricks the way teams do, with secure access to your data lake.

    • Workspaces & DBFS
    • dbutils & widgets
    • Mount points
    • Key Vault secret scopes
    • Service principal & SAS access
  6. 06

    Apache Spark internals

    Syllabus M7–M11

    Understand how Spark runs your code so you can make it fast.

    • Driver & executors
    • Execution modes
    • RDDs, transformations & actions
    • Cache & persist
    • Broadcast & accumulators
    • Logical & physical plans
  7. 07

    DataFrames, Spark SQL, and streaming

    Syllabus M12–M15

    Process batch and streaming data with DataFrames and Spark SQL.

    • DataFrame operations
    • CSV, JSON, Parquet & ORC
    • Spark SQL & UDFs
    • Structured Streaming
    • Stateful processing
  8. 08

    Data lake, Key Vault, and Delta Lake

    Syllabus M16–M18

    Build a secure data lake and reliable Delta tables on top of it.

    • ADLS Gen2 & Blob Storage
    • Azure Key Vault
    • Schema enforcement & evolution
    • Time travel & vacuum
    • MERGE: SCD Type 1 & 2
  9. 09

    Microsoft Fabric and DP-700

    Syllabus M19–M20

    Build lakehouses and warehouses in Fabric, and prepare for the Fabric Data Engineer exam.

    • Lakehouse vs warehouse
    • OneLake
    • Fabric pipelines & Dataflows Gen2
    • Spark in Fabric
    • DP-700 prep

Full topic-by-topic syllabus (PDF)

Outcomes

Where it leads

Certification path

  • Microsoft Certified: Fabric Data Engineer Associate (DP-700)

Roles this prepares you for

  • Azure Data Engineer
  • Fabric Data Engineer
  • Big Data Engineer
  • Data Platform Engineer

Frequently asked questions

No prior experience is required. The program starts from the basics with SQL and Python and gradually moves to advanced topics, so it suits beginners and experienced professionals alike.

Still have questions? Ask us on WhatsApp

Talk to us about the next batch

Share your details and we'll get in touch with batch dates, timings, and fees.

By submitting, you agree to our Privacy Policy.

Chat with us on WhatsApp