From the course: Introduction to Microsoft Fabric by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Learning objectives

Learning objectives - Microsoft Fabric Tutorial

From the course: Introduction to Microsoft Fabric by Microsoft Press

Start my 1-month free trial Buy for my team

Learning objectives

“

- Welcome to Lesson 5: Manage data with a Fabric Warehouse. As discussed in Lesson 2, a warehouse is an example of a schema-first data solution based on the T-SQL language. This means that if you have an existing data warehouse in SQL Server or in the Azure Cloud, a Fabric warehouse is a straightforward way to migrate your data platform to Fabric. After all, many SQL database concepts are supported, at least those that are deemed needed for data warehousing. In this lesson, I will assume that we do not have any pre-existing warehouse, and that we want to start from scratch. This means that we want to apply T-SQL to set up a warehouse, meaning that we use SQL scripts to define tables in the warehouse. We will then focus on how to query data in a Fabric warehouse using the built-in SQL query editor and after that, we will create reports with the default warehouse semantic model. You may remember that you get a free semantic model with each warehouse that is generated automatically and…

Contents