×

DP-602 Implement a Data Warehouse with Microsoft Fabric

Duration: 1 Day
Course Code: DP-602
Course Delivery: Virtual (1-Day) GMT/Virtual (1-Day) PST
Level: Beginner

Course Overview

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

Audience Profile

The courseware is based on the data engineer role.
As a data engineer, you implement and manage the operational aspects of data warehouse solutions. You use a variety of methods and tools to maintain a data warehouse, load, transform, and query data, model a data warehouse, and manage security, including applying knowledge of using Transact-SQL (T-SQL) and other tools for management purposes.
 

Course Objectives

After completing this course, students will be able to:

• Get started with data warehouses in Microsoft Fabric.
• Load data into a Microsoft Fabric data warehouse.
• Query a data warehouse in Microsoft Fabric.
• Monitor a Microsoft Fabric data warehouse.

Prerequisites

You should be familiar with basic data concepts and terminology.

Course Outline

Module 1: Get started with data warehouses in Microsoft Fabric+

Data warehouses are analytical stores built on a relational schema to support SQL queries. In this module learn how 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.

Lessons

• Introduction
• Understand data warehouse fundamentals
• Understand data warehouses in Fabric
• Query and transform data
• Prepare data for analysis and reporting
• Secure and monitor your data warehouse
• Exercise - Analyze data in a data warehouse

After completing this module, students will be able to:

• 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

Module 2: Load data into a Microsoft Fabric data warehouse+

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics. In this module learn about advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Lessons

• Introduction
• Explore data load strategies
• Use data pipelines to load a warehouse
• Load data using T-SQL
• Load and transform data with Dataflow Gen2
• Exercise: Load data into a warehouse in Microsoft Fabric

After completing this module, students will be able to:

• 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).

Module 3: Query a data warehouse in Microsoft Fabric+

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics. In this module learn how to query a data warehouse in Microsoft Fabric using  SQL query editor.

Lessons

• Introduction
• Use the SQL query editor
• Explore the visual query editor
• Use client tools to query a warehouse
• Exercise: Query a data warehouse in Microsoft Fabric

After completing this module, students will be able to:

• 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.

Module 4: Monitor a Microsoft Fabric data warehouse+

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

Lessons

• Introduction
• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Exercise - Monitor a data warehouse in Microsoft Fabric

After completing this module, students will be able to:

• 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.

Book this Course

Date Delivery Format Location Price Add to cart
28 May 2024 Virtual (1-Day) GMT Online £195.00 £125.00 Book me in
11 June 2024 Virtual (1-Day) GMT Online £195.00 £125.00 Book me in
2 July 2024 Virtual (1-Day) PST Online £195.00 £125.00 Book me in
16 July 2024 Virtual (1-Day) GMT Online £195.00 £125.00 Book me in

If you have any questions or are looking for customised training for you or your team, please contact us

Exam Information