Exercise: Transform data with T-SQL
In this exercise, you write T-SQL queries to filter, join, and aggregate staging data in a Fabric warehouse. You create a view for reusable transformation logic, build a stored procedure with parameters for repeatable processing, and create and load dimensional tables. The exercise reinforces the query, view, stored procedure, and dimensional modeling techniques covered in this module.
Note
You need access to a Fabric-enabled workspace to complete this exercise. For information about a trial license, see Getting started with Fabric.
This lab takes approximately 45 minutes to complete.
Launch the exercise and follow the instructions.
