Home
Courses
Implement a data warehouse with Microsoft Fabric (DP-602)

Implement a data warehouse with Microsoft Fabric (DP-602)

Course 8703

Duration: 1 day
Language: English
Level: Foundation

Explore the data warehousing process within Microsoft Fabric in this comprehensive 1-day course. You'll learn to load, monitor, and query a data warehouse efficiently, leveraging Microsoft Fabric's robust features.

DP-602 Course Delivery Methods

In-Person
Online
Upskill your whole team by bringing Private Team Training to your facility.

DP-602 Course Information

In this course, you will learn how 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

Familiarity with data modelling, data transformation, and exploratory data analytics.
Ability to query and change data using T-SQL.

Certification Information

This course does not directly prepare you for a certification exam but is part of Microsoft's applied skills programme, enhancing data engineering competencies.

DP-602 Course Outline

Introduction to Data Warehouses in Microsoft Fabric

Understand the fundamentals of data warehouses and their role in Microsoft Fabric for analytical purposes.

Load Data into a Microsoft Fabric Data Warehouse

Explore strategies for loading data into a data warehouse in Microsoft Fabric, utilising data pipelines, T-SQL, and Dataflow Gen for efficient data management.

Query a Data Warehouse in Microsoft Fabric

Learn to query data warehouses in Microsoft Fabric using SQL query editors, visual query editors, and client tools for effective data analysis and retrieval.

Monitor a Microsoft Fabric Data Warehouse

Discover how to monitor capacity metrics, current activity, and queries in a Microsoft Fabric data warehouse to ensure efficient operation and performance optimisation.

Get This Course £835

1-Day Instructor-Led Training
Microsoft Official Content
Microsoft Applied Skills Course
After-Course Instructor Coaching Included
Available for Private Team Training

Include dates with afternoon start times

#8703

Jan 21 2:00 PM - 9:30 PM GMT

AnyWare
Feb 10 9:00 AM - 4:30 PM GMT

AnyWare
Mar 11 1:00 PM - 8:30 PM GMT

AnyWare
Mar 24 9:00 AM - 4:30 PM GMT

AnyWare
Apr 22 2:00 PM - 9:30 PM BST

AnyWare
May 13 9:00 AM - 4:30 PM BST

AnyWare
Jun 9 2:00 PM - 9:30 PM BST

AnyWare
Jun 23 9:00 AM - 4:30 PM BST

AnyWare
Jul 24 2:00 PM - 9:30 PM BST

AnyWare
Aug 12 9:00 AM - 4:30 PM BST

AnyWare
Sep 2 2:00 PM - 9:30 PM BST

AnyWare
Sep 22 9:00 AM - 4:30 PM BST

AnyWare
Nov 18 9:00 AM - 4:30 PM GMT

AnyWare

Scroll to view additional course dates

Bring this or any training to your organisation
Full-scale programme development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#8703

Questions about this course?

Customise Your Team Training Experience

Fill out the form below or call 44 (0) 207 874 5000

* Required Fields

Preferred method of contact:

Phone

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

DP-602 Course FAQs

No. Applied Skills credentials are not replacing Certifications. We are expanding our credentialing portfolio to better meet the needs of our learners and customers by allowing people to validate particular skill sets with this new offering.

Certifications are role-based and evaluate a broader range of skills needed to be successful in critical roles that organisations need to be successful in today's rapidly changing technical environment.

Applied Skills credentials are scenario-based and evaluate a narrower skill set specific to an organisation's critical business problem or challenge.

If you want to demonstrate that you have the range of skills needed to succeed in a given job role, a Certification is the right way to go. If you want to validate your skills on a specific business problem or scenario your organisation faces, an Applied Skills credential will make more sense.

Here are some key differentiators between Certifications and Applied Skills:

Breadth of skills validated: Certifications typically validate 4-6 skill sets, while Applied Skills validate one specific skill set.
Focus: Certifications are job role-based, while Applied Skills are product-based.
Purpose: Certifications validate skills needed for the technical aspects of job roles that leverage Microsoft solutions and technologies. Applied Skills validate specific scenarios hindering an organisation's digital transform organisation's

Many of the Applied Skills credentials can be used to help you prepare for Certification exams. Because Applied Skills are awarded based on performance within a lab, that experience may set you up for success on a Certification. All role-based Certification exams require experience, so earning an Applied Skills credential is one way to get some of the experience needed to pass the exam. However, not all skills assessed on a Certification exam will have an associated Applied Skills assessment lab, so you should not rely on Applied Skills alone. Visit how to prepare for a Certification exam.

If you want to demonstrate that you have skill sets that the Certification did not assess, are "Certification adjacent," or are needed for a specific project that you would like to do or are working on, an applied skill credential would be a great way to show your employer and peers that you have those skills and the skills validated by your Certification.

It depends on your technical expertise and why you want to earn a Microsoft credential.

If you are exploring technology or just beginning your learning journey in technology, starting with a fundamentals certification makes the most sense because it focuses on ensuring you have the foundational knowledge you need to get started.

Suppose you have experience and want to explore how Microsoft technologies and solutions are used to solve critical business problems. In that case, an Applied Skills credential is a great way to validate fundamental world skills focused on specific projects or scenarios.

If you have some experience and are pursuing a job that leverages Microsoft solutions, a role-based certification is the logical solution to validate role-based skills. Note that some Applied Skills credentials relate to our certifications and may provide another way to prepare for a certification exam.

Implement a data warehouse with Microsoft Fabric (DP-602)

DP-602 Course Delivery Methods

DP-602 Course Information

DP-602 Course Outline

Introduction to 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

DP-602 Course FAQs

Are Applied Skills credentials replacing role-based Certifications?

How do I choose between a Certification and an Applied Skill credential?

Will attaining an Applied Skills credential help me pass a Certification exam?

I already have a role-based Certification. Should I pursue an Applied Skills credential?

I’m just getting started on my Microsoft credentialing journey. What should I pursue first: an applied skills credential, a fundamentals Certification, or a role-based Certification?

Related Courses