Microsoft DP-700 prep: Fabric Data Engineer Associate

<div>This course covers the content required for the Microsoft DP-700 "Fabric Data Engineer Associate" certification exam, using the Study Guide for "Implementing Analytics Solutions Using Microsoft Fabric", updated in line with the exam update as per 26 January 2026 and 20 April 2026.</div><div><br></div><div>This course is also useful for the following Microsoft Applied Skills:</div><div><ul><li>APL-3008 "Implement a Real-Time Intelligence solution with Microsoft Fabric"</li><li><span style="font-size: 1rem;">APL-3010 "Implement a data warehouse in Microsoft Fabric"</span></li></ul><span style="font-size: 1rem;">Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.</span></div><div><br></div><div><span style="font-size: 1rem;">What do students like you say about this course?</span></div><div><br></div><div>Kin says: "Thank you so much for this content, very helpful.&nbsp; I love the flow of how you explain things starting from the most simple scenario and add complexity gradually, and how you anticipate common questions and address them.&nbsp; I learned more from this than the official Microsoft instructors I got from my workplace... Very well done!"</div><div><br></div><div>David says: "Philip takes time to explain things on a basic level so a novice to the topic can start building knowledge from scratch, following it up by in-depth explanations and details. The practice activities are also a very nice touch!"</div><div><br></div><div>Warren says: "This course is absolutely phenomenal in preparation for the DP-700 but also learning if you have zero experience. Microsoft Fabric is quite a large platform, and the exam can be very broad. Phillip does an outstanding job of covering an incredible amount of content in an easy-to-understand manner. The practice activities are well thought out and actually quite helpful in applying what is being taught.</div><div><br></div><div>There are other resources out there, but this tops them all. Phillip is also incredibly responsive to any questions out there. I cannot understand why anyone would not give this course 5 stars."</div><div><br></div><div>What will you learn in this course?</div><div><ul><li><span style="font-size: 1rem;">Following a quick look around Fabric, we will look at using Dataflow Gen2 and pipelines - ingesting and copying data, including using the M language, and scheduling and monitoring data pipeline runs.</span></li><li><span style="font-size: 1rem;">Next we'll manipulate data using PySpark and SQL in a notebook.</span></li><li><span style="font-size: 1rem;">We'll have a look at loading and saving data using notebooks.</span></li><li><span style="font-size: 1rem;">We'll then manipulating dataframes, by choosing which columns and rows to show.</span></li><li><span style="font-size: 1rem;">We'll then convert data types, aggregating and sorting dataframes,</span></li><li><span style="font-size: 1rem;">We will then be transforming data in a lakehouse, merging and joining data, together with identifying missing data or null values.</span></li><li><span style="font-size: 1rem;">We will then be improving notebook performance and automate notebooks, together with creating objects, such as shortcuts and file partitioning.</span></li><li><span style="font-size: 1rem;">Following this, we'll look at using a data warehouse - transforming data, creating an incremental data load, and managing and optimizing them.</span></li><li>We'll then create an eventhouse, and find out how to transform data using KQL:</li><li>We'll select, filter and aggregate data.</li><li>We'll manipulate data using string, number, datetime and timespan functions.</li><li>We'll end these sections by transforming data, merging and joining data and more.</li><li>Finally, we will look at ingesting and transforming streaming data, including revising KQL knowledge from the DP-600 exam, workspace settings and monitoring.</li></ul></div><div><span style="font-size: 1rem;">No prior knowledge is assumed. We will start from the beginning for all languages and items, although any prior knowledge of M, PySpark, SQL or KQL is useful.</span></div><div><br></div><div>Once you have completed the course, you will have a good knowledge of using notebooks, dataflows, pipelines, data lakehouses and warehouses and eventhouses. And with some practice and knowledge of some additional topics, you could even go for the official Microsoft certification DP-700 - wouldn't the "Microsoft Certified: Fabric Data Engineer Associate" certification look good on your CV or resume?</div><div><br></div><div>I hope to see you in the course - why not have a look at what you could learn?</div>

What you'll learn:

• Implement and manage an analytics solution
• Configure security and governance
• Ingest and transform data
• Monitor and optimize an analytics solution