Welcome to ONLC Training Centers

DP-602: Implement a Data Warehouse with Microsoft Fabric Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $595

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


DP-602: Implement a Data Warehouse with Microsoft Fabric Course

 

Overview

This class offers a comprehensive understanding of implementing a data warehouse using Microsoft Fabric, a powerful platform for data and analytics. Participants will gain practical knowledge in setting up, managing, and optimizing a data warehouse, ensuring seamless integration with other analytics tools. The curriculum covers essential topics like data loading, querying, monitoring, and securing your data warehouse, providing a well-rounded education in modern data warehousing techniques.

Designed for professionals seeking to enhance their data management skills, this course equips learners with the expertise to handle complex data environments efficiently. By the end of the course, attendees will be proficient in using Microsoft Fabric to support robust data analytics solutions, driving better business insights and decision-making.

Audience Profile

This course is ideal for data professionals, including data engineers, data analysts, and database administrators, who are looking to deepen their understanding of data warehousing and analytics using Microsoft Fabric. It is also suitable for IT professionals responsible for managing data infrastructure and ensuring data security within an organization.

Prerequisites

You should be familiar with basic data concepts and terminology.

COURSE OUTLINE

Module 1: Get started with data warehouses in Microsoft Fabric

  • 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

Module 2: Load data into a Microsoft Fabric data warehouse

  • 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

Module 3: Query a data warehouse in Microsoft Fabric

  • 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

Module 4: Monitor a Microsoft Fabric data warehouse

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

Module 5: Monitor a Microsoft Fabric data warehouse

  • Explore dynamic data masking
  • Implement row-level security
  • Implement column-level security
  • Configure SQL granular permissions using T-SQL
  • Exercise: Secure a warehouse in Microsoft Fabric

 

View outline in Word

ADP602

Attend hands-on, instructor-led DP-602: Implement a Data Warehouse with Microsoft Fabric training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com