Microsoft Applied Skills badge
9.00

Fill-starFill-starFill-starFill-starFill-starFill-starFill-starFill-starFill-starunfill-star

28 reviews

Implement a Data Warehouse with Microsoft Fabric (DP-602)

The Implement a Data Warehouse with Microsoft Fabric (DP-602) course provides IT professionals and data engineers with essential skills to build and manage data warehouses using Microsoft Fabric. Learn how to optimize performance, ensure scalability, and integrate data sources for advanced analytics and reporting.

course: Implement a Data Warehouse with Microsoft Fabric (DP-602)

Duration: 1 day

Format: Virtual or Classroom

ktk-icon Attend this and 60+ other Microsoft courses for FREE with Unlimited Microsoft Training

Overview

The DP-602 course teaches participants how to design, implement, and manage data warehouses using Microsoft Fabric. You will explore concepts like data modeling, ETL processes, and performance tuning to create efficient, scalable data solutions. The course also covers integration with various data sources, enabling seamless data flow for real-time business intelligence. By the end of this course, you'll have hands-on experience in managing data warehouses to support analytics and decision-making.

This course includes
  • intructor-icon Instructor-led training
  • intructor-icon Personal Learning Path
  • intructor-icon Email, chat and phone support

Top companies trust Readynez

Who is this course for?

Who is the Implement a Data Warehouse with Microsoft Fabric (DP-602) course for?

The "Implement a Data Warehouse with Microsoft Fabric (DP-602)" course is designed for data engineers, business intelligence professionals, and IT specialists who want to enhance their skills in building and managing data warehouses using Microsoft Fabric. It's also suitable for developers and analysts who are looking to improve data integration, ETL processes, and real-time analytics capabilities to support business decision-making. This course is ideal for anyone seeking to implement efficient, scalable data solutions in a cloud environment.

Curriculum

What you will learn during our Implement a Data Warehouse with Microsoft Fabric (DP-602) course.

  • 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 endtoend analytics solution.
  • 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
  • Knowledge check
  • Summary
  • Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional TSQL capabilities for easy data management and analysis.
  • Introduction
  • Explore data load strategies
  • Use data pipelines to load a warehouse
  • Load data using TSQL
  • Load and transform data with Dataflow Gen2
  • Exercise: Load data into a warehouse in Microsoft Fabric
  • Knowledge check
  • Summary
  • Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional TSQL capabilities for easy data management and analysis.
  • 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
  • Knowledge check
  • Summary
  • 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.
  • Introduction
  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries
  • Exercise Monitor a data warehouse in Microsoft Fabric
  • Knowledge check
  • Summary
  • Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional TSQL capabilities for easy data management and analysis.
  • Introduction
  • Explore dynamic data masking
  • Implement rowlevel security
  • Implement columnlevel security
  • Configure SQL granular permissions using TSQL
  • Exercise: Secure a warehouse in Microsoft Fabric
  • Knowledge check
  • Summary

Preparation

How to best be prepared for our Implement a Data Warehouse with Microsoft Fabric (DP-602) course.

  • Orange-check Basic understanding of data warehousing concepts.
  • Orange-check Experience with SQL and ETL processes.
  • Orange-check Familiarity with cloud-based data platforms like Microsoft Fabric.

Meet our instructors

Meet some of the Readynez Instructors you can meet on your course. They are experts, passionate about what they do, and dedicated to give back to their industry, their field, and those who want to learn, explore, and advance in their careers.

Michel Aguilera

Michel excels with a vast expertise in the fields of consulting, training and project management.

Michel excels with a vast expertise in the fields of consulting, training and project management. During his 20 year IT career he has acquired a wide range of skills, both technical and management wise.  He is a keen lover of challenges and keeps up to date with market expectations. Having a multi-cultural approach, he can even train in 5 different languages ​​with ease.

In addition to this, he is very experienced as a hands-on consultant and has worked with various integrations and migrations including Windows migrations, Datacenter consolidations, multiple solution integrations, ITSM implementations. He is also an expert on Cloud environments and in virtualization techniques as well (Operating systems and applications).

 

READ MORE
Read Less

Julian Sharp

Julian Sharp delivers high-quality, LIVE instructor-led training in Microsoft Dynamics 365 and Power Platform for professionals seeking real-world skills and certification readiness. With decades of industry experience and deep technical expertise, he helps learners master complex solutions efficiently.

Meet the Instructor: Julian Sharp
MCT | MVP | Solution Architect | Dynamics 365 & Power Platform Expert

With 20+ years of experience and over 16 years specializing in Dynamics CRM/365 and Power Platform, Julian has trained thousands of professionals and helped organizations solve real business challenges using Microsoft technologies.

A Microsoft Certified Trainer since 2007 and a Microsoft MVP, Julian brings a rare combination of deep technical knowledge and a practical, business-first mindset.

He’s not just an instructor - he’s a community leader, consultant, and solution architect trusted by enterprises across the globe.

  • Microsoft MVP – Business Applications

  • Specialist in Dynamics 365, Power Platform & Azure

  • Developer of Microsoft courseware
  • Speaker & mentor at Microsoft community events

Ready to build solutions with one of the best in the field?

Explore upcoming courses with Julian Sharp to get started.

READ MORE
Read Less

FAQ

FAQs for the Implement a Data Warehouse with Microsoft Fabric (DP-602) course.

The DP-602 course is designed for IT professionals and data engineers aiming to build and manage data warehouses using Microsoft Fabric. It covers data modeling, ETL processes, performance tuning, and data integration, ensuring participants can create scalable solutions for business intelligence.

Preparing for this course requires a basic understanding of data modeling, ETL processes, and SQL. Familiarity with Microsoft Fabric or similar data platforms will enhance your learning experience.

Basic knowledge of data warehousing concepts, experience with SQL, and familiarity with cloud-based data platforms like Microsoft Fabric are recommended prerequisites.

The course costs €705, which includes live training sessions, interactive labs, and comprehensive course materials focused on implementing data warehouses with Microsoft Fabric.

Topics include data modeling, ETL processes, data integration, performance tuning, and managing data flow for real-time analytics. The course also covers best practices for data warehouse scalability and maintenance.

Yes, completing this course enhances your skills in data warehousing, making you more qualified for roles like data engineer or business intelligence specialist. As data analytics continues to grow, expertise in tools like Microsoft Fabric is highly valuable.

While this course doesn’t offer formal certification, it provides practical skills in implementing data warehouses with Microsoft Fabric, boosting your qualifications in data engineering and analytics roles.

Yes, the DP-602 course is available online, featuring live interactive sessions, hands-on labs, and real-time instructor support, providing flexibility for participants.

The course is moderately challenging, especially for those unfamiliar with data warehouses or cloud platforms. However, it’s designed to guide participants step-by-step, making it manageable for learners with some background in data engineering.

Completing this course can qualify you for roles like data engineer or data warehouse specialist. Salaries for these roles typically range from €65,000 to €120,000 annually, depending on experience and location.

Reviews

Feedback from our delegates.

Johan Andersson

Johan Andersson

Easy to attend over Teams and an excellent instructor gave me great value for the time I invested.

Stephen Ridgway

Readynez is the best training provider I've used for many years. Their customer service is first class, prices are very competitive and instruction excellent.

Why Pay More??

Go beyond one certification Achieve Complete Mastery medal-icon

Why settle for just one certification course when you can attend ALL certification courses for the price of less than one single course?

Unlimited Training delegate
  • Orange-check 60+ Courses for the price of less than one
  • Orange-check LIVE Instructor-led courses
  • Orange-check Expert Instructors at your fingertips
  • Orange-check Money-back Guarantee
  • Orange-check Flexible payment options
EXPLORE UNLIMITED TRAINING

A perfect tool to help us develop the skills and competencies we need for success

Its IT Icon Kasper Meyer Christensen


A training solution so good that it pays for itself

50%
MINIMUM SAVINGS

Businesses leveraging Readynez Unlimited save at least 50% on their training and certifications - and many up to 80%

2.4 x
COURSES PER LICENSE

Unlimited license holders attend on average 2.4 courses per year


Get more for less with Unlimited Training

Courses

60+ INSTRUCTOR-LED COURSES

For the price of less than one course.

Quality

SAME HIGH READYNEZ QUALITY

Just cheaper and more flexible.

Flexible

FLEXIBLE PAYMENT OPTIONS

The easiest, most flexible and cheapest way to get Certified.

Unlimited

UNLIMITED ACCESS

Attend as many courses you want - no limitations!

Money Gaurantee

MONEY-BACK GUARANTEE

Refund provided if license costs surpass the value of your training.

Training

LIVE TRAININGS ONLY

Interact 1-on-1 with 50+ seasoned instructors.

Basket

{{item.CourseTitle}}

Price: {{item.ItemPriceExVatFormatted}} {{item.Currency}}