Call +91 8248680690 Email: info.wasa.educon@gmail.com

Welome to WASA Educational Consultancy

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.

Course Code: M1165

Fee

₹5,000,000.00

Course Date

Course Time

* Required Fields

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to info@tertiarycourses.com.ng 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

  • Reload captcha

You May Be Interested In These Courses