Call +603 7931 9658 Email: sales@tertiarycourses.com.my

HRD Corp Approved Training Provider Malaysia - AI and Certification Trainings

DP-602T00 Implement a Data Warehouse with Microsoft Fabric

The DP-602T00 Implement a Data Warehouse with Microsoft Fabric course provides a comprehensive understanding of end-to-end data analytics and management. Learn the fundamentals of Microsoft Fabric data warehouses, data loading strategies, SQL querying techniques, and data security implementations. Through hands-on exercises, explore how to transform, prepare, and analyze data for business insights while securing your data with advanced access controls such as row-level and column-level security.

This course covers essential topics including monitoring warehouse performance, optimizing query execution, and ensuring data governance. You will gain expertise in data transformation using T-SQL, Dataflow Gen2, and data pipelines. By the end of the course, you will be equipped with the skills to implement, manage, and secure data warehouses in Microsoft Fabric, making you a valuable asset in data engineering and analytics teams.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

HRD Corp Claimable Course for Employers Registered with HRD Corp

HRDF claimable

Course Code: M1165

Fee

MYR1,000.00

Course Date

Course Time

* Required Fields

Disclaimer:

The course dates displayed on our website are tentative and subject to trainer availability. We will confirm the final date after checking with the trainer. You are also welcome to email us your preferred date at sales@tertiarycourses.com.my, and we will do our best to coordinate with the trainer's schedule.

Post-Course Support

We may provide consultation related to the subject matter after the course. Please email your queries to sales@tertiarycourses.com.my and we will forward your queries to the subject matter experts and get back to you asap.

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

Topic 1 Introduction to end-to-end analytics using Microsoft Fabric

  • Explore end-to-end analytics with Microsoft Fabric
  • Data teams and Microsoft Fabric
  • Enable and use Microsoft Fabric

Topic 2 Get started with data warehouses in Microsoft Fabric

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

Topic 3 Load data into a Microsoft Fabric 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
  • Load data into a warehouse in Microsoft Fabric

Topic 4 Query a data warehouse in Microsoft Fabric

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

Topic 5 Monitor a Microsoft Fabric data warehouse

  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries
  • Monitor a data warehouse in Microsoft Fabric

Topic 6 Secure a Microsoft Fabric data warehouse

  • Explore dynamic data masking
  • Implement row-level security
  • Implement column-level security
  • Configure SQL granular permissions using T-SQL
  • Secure a warehouse in Microsoft Fabric

Course Info

.

Job Roles

  • Data Engineer
  • Microsoft Fabric Developer
  • Big Data Engineer
  • Cloud Data Architect
  • Data Analytics Consultant
  • Apache Spark Developer
  • Data Solutions Architect
  • Machine Learning Engineer
  • Business Intelligence Developer
  • Microsoft Fabric Administrator
  • Database Administrator
  • Delta Lake Engineer
  • ETL Developer
  • Data Science Engineer
  • Cloud Solutions Engineer
  • Real-Time Data Engineer
  • Data Platform Specialist
  • Data Pipeline Developer
  • Microsoft 365 Data Engineer
  • Data Governance Specialist
gy Research Analyst

Trainers

Mohammad Reza Aminian: Mohammad Reza Aminian is a software engineer and PhD candidate in field of Artificial Intelligence with more than 4 years experience of teaching web technologies and scripting languages. skilled in PHP, JavaScript, system design, Laravel, and Vue.js frameworks. He has been involved in the development and implementation of web-based management systems, web applications and APIs in different organizations and companies.

Leong YH: Leong YH is a career trainer specializing in Java and open-source solutions such as Debian GNU/Linux, Liferay, Vaadin, Cayenne, PostgreSQL, J2EE and more. Though a CIMA graduate, he delights in learning and effective teaching a wide array of IT technologies to the uninitiated. For example, he taught COBOL in 1998.

Chee Tat: Chee Tat started his first job in startup - AMS. That's where he sharpened his skills in Full-stack Java Web Development, Software Design, and soft skills such as requirements gathering with client, client-handling during UAT, client training and "how to drive in and out from Singapore". 8 months later, AMS decided to promote Chee Tat as Team Lead after seeing his leadership potential. 4 years later, Chee Tat joined IBM via the headhunter. Started as an individual contributor, Chee Tat was playing around with many IBM Middleware/SOA products such as MQ, WMB and etc. Chee Tat also designed and built many Java programs combined with other IBM Middleware products as interfaces to the clients' legacy systems. 1 year later he was promoted as SOA Adapter Team Lead to lead 3-5 developers. Chee Tat's won 3 awards during his service with IBM.

Raj R: Raj R has more than 10 years, experience in architecting solutions in , Big Data , Data Analytics, Data Science , Artificial Intelligence , Machine Learning, IoT, and system integration.He has being coaching SQL, No-SQL, distributed applications (cloud /on-premise) , software methodologies, and integration tools.

Write Your Own Review

You're reviewing: DP-602T00 Implement a Data Warehouse with Microsoft Fabric

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

You May Be Interested In These Courses