DP-700 Microsoft Fabric Data Engineer

Price
Net €
VAT €

Price
Price on Request

Duration
4 days

For companies and job seekers:
this course is 100% fundable!

Location

Course Language
English

Training Solutions
Online Live

Request a consultation Add to favorites Print as PDF

The role of data engineers is changing noticeably: away from isolated pipelines and toward integrated platform solutions. Modern tools combine engineering, analytics, and governance in a single environment and require new skills.

Key topics

Platform thinking in data engineering.
Design of efficient data flows and architectures.
Collaboration between data processing and analysis.
Scaling, security, and cost control.
Best practices for operation and further development.

Prerequisites
Practical knowledge of SQL, basic database skills, and experience with cloud-based data solutions.

Target audience
Designed for data engineers, analytics engineers, BI developers, and technically oriented professionals with a focus on data.

The result is a clearly structured understanding of modern data platforms that classifies technological trends and creates a stable basis for demanding analytics scenarios.

Print as PDF

Course content

Loading data with Dataflows Gen2

Dataflows Gen2 in Fabric
Explore Dataflows Gen2
Connect Dataflows Gen2 & Pipelines

Process and data flow

Pipeline basics
Use the copy tool
Use templates
Start and check processes

Real-time data with Microsoft Fabric

Understanding real-time analytics
Using live data in Microsoft Fabric
Capture and transform data streams
Real-time storage and access
Make data visible immediately
Automatically control processes

Real-time streams in Microsoft Fabric

Components of event streams
Origins and recipients of event streams
Conversions in event streams

Real-time data processing

Launch Eventhouse
Use KQL in a targeted manner
Materialized views and stored procedures

End-to-end analysis

End-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable Microsoft Fabric

Lakehouse integration

Explore Microsoft Fabric
Use lakehouses
Analyze and transform data

Apache Spark in Fabric

Setting up Apache Spark
Execute Spark code
Processing data in the Spark data frame
Using Spark SQL for data
Visualize data in Spark notebook

Delta Lake tables

Understanding delta tables
Developing delta tables
Improving delta tables
Using Spark and delta tables
Applying delta tables for streaming data

Medallion architecture

Explaining medallion structure
Implementing medallion architecture in Fabric
Data queries and reporting in the Fabric lakehouse
Consider lakehouse management

Real-time data visualization

Getting started with real-time dashboards
Additional functions
Tips for optimal use

Data warehouse setup

Data Warehouse Basics
Data Warehouse in Fabric
Querying and transforming data
Preparing data for analysis
Securing and monitoring the data warehouse

Data import

Examine data loading methods
Pipelines for warehouse
Use T-SQL
Dataflow Gen2 for loading and transforming

Data retrieval

Use SQL Editor
Try out the visual editor
Use client tools for warehouse queries

Microsoft Fabric Data Warehouse Monitoring

Monitor capacity
Monitor ongoing processes
Monitor requests

Back up Microsoft Fabric data

Check dynamic masking
Implement row security
Set up column security
Configure SQL rights

Microsoft Fabric with CI/CD

Understanding CI/CD concepts
Setting up version control and Git
Building deployment pipelines
Automating CI/CD with Fabric APIs

Monitoring of Microsoft Fabric

Understanding monitoring
Using Monitor Hub
Activate Activator

Protection during data access

Understanding Fabric Security
Set up access rights
Define permissions

Microsoft Fabric Management

Getting to know fabric architecture
Understanding the role of the fabric administrator
Controlling security in the fabric
Data management within the fabric

Frequently Asked Questions

What are the practical benefits of DP-700 certification in the workplace?

Demonstrates practical data engineering skills in Microsoft Fabric, enhancing your ability to contribute to modern data projects.

What prior knowledge is helpful for DP-700?

A solid foundation in data modeling, SQL, and cloud computing makes it easier to get started and significantly shortens the learning curve.

How relevant is Microsoft Fabric in the market right now?

A rapidly growing ecosystem, with high demand for skilled professionals in integrated data platforms and analytics.

What topics are covered in the exam?

Data integration, transformation, orchestration, and performance optimization within Microsoft Fabric.

How does the DP-700 differ from traditional data engineering certifications?

Focusing on a unified platform rather than fragmented tools reduces complexity in day-to-day project work.

What are some common mistakes that can occur without a solid understanding of fabric?

Inefficient pipelines, high costs, and poor data quality due to a lack of architectural expertise.

For which roles is the DP-700 particularly relevant?

Data engineers, BI developers, and cloud specialists specializing in scalable data solutions.

How quickly can this knowledge be put into practice?

Direct integration into projects is possible, especially when using Microsoft Fabric in existing environments.

Do you have any further questions? Please contact us.

Select your nearest center: *

0800 258 258 055

website@newhorizons.de

First Name *

Surname *

Telephone Number *

Postcode *

E-Mail *

I would like to receive funding for further training – I am currently: *

Company Name

Your message

I hereby confirm that I have taken note of the privacy notice. *