This course runs for a duration of 4 Days.
The class will run daily from 9 AM ET to 5 PM ET.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
This course covers methods and practices to implement data engineering solutions by using Microsoft Fabric. Students will learn how to design and develop effective data loading patterns, data architectures, and orchestration processes. Objectives for this course include ingesting and transforming data and securing, managing, and monitoring data engineering solutions. This course is designed for data professionals with some data integration and orchestration experience.
Who Should Attend?
This audience for this course is data professionals with experience in data extraction, transformation, and loading. DP-700 is designed for professionals who need to create and deploy data engineering solutions using Microsoft Fabric for enterprise-scale data analytics. Learners should also have experience at manipulating and transforming data with one of the following programming languages: Structured Query Language (SQL), PySpark, or Kusto Query Language (KQL).
1. Ingest Data with Dataflows Gen2 in Microsoft Fabric
Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Module assessment
2. Orchestrate Processes and Data Movement with Microsoft Fabric
Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines
Module assessment
3. Use Apache Spark in Microsoft Fabric
Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook
Module assessment
4. Work with Real-Time Data in an Eventhouse in Microsoft Fabric
Get started with an Eventhouse
Use KQL effectively
Materialized views and stored functions
Module assessment
5. Introduction to End-to-End Analytics Using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Module assessment
6. Get Started with Lakehouses in Microsoft Fabric
Explore the Microsoft Fabric lakehouse
Work with Microsoft Fabric lakehouses
Explore and transform data in a lakehouse
Module assessment
7. Use Apache Spark in Microsoft Fabric
Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook
Module assessment
8. Work with Delta Lake Tables in Microsoft Fabric
Understand Delta Lake
Create delta tables
Optimize delta tables
Work with delta tables in Spark
Use delta tables with streaming data
Module assessment
9. Ingest Data with Dataflows Gen2 in Microsoft Fabric
Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Module assessment
10. Orchestrate Processes and Data Movement with Microsoft Fabric
Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines
Module assessment
11. Organize a Fabric Lakehouse Using Medallion Architecture Design
Describe medallion architecture
Implement a medallion architecture in Fabric
Query and report on data in your Fabric lakehouse
Considerations for managing your lakehouse
Module assessment
12. Get Started with Real-Time Intelligence in Microsoft Fabric
What is real-time data analytics?
Real-Time Intelligence in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions
Module assessment
13. Use Eventstream in Microsoft Fabric
Components of Eventstream
Eventstream sources and destinations
Eventstream transformations
Module assessment
14. Work with Real-Time Data in an Eventhouse in Microsoft Fabric
Get started with an Eventhouse
Use KQL effectively
Materialized views and stored functions
Module assessment
15. Create Real-Time Dashboards with Microsoft Fabric
Get started with real-time dashboards
Organize and filter dashboard data
Dashboard management and optimization
Module assessment
16. Use Activator in Microsoft Fabric
Configure Activator for your data
Create rules in Activator
Configure actions in Activator
Module assessment
17. Introduction to End-to-End Analytics Using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Module assessment
18. Get Started with Data Warehouses in Microsoft Fabric
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Module assessment
19. Load Data into a Microsoft Fabric Data Warehouse
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2
Module assessment
20. 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 assessment
21. Monitor a Microsoft Fabric Data Warehouse
Monitor capacity metrics
Monitor current activity
Monitor queries
Module assessment
22. Secure a Microsoft Fabric Data Warehouse
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Module assessment
23. 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 assessment
24. Monitor Activities in Microsoft Fabric
Understand monitoring
Use Microsoft Fabric Monitor Hub
Take action with Microsoft Fabric Activator
Module assessment
25. Secure Data Access in Microsoft Fabric
Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions
Module assessment
26. Administer a Microsoft Fabric Environment
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Module assessment
27. Use Activator in Microsoft Fabric
Configure Activator for your data
Create rules in Activator
Configure actions in Activator
Module assessment
