173
LESSONS
ALL
SKILL LEVEL
15:32
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
This course some of the content required for the DP-700 “Fabric Data Engineer Engineer Associate” certification exam. By the end of the course, you will able to able to create Fabric items, and use PySpark and SQL to query batch data, and KQL to query streaming data.
WHO IS THE COURSE FOR?
This course is for you if you want to implement data engineering solutions using Microsoft Fabric.
No prior knowledge is needed. Previous experience with PySpark, SQL and KQL will help, but this is not essential.
.
LEARNING PATH
USING DATA PIPELINES AND DATAFLOWS
- Ingesting data and scheduling a Dataflow Gen2.
- Ingesting data and scheduling a data pipeline.
- Implement file partitioning using a pipeline
MANIPULATING DATA USING A NOTEBOOK, PYSPARK, SQL
- Loading and saving data using notebooks
- Choosing columns and rows in a dataframe
- Converting data types, aggregating and sorting dataframes
- Transforming data in a lakehouse
- Optimizing performance in notebooks
TRANSFORMING DATA IN A WAREHOUSE AND EVENTHOUSE
- Implementing Slowly Changing Dimensions
- Creating incremental data loads
- Manage and Optimize Data Warehouses
- Manipulating data using KQL
OTHER TOPICS
- Ingesting and transforming streaming data
- Creating shortcuts and mirroring.
- Optimizing performance
- Workspace settings and Monitoring
REVIEWS
“Haven’t taken the DP700 exam yet, but wanted to already leave a review because it really helped me ease into certain topics in which I wasn’t that confident in before. Phillip 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! I feel more confident now and will do some more reading on my own + some practice exams to get ready for real.”
“Thank you so much for this content, very helpful. 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. I learned more from this than the official Microsoft instructors I got from my workplace… Very well done!”
“The course are really complete with all Fabric relevant topics.”
.
