The DP-700: Microsoft Fabric Data Engineer course empowers professionals to design, implement, and manage data solutions using Microsoft Fabric. Explore advanced capabilities like dataflows, pipelines, real-time eventstreams, and lakehouses for scalable analytics. Learn to optimize data management with medallion architecture, secure data access, and administer environments effectively. Hands-on labs and real-world scenarios ensure practical expertise. Unlock the full potential of Microsoft Fabric to deliver end-to-end data engineering solutions.

This course is for Data Engineers.

Data engineering experience.

After completing this course, students will be able to:

• Ingest and transform data using Dataflows Gen2 in Microsoft Fabric.
• Build and monitor data pipelines for seamless orchestration.
• Capture, analyze, and visualize real-time event data with Eventstreams.
• Create lakehouses and query data with Spark and SQL.
• Implement medallion architecture for efficient data organization.
• Secure data access and manage permissions within Microsoft Fabric.
• Develop real-time dashboards for actionable insights.
• Automate deployments with CI/CD and monitor activities using Monitoring Hub

1) Implement a data warehouse with Microsoft Fabric

• Get started with data warehouses in Microsoft Fabric
• Describe data warehouses in Fabric
• Understand a data warehouse vs a data Lakehouse
• Work with data warehouses in Fabric
• Create and manage fact tables and dimensions within a data warehouse
• Lab Analyze data in a data warehouse
• Load data into a Microsoft Fabric data warehouse
• Learn different strategies to load data into a data warehouse in Microsoft Fabric
• Learn how to build a data pipeline to load a warehouse in Microsoft Fabric
• Learn how to load data in a warehouse using TSQL
• Learn how to load and transform data with dataflow Gen 2
• Lab Load data into a warehouse in Microsoft Fabric
• Query a data warehouse in Microsoft Fabric
• Use SQL query editor to query a data warehouse
• Explore how visual query editor works
• Learn how to connect and query a data warehouse using SQL Server Management Studio
• Lab Query a data warehouse in Microsoft Fabric
• Monitor a Microsoft Fabric data warehouse
• Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app
• Monitor current activity in the data warehouse with dynamic management views
• Monitor querying trends with query insights views
• Lab Monitor a data warehouse in Microsoft Fabric
• Secure a Microsoft Fabric data warehouse
• Learn the concepts of securing a data warehouse in Microsoft Fabric
• Learn how to implement dynamic data masking to obscure sensitive information
• Learn how to configure rowlevel security to provide granular control
• Learn how to implement columnlevel security to protect sensitive data
• Learn how to configure granular permissions using TSQL
• Lab Secure a warehouse in Microsoft Fabric

2) Ingest data with Microsoft Fabric

• Ingest Data with Dataflows Gen2 in Microsoft Fabric
• Describe Dataflow capabilities in Microsoft Fabric
• Create Dataflow solutions to ingest and transform data
• Include a Dataflow in a pipeline
• Lab Create and use a Dataflow Gen2 in Microsoft Fabric
• Orchestrate processes and data movement with Microsoft Fabric
• Describe pipeline capabilities in Microsoft Fabric
• Use the Copy Data activity in a pipeline
• Create pipelines based on predefined templates
• Run and monitor pipelines
• Lab Ingest data with a pipeline
• Get started with RealTime Intelligence in Microsoft Fabric
• Microsoft Fabric includes RealTime Intelligence capabilities that you can use to capture analyze visualize and act on realtime streams of event data
• Lab Explore RealTime Intelligence in Fabric
• Use realtime eventstreams in Microsoft Fabric
• Establish source and destinations in Microsoft Fabric Eventstreams
• Capture transform and route data using Microsoft Fabric Eventstreams
• Lab Ingest realtime data with Eventstream in Microsoft Fabric
• Work with realtime data in a Microsoft Fabric eventhouse
• Create an eventhouse in Microsoft Fabric
• Query realtime data by using Kusto Query Language KQL
• Create materialized views and stored functions in a KQL database
• Lab Work with data in a Microsoft Fabric eventhouse

3) Implement a Lakehouse with Microsoft Fabric

• Introduction to endtoend analytics using Microsoft Fabric
• Describe endtoend analytics in Microsoft Fabric
• Get started with lakehouses in Microsoft Fabric
• Describe core features and capabilities of lakehouses in Microsoft Fabric
• Create a lakehouse
• Ingest data into files and tables in a lakehouse
• Query lakehouse tables with SQL
• Lab Create a Microsoft Fabric lakehouse
• Use Apache Spark in Microsoft Fabric
• Configure Spark in a Microsoft Fabric workspace
• Identify suitable scenarios for Spark notebooks and Spark jobs
• Use Spark dataframes to analyze and transform data
• Use Spark SQL to query data in tables and views
• Visualize data in a Spark notebook
• Lab Analyze data with Apache Spark
• Work with Delta Lake tables in Microsoft Fabric
• Understand Delta Lake and delta tables in Microsoft Fabric
• Create and manage delta tables using Spark
• Optimize delta tables
• Use Spark to query and transform data in delta tables
• Use delta tables with Spark structured streaming
• Lab Use delta tables in Apache Spark
• Ingest Data with Dataflows Gen2 in Microsoft Fabric
• Describe Dataflow capabilities in Microsoft Fabric
• Create Dataflow solutions to ingest and transform data
• Include a Dataflow in a pipeline
• Lab Create and use a Dataflow Gen2 in Microsoft Fabric
• Orchestrate processes and data movement with Microsoft Fabric
• Describe pipeline capabilities in Microsoft Fabric
• Use the Copy Data activity in a pipeline
• Create pipelines based on predefined templates
• Run and monitor pipelines
• Lab Ingest data with a pipeline
• Organize a Fabric lakehouse using medallion architecture design
• Describe the principles of using the medallion architecture in data management
• Apply the medallion architecture framework within the Microsoft Fabric environment
• Analyze data stored in the lakehouse using DirectLake in Power BI
• Describe best practices for ensuring the security and governance of data stored in the medallion architecture
• Lab Organize your Fabric lakehouse using a medallion architecture

4) Implement RealTime Intelligence with Microsoft Fabric

• Get started with RealTime Intelligence in Microsoft Fabric
• Microsoft Fabric includes RealTime Intelligence capabilities that you can use to capture analyze visualize and act on realtime streams of event data
• Lab Explore RealTime Intelligence in Fabric
• Use realtime eventstreams in Microsoft Fabric
• Establish source and destinations in Microsoft Fabric Eventstreams
• Capture transform and route data using Microsoft Fabric Eventstreams
• Lab Ingest realtime data with Eventstream in Microsoft Fabric
• Work with realtime data in a Microsoft Fabric eventhouse
• Create an eventhouse in Microsoft Fabric
• Query realtime data by using Kusto Query Language KQL
• Create materialized views and stored functions in a KQL database
• Lab Work with data in a Microsoft Fabric eventhouse
• Create RealTime Dashboards with Microsoft Fabric
• Create a realtime dashboard in Microsoft Fabric
• Use advanced feature of realtime dashboards
• Apply best practices for realtime dashboards
• Lab Get started with realtime dashboards

5) Manage a Microsoft Fabric environment

• Implement continuous integration and continuous delivery CICD in Microsoft Fabric
• Define CICD and describe how its implemented in Fabric
• Implement version control and Git integration
• Use deployment pipelines to automate the deployment process
• Lab Implement deployment pipelines in Microsoft Fabricmate CICD using Fabric APIs
• Monitor activities in Microsoft Fabric
• Apply monitoring concepts to Microsoft Fabric
• Use Monitoring Hub in Microsoft Fabric
• Trigger actions using Activator in Microsoft Fabric
• Lab Monitor Fabric activity in the Monitor hub
• Secure data access in Microsoft Fabric
• Describe the permissions model in Microsoft Fabric
• Configure workspace and item permissions
• Apply granular permissions
• Lab Secure data access in Microsoft Fabric
• Administer a Microsoft Fabric environment
• Describe Fabric admin tasks
• Navigate the admin center
• Manage user access
• Govern data in Fabric