DP-602 course by Flexmind

DP-602 Implement a Data Warehouse with Microsoft Fabric

DP-602 Implement a Data Warehouse with Microsoft Fabric course is designed for data professionals who are familiar with data modeling, extraction, and analytics.

The DP-602 training course prepares individuals for implementing data warehouses using Microsoft Azure's Synapse Analytics (formerly SQL Data Warehouse). It covers data warehouse concepts, loading data, integrating big data, security, management, and developing analytics solutions. Attendees learn to leverage Azure services, optimize and troubleshoot data warehouses, and implement Advanced Analytics and machine learning.

 

While there are no required prerequisites for taking this course, it is recommended that students have:

  • Knowledge of Azure Synapse Analytics
  • Experience in data warehousing concepts
  • Familiarity with Azure Data Lake Storage
  • Understanding of data modeling
  • Basic proficiency in T-SQL
  • Familiar with ETL processes using Azure Data Factory

In this course, you’ll learn how to implement data lakehouses with Microsoft Fabric.You will:

  • Understand the foundation of data engineering on Fabric through the exploration of the Lakehouse.
  • Explore the powerful capabilities of Apache Spark for distributed data processing.
  • Gain essential techniques for efficient data management, versioning, and reliability by working with Delta Lake tables.
  • Explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines.

This DP-602 Implement a Data Warehouse with Microsoft Fabric course includes exercises to enable you to learn practical skills with the technologies.

Microsoft Courseware

Instructor-Led Training

Course Duration: 1-Day (8-Hours)

Microsoft Official Lab Exercises

Delivered by MCT

Cloud Lab Access

Advance Your Skills with Flexmind (Microsoft Partner)

The primary audience for this DP-602 course are IT professionals seeking expertise in Microsoft Fabric for data warehousing, Database administrators aiming to implement a scalable Data Warehouse, Business intelligence specialists focused on Microsoft technologies, Data architects interested in learning data warehouse implementation with Microsoft Fabric, Technical team leads overseeing data warehouse projects

 

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

Module 1: Get started with data warehouses in Microsoft Fabric

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

Instructor-Led Training

8-Hours of Instructor-Led Training One to one doubt resolution sessions Microsoft Official Lab Access

Learning Objectives - DP-602 Implement a Data Warehouse with Microsoft Fabric

In this course, you'll learn how to implement data Warehouse with Microsoft Fabric. You will:
  • 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
Reviews

Dipak Agarwal - Business Analyst at Genpact

(5/5)
Excellent professional & comfortable environment to learn

The training was good, I would like to go through some more training.

Gurpreet Marwaha - IAM Analyst at National Australia Bank, Australia

(5/5)
I learned a lot

Excellent Office 365 training provided by Flexmind

Kiranmai Yachareni - Web Developer at Total Quality Logistics, USA

(5/5)
Excellent ability to clarify all the queries I raised

Thank You! I would definitely recommend it to others. The training session was very informative and interactive. Very useful and definitely thought-provoking. All the module sessions were clear and interactive, great, and friendly. Catered to all levels, which was good for those just starting out and those with more experience. I really appreciate the recorded videos and training material, which would be definitely helpful for later references.

Praveen S (Associate at Grant Thornton LLP)

(5/5)
Excellent knowledge of the trainer on the Subject

I attended PowerApps/Flow training from Flexmind. The topics of the course were well organized & knowledge of the trainer on the subject was excellent. It was very helpful and I will apply in my day to day task at the office. I will definitely recommend a friend or colleague to attend courses from Flexmind.

Related Courses