Course Information

  • Sessions 1 day
  • Duration 7.5 hrs
  • Level Beginner
  • Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Infotech - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Infotech.

DP-602T00 Implement a Data Warehouse with Microsoft Fabric

Course Code: C1312

What's This Course About

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.

Funding Options

No funding is available for this course

Course Fee

$350.00 (GST-exclusive)
$381.50 (GST-inclusive)

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

Cancellation & Reschedule Policy

  • You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
  • Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Course Details

What You'll Learn

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

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

Job Roles

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

Trainers

Trainers

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations. Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes. Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally. Mohamed Afiq: Mohamed Afiq is a ACTA certifed trainer. Mohamed Afiq startup CTO for 3 years building proprietary delivery system from scratch and then managing a team of 20 developers. He builted multiple web apps using MEAN or similar stacks. He is also a founder and sole developer for PlayTours: https://playtours.app/ . He leads instructor at CodeNinja, teaching coding to kids 9-16 years old and teach adults front-end and back-end for web development.

Review

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