Build Enterprise Data Pipelines In Microsoft Fabric
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 920.00 MB | Duration: 2h 0m
Design, build, and run production-ready data pipelines using Microsoft Fabric Data Warehouse and Azure connectivity.
Explain what data pipelines are and how they are used in enterprise data engineering
Define key data pipeline terminology including ETL, ELT, idempotency, and orchestration
Create and configure a Microsoft Fabric workspace from scratch
Build a Fabric Data Warehouse ready to receive pipeline data
Create a schema in Microsoft Fabric that mirrors the source data structure
Configure a secure data gateway connection between Microsoft Fabric and an on-premises SQL Server instance
Build a multi-step enterprise data pipeline in Microsoft Fabric using real-world patterns
Execute a pipeline run and verify data has loaded correctly into the Fabric Data Warehouse
Implement idempotency in a Fabric pipeline to ensure safe, repeatable execution
Apply enterprise data engineering principles including reliability, scalability, and observability
Transfer the pipeline pattern built in this course to real-world data engineering scenarios
Evaluate the pipeline output and troubleshoot results using the Fabric monitoring interface
Requirements
A Windows PC or laptop capable of running SQL Server 2025 (the course covers the minimum hardware requirements in detail)
A stable internet connection for downloading software and accessing Microsoft Fabric in the browser
Basic familiarity with databases - you should know what a table, row, and column are
No prior experience with Microsoft Fabric is required - the course builds your environment from scratch
No prior data engineering or pipeline experience is needed - core concepts are explained from the ground up
A willingness to install software - you will install SQL Server 2025, SSMS, and the on-premises data gateway during the course
A work or school email address to activate a Microsoft Fabric account - personal email addresses (Gmail, Outlook, Yahoo etc.) are not eligible for the free Fabric trial
If you only have a personal email, Lecture 7 walks you through creating a Microsoft Entra ID user which can be used in place of a work account.
Description
Data doesn't move itself. Behind every dashboard, every report, and every business decision is a pipeline that extracts, transforms, and loads data reliably from source to destination. This course teaches you how to build one.In this hands-on course, you will build a production-ready enterprise data pipeline using Microsoft Fabric - Microsoft's unified analytics platform that is rapidly replacing Azure Synapse Analytics across organisations worldwide. Using a real-world source database (SQL Server 2025 and the AdventureWorksDW schema), you will connect an on-premises SQL Server instance to Microsoft Fabric and build a pipeline that loads data into a Fabric Data Warehouse cleanly, reliably, and repeatedly.What makes this course different is the emphasis on enterprise-grade engineering principles. This is not a tutorial that gets data from A to B and stops there. You will implement idempotency - the property that makes a pipeline safe to run multiple times without duplicating or corrupting data. This is a real-world requirement in production environments that most beginner courses never cover.What you will build:A fully configured Microsoft Fabric workspace and Data WarehouseA secure gateway connection between on-premises SQL Server and Microsoft FabricA multi-step enterprise data pipeline that loads the AdventureWorksDW schemaA tested, idempotent pipeline ready to run in a real organisational environmentWhat you will learn:You will start from the ground up - setting up your Azure account, configuring Microsoft Entra ID, installing SQL Server 2025, and restoring a real sample database. By the time you build the pipeline, your environment mirrors what a data engineering team would work with in a professional setting.No prior Fabric or data engineering experience is required. A basic understanding of databases - tables, rows, and columns - is all you need to get started.Why Microsoft Fabric now?Microsoft Fabric is one of the fastest-growing platforms in enterprise analytics. Organisations are actively migrating from legacy tools, and demand for professionals who can work with Fabric is rising sharply. The skills you build in this course are directly transferable to real data engineering roles.
Data analysts who want to move beyond reporting and build the pipelines that feed their dashboards,SQL Server developers and DBAs looking to extend their skills into the Microsoft Fabric ecosystem,Business intelligence professionals who want to understand how data gets from a source system into a warehouse,Data engineers who are new to Microsoft Fabric and want hands-on experience with its pipeline tools,Azure professionals who want to add Microsoft Fabric to their skillset as it replaces Azure Synapse Analytics,IT professionals working in organisations that are evaluating or migrating to Microsoft Fabric,Developers with SQL experience who want to transition into a data engineering role,Students and graduates looking to build a practical, portfolio-ready data engineering project,Power BI developers who want to understand the data engineering layer that sits behind their reports
Build Enterprise Data Pipelines In Microsoft Fabric
