Training: Microsoft Fabric Data Engineer (DP-700)

Ref. DP-700

Download PDF

Duration:

4

days

Exam:

Optional

Level:

Intermediate

Funding:

Eligible

Home > Trainings > IT Pro > Analytics and Data Management > Microsoft Fabric Data Engineer (DP-700)

Microsoft Fabric Data Engineer (DP-700)

Mastering Data Engineering with Microsoft Fabric

This training teaches you how to design and develop data engineering solutions using Microsoft Fabric. You will learn to ingest, transform, and orchestrate data to optimize your analytical processes. The course covers the use of Gen2 dataflows, pipeline management, and real-time intelligence utilization.

You will explore how to store and query data using lakehouses and data warehouses. Leveraging Apache Spark and Delta Lake tables will enable you to process massive data volumes for in-depth analytics. Each module includes practical exercises to apply concepts and strengthen your skills.

Enhance your skills to achieve the DP-700 certification

This program is designed for data professionals aiming to develop high-performance analytical solutions. You will learn to automate processes, query data warehouses, and visualize real-time data flows. The training also prepares you for the DP-700 certification, which is recognized in the field of data engineering.

Participant Profiles

Data engineers
Data solution architects
Data analysts
Developers specializing in data processing

Objectives

Master Gen2 dataflows
Orchestrate processes with pipelines
Leverage real-time intelligence
Create and manage lakehouses
Use Apache Spark for analytics
Optimize Delta Lake tables
Secure and monitor a data warehouse
Automate deployment with CI/CD

Prerequisites

Proficiency in SQL, PySpark, or KQL
Experience in data extraction and transformation
Understanding of data storage and orchestration concepts

Course Content

Module 1: Ingest data with Gen2 dataflows in Microsoft Fabric

Understand Gen2 dataflows in Microsoft Fabric
Explore a Gen2 dataflow in Microsoft Fabric
Integrate Gen2 dataflows and pipelines in Microsoft Fabric

Module 2: Orchestrate processes and data movement with Microsoft Fabric

Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines

Module 3: Get started with Real-Time Intelligence in Microsoft Fabric

What is real-time data analytics?
Real-time insights in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions

Module 4: Use real-time event streams in Microsoft Fabric

Event stream components
Eventstream sources and destinations
Eventstream transformations

Module 5: Use real-time data in a Microsoft Fabric eventhouse

Get started with an eventhouse
Use KQL effectively
Materialized views and stored functions

Module 6: Introduction to end-to-end analytics with Microsoft Fabric

Explore end-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable and use Microsoft Fabric

Module 7: Get started with lakehouses in Microsoft Fabric

Explore the Microsoft Fabric lakehouse
Work with Microsoft Fabric data lakes
Explore and transform data in a lakehouse

Module 8: Use Apache Spark in Microsoft Fabric

Prepare to use Apache Spark
Run Spark code
Use data in a Spark dataframe
Use data with Spark SQL
Visualize data in a Spark notebook

Module 9: Use Delta Lake tables in Microsoft Fabric

Understand Delta Lake
Create Delta tables
Optimize Delta tables
Use Delta tables in Spark
Use Delta tables with streaming data

Module 10: Ingest data with Gen2 dataflows in Microsoft Fabric

Understand Gen2 dataflows in Microsoft Fabric
Explore a Gen2 dataflow in Microsoft Fabric
Integrate Gen2 dataflows and pipelines in Microsoft Fabric

Module 11: Orchestrate processes and data movement with Microsoft Fabric

Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines

Module 12: Organize a Fabric lakehouse using medallion architecture design

Describe medallion architecture
Implement medallion architecture in Fabric
Query data and generate reports in your Fabric lakehouse
Considerations for managing your lakehouse

Module 13: Get started with Real-Time Intelligence in Microsoft Fabric

What is real-time data analytics?
Real-time insights in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions

Module 14: Use Eventstreams in Microsoft Fabric

Event stream components
Eventstream sources and destinations
Eventstream transformations

Module 15: Use real-time data in a Microsoft Fabric eventhouse

Get started with an eventhouse
Use KQL effectively
Materialized views and stored functions

Module 16: Create real-time dashboards in Microsoft Fabric

Get started with real-time dashboards
Advanced features
Best practices for real-time dashboards

Module 17: Get started with data warehouses in Microsoft Fabric

Understand the basics of a data warehouse
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse

Module 18: Load data into a Microsoft Fabric data warehouse

Explore data loading strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2

Module 19: Query a data warehouse in Microsoft Fabric

Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse

Module 20: Monitor a Microsoft Fabric data warehouse

Monitor capacity metrics
Monitor current activity
Monitor queries

Module 21: Secure a Microsoft Fabric data warehouse

Overview of dynamic data masking
Implement row-level security
Implement column-level security
Configure granular SQL permissions using T-SQL

Module 22: Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric

Understand continuous integration and continuous delivery (CI/CD)
Implement version control and Git integration
Implement deployment pipelines
Automate CI/CD using Fabric APIs

Module 23: Monitor activities in Microsoft Fabric

Monitor data ingestion
Monitor data transformation
Monitor and refresh semantic models
Use Delta tables with streaming data

Module 24: Secure data access in Microsoft Fabric

Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions

Module 25: Administer a Microsoft Fabric environment

Understand Fabric architecture
Understand the Fabric Administrator role
Manage Fabric security
Govern data in Fabric

Documentation

Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Exam

This course prepares you for the DP-700 certification: Fabric Data Engineer Associate.

Complementary Courses

Microsoft Fabric Analytics Engineer (DP-600) | DP-600

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

A comprehensive training to master Microsoft Fabric and pass the DP-700 certification

Data management and analytics play a key role in business performance. The “Microsoft Fabric Data Engineers” training prepares you to design large-scale data processing and orchestration solutions. This program teaches you to leverage all Microsoft Fabric features to automate processes, analyze real-time data streams, and structure your data optimally. By taking this course, you will develop the skills needed to pass the DP-700 certification and meet organizations’ data management needs.

Ingest and transform data with Microsoft Fabric

The first step in using data is to collect and transform it. The training teaches you how to use Gen2 dataflows to ingest data from various sources and prepare it for analysis. You will learn how to configure pipelines in Data Factory to automate these processes while ensuring data quality. With these skills, you will be able to centralize large volumes of data and ensure their transformation for optimal utilization.

Orchestrate and automate analytical processes

Process orchestration allows you to automate data flows and ensure smooth execution of analytical tasks. This course teaches you how to create and monitor pipelines in Microsoft Fabric, using predefined templates to accelerate development. You will also learn how to monitor pipeline execution and optimize their performance to efficiently process large amounts of data.

Leverage real-time intelligence and Eventstreams

With Real-Time Intelligence features, you will learn to analyze real-time data streams and automate actions based on detected events. The training covers the use of Eventstreams to capture and process data from various sources. You will learn to configure event streams, apply transformations, and store data for immediate analysis. This approach will enable you to develop responsive solutions capable of meeting business needs in real time.

Optimize data storage and analysis

To fully leverage data potential, it is essential to store it efficiently and facilitate its access. This course trains you to use lakehouses and data warehouses in Microsoft Fabric. You will learn how to organize your data using medallion architecture and query large datasets using SQL and KQL. The training also covers the use of Apache Spark and Delta Lake tables to process continuous data streams and perform complex analyses.

Secure and monitor data to ensure its integrity

Data security is a priority for all organizations. You will learn to configure granular permissions, dynamically mask sensitive data, and monitor the activity of your data warehouses. The course also shows you how to use the monitoring hub to track data ingestion and transformation in real time. With these skills, you can ensure data confidentiality while complying with current regulations.

Automate deployment and manage production environments

To efficiently deploy your analytical solutions, you will learn to implement continuous integration and continuous delivery (CI/CD) using Git and Fabric APIs. This approach will make it easier to collaborate with your development team and ensure quick updates to your pipelines and analytical models. Finally, you will discover how to administer a Microsoft Fabric environment by configuring security and governing data access according to your organization’s needs.

FAQ

What are the prerequisites for this training?
It is recommended to have knowledge of SQL, PySpark, or KQL and experience in data extraction and transformation.

Who is this training for?
This training is intended for data engineers, solution architects, analysts, and developers specializing in data processing.

What are the objectives of this training?
The objectives include mastering Gen2 dataflows, pipeline orchestration, real-time analysis, using lakehouses and data warehouses, as well as data security and monitoring.

How does this training prepare you for the DP-700 certification?
The program covers all the skills assessed during the DP-700 exam and offers practical exercises to train you in real-world conditions.

What benefits can I expect from this training?
You will be able to design and deploy high-performance data solutions, process real-time streams, and optimize data storage and access while ensuring their security.