Fabric Data Warehouse for SQL Server Professionals

Design, Develop, Optimise, and Migrate SQL Server Data Warehouses to Microsoft Fabric !

Enroll now for $195 USD !

Course Summary

Do you want to start developing data warehouses in Microsoft Fabric, using the SQL Server skills you already have?

This course focuses on the architecture, design decisions, and practical development techniques involved in working with Fabric Data Warehouse. It’s about understanding how Fabric Data Warehouse works, how it differs from SQL Server, and how to design, build, load, optimise, secure, and maintain data warehouses effectively.

We assume you already have experience with SQL Server and T-SQL, particularly in database development or data warehousing. You don’t need prior experience with Fabric Data Warehouse.

  • Are you an experienced SQL Server professional who wants to understand how Fabric Data Warehouse works?
  • Do you need to know which familiar SQL Server techniques still apply, which behave differently, and which aren’t supported?
  • Are you trying to design and build efficient data warehouses in Fabric, rather than simply moving existing SQL Server practices to a new platform?
  • Do you need to understand data loading, incremental processing, query performance, and troubleshooting in Fabric?
  • Are you considering migrating an existing SQL Server data warehouse to Fabric and want to understand the challenges and design decisions involved?

If that sounds like the kind of work you do, you’re in the right place. You’ll get clear explanations, practical demonstrations, hands-on exercises, and short quizzes to help you build understanding and apply your existing SQL Server skills 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 Microsoft Fabric account with access to a suitable Fabric capacity, and a SQL development tool such as SQL Server Management Studio or Visual Studio Code. We’ll guide you through setting up the lab environment and provide the scripts and sample data you’ll need.


Enroll now for $195 USD !

Modules and Lessons

Module 0: Getting started

Who is this course for ?
Who is Greg ?
What will I learn in this course ?
Configuring your lab environment

Module 1: Understanding Fabric Data Warehouse

Module introduction
Where Fabric Data Warehouse fits
Choosing between warehouse, lakehouse, and Fabric SQL database
Understanding OneLake, delta tables, and warehouse storage
How Fabric Warehouse processes SQL queries
Creating and exploring your first Fabric Warehouse
Lab 1 - Setting up the environment
Lab 1 - Video walkthroughs
Quiz 1

Module 2: Designing and Creating Warehouse Tables

Module introduction
Designing a data warehouse for Fabric
Supported data types and collations
Creating tables and schemas
Implementing identity columns
Primary keys, foreign keys, and constraints
How Fabric table storage differs from SQL Server
Lab 2 - Building the retail data warehouse schema
Lab 2 - Video walkthroughs
Quiz 2

Module 3: Working with T-SQL in Fabric Warehouse

Module introduction
T-SQL compatibility and limitations
Querying data using familiar T-SQL
Creating and modifying database objects
Working with views
Working with stored procedures
Working with functions
Working with temporary tables
Using CTAS with temporary and permanent tables
Writing cross-warehouse queries
Lab 3 - Adapting SQL Server T-SQL for Fabric Warehouse
Lab 3 - Video walkthroughs
Quiz 3

Module 4: Loading Data into Fabric Warehouse

Module introduction
Data loading options in Fabric
Loading data with COPY INTO
Using Data Factory copy jobs and pipelines
Loading data from other Fabric items
Working with staging tables
Performing data validation
Handling errors
Lab 4 - Loading the retail warehouse
Lab 4 - Video walkthroughs
Quiz 4

Module 5: Transforming and Maintaining Warehouse Data

Module introduction
Building SQL-based data transformation processes
Working with DML statements
Using CTAS and stored procedures for data processing
Designing incremental and repeatable data loads
Handling historical reloads and data corrections
Lab 5 - building a repeatable warehouse loading process
Lab 5 - Video walkthroughs
Quiz 5

Module 6: Managing Transactions and Concurrency

Module introduction
Transactions in Fabric warehouse
Working with snapshot isolation
Working with locking and concurrency
Handling write conflicts and transaction failures
Lab 6 - Investigating concurrent warehouse operations
Lab 6 - Video walkthroughs
Quiz 6

Module 7: Troubleshooting Query Performance

Module introduction
Core distributed query execution concepts
Investigating query performance and execution plans
Using Query Insights and monitoring tools
Working with statistics and query optimization
Data clustering impacts on performance
Workload management and capacity consumption
Lab 7 - Investigating and improving slow queries
Lab 7 - Video walkthroughs
Quiz 7

Module 8: Securing Fabric Data Warehouse

Module introduction
Core Fabric security model concepts
Assigning workspace permissions
Assigning SQL granular permissions
Implementing row-level and column-level security
Accessing data across Fabric and OneLake
Lab 8 - Securing the retail warehouse
Lab 8 - Video walkthroughs
Quiz 8

Module 9: Integrating with Power BI and Semantic Models

Module introduction
Preparing warehouse data for analytical consumption
Import, DirectQuery, and Direct Lake with warehouses
Creating a DirectLake semantic model from a warehouse
Creating an Import semantic model from a warehouse
Impacts of SQL views on security and Direct Lake
Lab 9 - Buidling a simple semantic model
Lab 9 - Video walkthroughs
Quiz 9

Module 10: Development, Source Control, and Deployment

Module introduction
Choosing development tools and working practices
Using SQL database projects with Fabric warehouse
Using Git integration for warehouse source control
Deploying warehouse changes across environments
Lab 10 - Managing and deploying warehouse schema changes
Lab 10 - Video walkthroughs
Quiz 10

Module 11: Migrating from SQL Server to Fabric Warehouse

Module introduction
Assessing whether a SQL Server warehouse should migrate
Identifying compatibility and migration challenges
Choosing migration tools and approaches
Migrating tables, data, and T-SQL code
Lab 11 - Completing a SQL Server to Fabric warehouse migration
Lab 11 - Video walkthoughts
Quiz 11

Module 12: Next steps

Summary and further steps


Enroll now for $195 USD !