-
Module 1: Introduction to Microsoft Fabric Mirroring
11 Lessons-
StartModule introduction
-
StartWhat is Microsoft Fabric ?
-
StartKey Fabric workloads
-
StartWhat is Mirroring in Fabric ?
-
StartHow mirroring differs from traditional pipelines
-
StartHow mirrored data lands in OneLake
-
StartFabric mirroring types
-
StartCurrently supported data sources
-
StartLicensing and capacity requirements
-
StartWhen mirroring is and is not the correct choice
-
StartQuiz 1
-
-
Module 2: Mirroring architecture and concepts
14 Lessons-
StartModule introduction
-
StartHow Fabric Mirroring works under the hood
-
StartOneLake and mirrored database items
-
StartDelta-parquet and open data formats
-
StartReplication concepts
-
StartReplicator backoff
-
StartMirrored data retention
-
StartRead-only mirrored copies and analytics endpoints
-
StartMirroring vs shortcuts vs dataflows
-
StartSchema handling and table selection
-
StartPermissions, workspaces, data access, and identity
-
StartCost and capacity considerations
-
StartCommon limitations and constraints
-
StartQuiz 2
-
-
Module 3: Setting up mirroring
9 Lessons-
StartModule introduction
-
StartFabric capacity, workspace, and source database configuration
-
StartEnabling system-assigned managed identity
-
StartFirewall and network rules for source access
-
StartCreating a Fabric workspace and assigning capacity
-
StartRequired tenant settings
-
StartLab 3 video walkthroughs
-
StartLab 3
-
StartQuiz 3
-
-
Module 4: Mirroring Azure SQL database
17 Lessons-
StartModule introduction
-
StartGeneral prerequisites
-
StartChecking required managed identity
-
StartDatabase principal requirements
-
StartRequired user database permissions
-
StartSource-specific implementation details
-
StartCreating a mirrored database
-
StartSelecting tables and configuring replication scope
-
StartMonitoring replication status
-
StartReseeding mirroring
-
StartDatabase-level limitations
-
StartTable-level limitations
-
StartColumn-level limitations
-
StartTroubleshooting
-
StartLab 4 video walkthroughs
-
StartLab 4
-
StartQuiz 4
-
-
Module 5: Querying and analyzing mirrored data
11 Lessons-
StartModule introduction
-
StartAccessing mirrored data via the SQL analytics endpoint
-
StartQuerying mirrored data
-
StartUsing mirrored data in Power BI reports using DirectLake
-
StartJoining mirrored data with other Fabric data
-
StartCross-database queries
-
StartConsuming mirrored data in data science workflows
-
StartSharing mirrored data
-
StartLab 5 video walkthroughs
-
StartLab 5
-
StartQuiz 5
-
-
Module 6: Mirroring SQL Server
17 Lessons-
StartModule introduction
-
StartWhen mirroring is appropriate
-
StartMirroring earlier versions
-
StartMirroring from SQL Server 2025
-
StartAzure Arc and other prerequisites
-
StartWorking with managed identities
-
StartConfiguration - SQL Server 2016 - 2022
-
StartConfiguration - SQL Server 2025+
-
StartAvailability group issues
-
StartLimitations
-
StartTroubleshooting
-
StartPerformance control with Resource Governor
-
StartControlling scan performance
-
StartControlling auto-reseed
-
StartLab 6 video walkthroughs
-
StartLab 6
-
StartQuiz 6
-
-
Module 7: Monitoring and managing mirroring
9 Lessons-
StartModule introduction
-
StartMonitoring initial seeding
-
StartMonitoring replication health
-
StartReplication latency and lag metrics
-
StartSchema changes and object evolution
-
StartStarting, stopping, and restarting mirroring
-
StartHandling ownership issues
-
StartCI and CD considerations for mirrored databases
-
StartQuiz 7
-
-
Module 8: Performance optimization and best practices
11 Lessons-
StartModule introduction
-
StartTable-selection strategy
-
StartChoosing between mirroring, shortcuts, and pipelines
-
StartPartitioning and delta file optimisation in OneLake
-
StartManaging costs with capacity units and mirroring overhead
-
StartDesign patterns for medallion architecture with mirroring
-
StartMulti-source mirroring strategies
-
StartCost awareness and operational guardrails
-
StartLab 8 video walkthroughs
-
StartLab 8
-
StartQuiz 8
-
-
Module 9: Security governance and compliance
9 Lessons-
StartModule introduction
-
StartRow-level security and column masking on mirrored data
-
StartMicrosoft Purview integration for data governance
-
StartAuditing mirroring activity
-
StartData residency and compliance considerations
-
StartManaging sensitive data during replication
-
StartLab 9 video walkthroughs
-
StartLab 9
-
StartQuiz 9
-
-
Module 10: Mirroring other sources
13 Lessons-
StartModule introduction
-
StartMirroring Azure Cosmos DB
-
StartMirroring Azure SQL Managed Instance
-
StartMirroring Snowflake
-
StartMirroring Azure Database for PostgreSQL
-
StartOpen mirroring
-
StartMetadata mirroring for Azure Databricks
-
StartMirroring Oracle
-
StartMirroring MySQL
-
StartMirroring SharePoint lists
-
StartMirroring Google BigQuery
-
StartMirroring using the REST API
-
StartQuiz 10
-
-
Module 11: Real-world use cases and roadmap
6 Lessons
Implementing Zero-ETL with Microsoft Fabric Mirroring
Design, Configure, Monitor, and Use Mirrored Data for Analytics in Microsoft Fabric
Course Summary
Do you want to start working with mirroring in Microsoft Fabric?
This course focuses on the architecture, design decisions, and practical implementation patterns involved in using mirroring in Fabric. This course is about understanding how database and metadata mirroring works in Fabric, when to use it, how to set it up, and how to work with mirrored data effectively.
We assume you already understand the basics of Fabric, databases, and analytics tooling.
- Are you trying to make operational database data available in Fabric with less complexity?
- Do you need to decide whether mirroring is the right fit compared to pipelines, shortcuts, or other approaches?
- Have you been unsure how Fabric mirroring differs from earlier SQL Server technologies with similar terminology?
- Do you need to monitor and troubleshoot mirrored data, not just create it?
If that sounds like the kind of work you do, you're in the right place. You'll get clear explanations, hands-on exercises, and short quizzes to help you build understanding and apply it with confidence. And while they're optional, we strongly encourage you to complete the practical exercises. We have tried to make this as easy as possible. The main things you'll need are a Fabric account and access to a supported source database for the mirroring labs.
