Course Overview

This course aims to develop your foundational skills in data engineering on Microsoft Fabric, with a focus on the Warehouse concept. You will understand how to save your data in a Warehouse using T-SQL, Dataflow Gen 2 and Data pipelines into Star schema model and efficiently to query your data using T-SQL. Additionally, you will explore how to monitor the performance of the data in your Fabric Warehouse. Through a blend of lectures and hands-on exercises, this course will equip you to effectively work with Warehouses in Microsoft Fabric.  

After completing DP 601 course, students will be able to:

  • Develop foundational skills in data engineering on Microsoft Fabric, focusing on the Warehouse concept.
  • Explore T-SQL's capabilities for data ingestion and querying.
  • Learn how to monitor you Fabric warehouse.
  • Explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines.

Upcoming Batches

Enroll Online
Start Date End Date

2024-09-30

2024-10-01

2024-10-07

2024-10-08

2024-10-14

2024-10-15

2024-10-21

2024-10-22

2024-10-28

2024-10-29

Key Features:

  • Guidance by Certified Experts: Benefit from expert instructors who will lead engaging online training sessions, providing you with valuable insights into Implementing a Data Warehouse using Microsoft Fabric.
  • Interactive Hands-On Labs: Gain practical experience through a series of interactive labs and exercises, allowing you to apply your newly acquired skills in real-world scenarios.
  • Personalized Learning Plans: Enjoy tailor-made training programs that cater to your unique learning requirements, ensuring you receive the most relevant knowledge and guidance.
  • Well-structured use-cases based on real world scenarios to help participants relate the scenarios where you can leverage Data Warehouse in Microsoft Fabric
  • Integrated teaching assistance and support through experts designed Learning Management System (LMS) and Exam Ready platform. 
  • Being a Microsoft Learning Partner, we offer authored curriculum that are at par with industry standards. 

Who Should Attend:

  • The primary audience for this course is data professionals who are familiar with ETL operations, data modeling, extraction, and analytics.
  • It is designed for professionals who are interested in gaining knowledge about Fabric Warehouse architecture in the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies.

Pre-requisites of DP-602 course

    To enrol in this course, it is recommended to have:
  • Basic data concepts and terminology.
  • Fundamental data analytics concepts.
  • The Microsoft Fabric interface and core concepts.
  • Microsoft Fabric warehouses and T-SQL.
  • Microsoft Fabric and data orchestration.

    • Why choose CloudThat as your training partner for DP-602?

    • CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe.
    • We have well-trained, experienced, and certified Subject matter experts and instructors to conduct these trainings.
    • The course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Word.

    Learning objective of the DP-602 Certification Training

    • Describe core features and capabilities of warehouses in Microsoft Fabric
    • Using T-SQL in a Microsoft Fabric workspace
    • Monitoring a Data Warehouse in Microsoft Fabric
    • Implement Dataflow Gen 2 and Data Pipeline for data orchestration in Microsoft Fabric

    Course Outline : Download Course Outline

    • 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
    • Lab - Analyze data in a data warehouse

    • Explore data load strategies
    • Use data pipelines to load a warehouse
    • Load data using T-SQL
    • Load and transform data with Dataflow Gen2
    • Lab - Load data into a warehouse in Microsoft Fabric

    • Use the SQL query editor
    • Explore the visual query editor
    • Use client tools to query a warehouse
    • Lab - Query a data warehouse in Microsoft Fabric

    • Monitor capacity metrics
    • Monitor current activity
    • Monitor queries
    • Lab - Monitor a data warehouse in Microsoft Fabric Use delta tables with streaming data

    Certification details:

    • Obtaining the Microsoft Azure DP-601 Applied Skill Credential certifies your familiarity with Implementing a Lakehouse with Microsoft Fabric.
    • DP-601 Applied skill course will teach you the way on how to Implement a Lakehouse in Microsoft Fabric for various scenarios.
    • Applied skills can be utilized to be ready for more specialized or role-based Azure certifications.
    • We award a certificate of course completion to candidates who pass the DP-601 Microsoft Azure Applied Skills Training.
    • After completing the Microsoft Azure DP-601 assessment, candidates are awarded a Microsoft credential as well. 

    Click to Zoom

    Course Fee

    Select Course date

    Add to Wishlist

    Course ID: 21266

    Course Price at

    $1599 + 0% TAX
    Enroll Now

    FAQs on DP 602

    It is based on one specific skill, Project based, Scenario-specific ability.

    Yes, many Microsoft Learn courses, including this one, are often available for free.

    Participants will need a computer with internet access.

    Familiarity of basic data concepts, data analytics, T-SQL, pipelines may be helpful.

    Use Microsoft's official documentation, practice labs, and exam-focused resources for comprehensive readiness. 

    No. Access Microsoft Learn and complete the assessment. 

    After completing the DP-602 exam, you will receive the Microsoft Credential: Implementing a Lakehouse with Microsoft Fabric

    Enquire Now