DP-602T00 - Implement a data warehouse with Microsoft Fabric

Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.

Code: dp-602t00

Duration: 1.0 day

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • Describe data warehouses in Fabric
  • Understand a data warehouse vs a data Lakehouse
  • Work with data warehouses in Fabric
  • Create and manage fact tables and dimensions within a data warehouse
  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).
  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.
  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.

Content

1. Get started with data warehouses in Microsoft Fabric

Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

Click here to know more

2. Load data into a Microsoft Fabric data warehouse

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Click here to know more

3. Query a data warehouse in Microsoft Fabric

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Click here to know more

4. Monitor a Microsoft Fabric data warehouse

A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.

Click here to know more

Audience

N/A

Prerequisites

You should be familiar with basic data concepts and terminology.

Certification

product-certification

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

az-900t00

This course is a high-level overview of Azure. The course will provide foundational level knowledge of cloud services and how those services are provided with M

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

mb-335t00

MB-335T00 is a course code that refers to a specific training program or course offered by Microsoft. Unfortunately, as of my knowledge cutoff in September 2021
Enquire Now
qgGLQ5
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy