DP-602: Implement a Data Warehouse with Microsoft Fabric

Length: 1 Day(s)     Cost:$950 + GST

= Scheduled class     = Guaranteed to run     = Fully booked

Click on the date to book online
Please wait as we are loading the schedules...
LOCATION July August September October
Virtual Class

In this one-day course students explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.

This one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.

  • Data Analysts
  • Data Engineers

  • You should be familiar with basic data concepts and terminology.

After completing this course, students will be able to:

  • 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

  • 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