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

Loading Dates...

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.

Array

  • 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

Pre-requisites of DP-602 course

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

Select Course date

Loading Dates...
Add to Wishlist

Course ID: 21266

Course Price at

Loading price info...
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