Home
DP-700 Microsoft Certified Fabric Data Engineer Associate

Sessions 4 days
Duration 30 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

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

DP-700 Microsoft Certified Fabric Data Engineer Associate

Course Code: C1752

Be the first to review this product

The DP-700 Microsoft Certified Fabric Data Engineer Associate course equips data professionals with the knowledge and practical skills to design and implement scalable data solutions using Microsoft Fabric. Learners will explore data ingestion with Dataflows Gen2, orchestrate processes using Apache Spark, and work with real-time analytics using eventstreams and eventhouses. The course emphasizes lakehouse architecture, medallion design, and Delta Lake tables for building unified and efficient data platforms.

Participants will also learn to implement enterprise-grade data warehouses in Microsoft Fabric, monitor and secure analytics environments, and manage real-time dashboards for dynamic reporting. With added focus on CI/CD practices, security, and administration, this course provides a complete foundation for professionals aiming to earn the DP-700 certification and thrive as modern data engineers in hybrid analytics environments.

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

We are an Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at a Pearson VUE test center.

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - Microsoft Certified Fabric Data Engineer Associate (DP-700) Training

Course Fee

$1,400.00 (GST-exclusive)

$1,526.00 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Include Exam Voucher *

No
Yes +$120.00

Course Time * Course Time: No. of Participants

Sponsorship *

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

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

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.

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

This course prepares you for the DP-700 certification exam, covering all official exam domains and their approximate weightings:

Domain 1 Implement and manage an analytics solution (32.5%)

Configure Microsoft Fabric workspace settings (Spark, domain, OneLake, Apache Airflow)
Implement lifecycle management in Fabric: version control, database projects, deployment pipelines
Configure security and governance: workspace/item-level access, row/column/object/folder-file-level access, dynamic data masking, sensitivity labels, item endorsement, audit logs, OneLake security
Orchestrate processes: choose between Dataflow Gen2, pipeline and notebook; design schedules and event-based triggers; implement orchestration patterns with notebooks and pipelines (parameters, dynamic expressions)

Domain 2 Ingest and transform data (32.5%)

Design and implement full and incremental data loads; prepare data for a dimensional model; design a loading pattern for streaming data
Ingest and transform batch data: choose data store and transformation tool (Dataflows Gen2, notebooks, KQL, T-SQL), create OneLake shortcuts, implement mirroring, ingest via pipelines
Transform data using PySpark, SQL, and KQL; denormalize, group/aggregate data; handle duplicate, missing, and late-arriving data
Ingest and transform streaming data: choose streaming engine, use Eventstreams/Spark structured streaming/KQL, choose native tables vs OneLake shortcuts, create windowing functions

Domain 3 Monitor and optimize an analytics solution (32.5%)

Monitor Fabric items: data ingestion, data transformation, semantic model refresh, configure alerts
Identify and resolve errors in pipelines, Dataflow Gen2, notebooks, Eventhouse, Eventstream, T-SQL, and OneLake shortcuts
Optimize performance of Lakehouse tables, pipelines, data warehouse, Eventstreams/Eventhouses, Spark, and query performance

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:

free Microsoft Azure account (https://azure.microsoft.com/en-us/) here

Hardware: Window or Mac Laptops

Job Roles

Microsoft Fabric Data Engineer
Data Ingestion Specialist
Real-Time Analytics Engineer
Lakehouse Developer
Apache Spark Engineer (Fabric)
Eventstream Data Engineer
Delta Lake Engineer
Fabric Lakehouse Architect
Data Platform Engineer
Data Pipeline Developer
Data Warehouse Developer
Fabric Eventhouse Engineer
Cloud Data Engineer
Analytics Operations Engineer
Data Transformation Engineer
Business Intelligence Data Engineer
CI/CD Data Platform Engineer
Fabric Environment Administrator
Enterprise Data Engineer
Data Automation Specialist

Trainers

Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.

Anil is a ACLP certified trainer. He is an Enterprise Cloud and DevOps Consultant , responsible for helping clients to move Virtual data centre to Private Cloud based on OpenStack and Public Cloud ( AWS, Azure and Google cloud) . Consulting and training experience on Devops tool chain like github , Jenkins, Sonarqube, Docker & kubernetes, Cloud foundry, Openshift, Ansible and SaltStack. Lot of my Role is involved design and implementation of a solution and training.

Ajay is a ACLP certied trainer. Ajay is a vendor neutral cloud consultant and training expert on Cloud , with several Private cloud deployments in India and cloud migration knowledge .He is a Cloud and DevOps enthusiast with consulting, deployment and training expertise on OpenStack, AWS, Google Cloud ,Azure, Jenkins, and Docker Ajay has 18 + years Industry experience as IT entrepreneur and 9 years in Cloud and Devops technical consulting, implementation and training area, currently working in capacity of Vice President – Cloud and Devops services handling singapore and India.