DP-602 Implement a Data Warehouse with Microsoft Fabric

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

Overview

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

 

Modules

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

Fees And Schedule

Instructor-Led Training

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

Learning Objectives

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

How do our DP-602 Implement a Data Warehouse with Microsoft Fabric Course Work?

Your Roadmap to become successful

Learn Live Classes • Self-Paced

Upskill yourself by gaining insights from leading professionals' vast experience.

Practice

Sharpen your skills by learning through course assignments, live projects, and regular assessments and quizzes.

Ask

Resolve your queries from industry experts with our dedicated one-to-one doubt-clearing sessions.

Build

Craft a diverse portfolio and appealing resume, and optimize LinkedIn to showcase your skills

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

Course Related Posts