Microsoft Fabric Data Engineer Training

Overview & Architecture:

• What is Fabric
• Core components
• Ecosystem comparison

Key Features:

• AI capabilities,
• OneLake unification,
• Pricing,
• Workspace management.

Real-world Use Cases:

• Collaborative workflows,
• Fabric in action.

Hands-on:

• Activating Fabric trial,
• Navigating workspace UI.

Conceptual Foundations:

• Lakehouse vs data warehouse vs OneLake.

Medallion Architecture:

• Architecture and implementation in Fabric.

Operations: 

• Data discovery,
• Transformation,
• Querying,
• Governance best practices.

Hands-on: 

• Building a lakehouse,
• Applying the medallion design,
• Executing transformations.

Environment Setup:

• Configuring Spark in Fabric.

Core Operations: 

• DataFrames,
• Spark SQL,
• Notebook usage.

Visualization: 

• Integrating Spark notebooks.

Hands-on:

• Running Spark transformations and generating visual insights.

Introduction & Table Management:

• Creating,
• Optimizing,
• Partitioning Delta tables.

Advanced Features: 

• Table optimization,
• Structured Streaming.

Hands-on: 

• Working with delta tables in Spark.

Core Concepts:

• Difference between Dataflows Gen2 and pipelines.

Key Tasks: 

• Copy activities,
• Pipeline templates,
• Monitoring.

Hands-on: 

• Building Dataflows Gen2,
• Orchestrating pipelines.

Warehouse Design:

• Architecture,
• Table structures,
• Star schema.

Data Loading: 

• Ingestion via Dataflows Gen2,
• Transformation using Copilot.

Querying & Analysis: 

• SQL querying,
• Ranking functions,
• Visual query editor.

Hands-on: 

• Warehouse setup,
• ingestion,
• Querying tasks.

Fundamentals:

• Real-time analytics,
• Eventhouse vs Eventstream.

Transformation & Queries: 

• Materialized views,
• KQL,
• Stored functions.

Dashboards & Automation: 

• Real-time dashboards,
• Data Activator triggers,
• Best-practice setups.

Hands-on: 

• Eventstream ingestion,
• Real-time querying,
• Dashboard building.

Security Fundamentals:

• Dynamic masking,
• row/column-level security,
• Workspace permissions.

Monitoring Tools: 

• Fabric Monitor Hub,
• DMVs,
• Performance tracking.

Governance: 

• Activator,
• Administrative controls,
• Data governance strategies.

Hands-on: 

• Configuring access,
• Observing metrics,
• Securing assets.

Key Technologies:

• Azure Databricks,
• Unity Catalog,
• Purview.

Pipeline Development: 

• Delta Live Tables,
• ADF components,
• Data Lake Storage Gen2 vs Blob.

Security: 

• Threat protection,
• Secure data access.

Hands-on: 

• Running Spark on Databricks,
• Building pipelines,
• Configuring ADLS Gen2.

Data Integration:

• ADF components,
• Control flows,
• Data Factory vs SSIS.

Synapse Bridge:

• Spark and pipelines integration.

Hands-on: 

• Creating Data Factory pipelines,
• Loading data into Azure Synapse.

Lifecycle Management:

• Git integration,
• Fabric APIs.

Automation: 

• CI/CD workflow for Fabric.

Hands-on: 

• Git repo connection,
• Building deployment pipelines.

Exam-focused Topics:

• Best practices,
• Common pitfalls,
• Mock tests.

Time Management Tips: 

• Exam pacing strategies.

Hands-on: 

• Full-length mock exam.