Current Level 0: Microsoft Fabric—Level 0
0 / 6 Miles
0 / 6 Assignments
0 / 7 Exams

Mile 0: Microsoft Fabric Syllabus.

🎬 YouTube Videos

No YouTube videos available

Check back later for new YouTube content.

📹 Library Videos

No library videos available

Sign up free to watch library videos on this mile, or explore the first three miles on free courses.

📚 Content

SECTION 1 MICROSOFT FABRIC COURSE BASICS

1 min read

Objective: Build a foundational understanding of Microsoft Fabric, its environment, and basic navigation.
This level introduces the Microsoft Fabric platform and covers the essential steps required to get started.

Topics Covered:
MS Fabric Data Engineering Basics
Introduction to Microsoft Fabric
How to Create a Microsoft Fabric Free Trial Account
Microsoft Fabric Home Page Tour
What is a Workspace and How to Create a Workspace

Sign up or sign in to rate this section
SECTION 2 FABRIC FUNDAMENTALS

1 min read

Objective: Explore the fundamental storage, analytics, and workspace concepts available in Microsoft Fabric.
This level focuses on core Fabric components used for organizing, storing, and analyzing data.

Topics Covered:

  • Fabric Workspace Roles
  • Lakehouse Architecture
  • Introduction to Lakehouse
  • Delta Tables in Lakehouse
  • SQL Analytics Endpoint
  • How to Use SQL Analytics Endpoint
  • Introduction to Warehouse
  • Warehouse Architecture
  • How to Create a Warehouse
  • How to Create Tables in Warehouse
    Key Point
    Level 1 establishes the foundation for working with Workspaces, Lakehouse, Delta tables, SQL Analytics Endpoint, and Warehouse.
Sign up or sign in to rate this section
SECTION 3 DATA ENGINEERING IN MICROSOFT FABRIC

2 min read

Objective: Understand data engineering concepts and build data workflows using Microsoft Fabric Data Pipelines.
This level introduces Fabric Data Pipelines and the components required to create and control data movement workflows.

Topics Covered:

  • What is Data Engineering?
  • What is a Data Pipeline in Microsoft Fabric?
  • Components of Fabric Pipeline
  • Connection
  • Activity
  • Dataset
  • Different Types of Pipeline Activities
  • Copy Data Activity
  • Lookup Activity
  • Get Metadata Activity
  • ForEach Activity
  • If Condition Activity
  • Set Variable Activity
  • Web Activity
  • Script Activity
  • Wait Activity
  • Notebook Activity
  • Delete Activity
  • Parameters
  • Variables

    Key Point
    Level 2 focuses on building flexible data workflows using Fabric Data Pipelines, activities, parameters, and variables.
Sign up or sign in to rate this section
SECTION 4 DATA INGESTION & TRANSFORMATION IN MICROSOFT FABRIC

2 min read

Objective: Build data ingestion and transformation solutions using cloud, database, and on-premises data sources.
This level covers practical data ingestion patterns, full and incremental loading, pipeline scheduling, mapping, gateway connectivity, and Dataflow Gen2 transformations.

Topics Covered:

  • Introduction to Data Ingestion
  • Data Sources Supported in Fabric
  • ADLS Gen2 to Lakehouse
  • Azure Blob Storage to Lakehouse
  • Azure SQL Database to Lakehouse
  • Watermark Concept
  • Full Load Pipeline
  • Multiple Table and File Ingestion
  • Incremental Load Pipeline
  • Incremental Loading from Azure SQL Database
  • Incremental Loading from ADLS Gen2
  • Pipeline Logging
  • Pipeline Triggers
  • Manual and Scheduled Pipeline Runs
  • Schedule Triggers
  • Daily Data Ingestion Pipelines
  • Mapping and Column Mapping
  • Dynamic Column Mapping
  • Additional Columns During Copy
  • Column Renaming During Ingestion
  • On-Premises Data
  • On-Premises Data Gateway
  • Gateway Configuration
  • On-Premises Database Ingestion
  • Dataflow Gen2
  • Data Pipeline vs Dataflow Gen2
  • Power Query
  • Dataflow Gen2 Creation
  • Basic Data Transformations
  • Loading Transformed Data into Lakehouse

    Key Point
    Level 3 focuses on implementing end-to-end ingestion and transformation patterns across cloud and on-premises data sources.
Sign up or sign in to rate this section
SECTION 5 FABRIC NOTEBOOKS, PYSPARK & DELTA LAKE

2 min read

Objective: Process and transform data using Fabric Notebooks, PySpark, Spark SQL, and Delta Lake.
This level covers notebook-based data engineering, PySpark transformations, Delta Lake operations, Slowly Changing Dimensions, pipeline integration, and Medallion Architecture.

Topics Covered:

  • Microsoft Fabric Notebooks
  • Notebook Interface and Basic Options
  • Apache Spark and Spark Session
  • PySpark and DataFrames
  • Reading CSV, Parquet, and Delta Data
  • DataFrame Transformations
  • NULL and Duplicate Handling
  • String, Date, and Timestamp Transformations
  • Sorting and Aggregations
  • GroupBy and Aggregate Functions
  • PySpark Joins
  • PySpark SQL Functions
  • Spark SQL
  • PySpark DataFrame vs Spark SQL
  • Writing Data to Fabric Lakehouse
  • Delta Lake and Delta Tables
  • INSERT, UPDATE, and DELETE
  • Delta MERGE
  • Schema Enforcement
  • Delta Table Versioning and Time Travel
  • Slowly Changing Dimensions
  • SCD Type 1 and Type 2
  • Pipeline Parameters with Notebooks
  • Running Notebooks from Fabric Data Pipeline
  • Medallion Architecture
  • Bronze-to-Silver Transformation
  • Silver-to-Gold Transformation
  • Complete Bronze → Silver → Gold Flow
  • Reusable and Parameterized Notebooks

    Key Point
    Level 4 brings together notebooks, PySpark, Delta Lake, pipelines, SCD, and Medallion Architecture for end-to-end data engineering solutions in Microsoft Fabric.
Sign up or sign in to rate this section
Previous Next Mile

📝 Assignment

Available Assignments
Assignment Pass Mark Duration Actions
Syllabus Overview
70% 01:00:00

📊 Exam

Available Exams
Exam Pass Mark Duration Questions Actions
Basic Knowledge Check
70% 00:30:00 All

💬 Comments & Discussion

Sign up free or sign in to post a comment
Sign up free or sign in
No comments yet

Be the first to share your thoughts!