Unlock This Course & The Entire Vault™ Library
Have questions about our subscriptions? Call 1-800-264-9029 or email an account manager.
Login Buy SubscriptionDP-700T00: Implement Data Engineering Solutions using Microsoft Fabric
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.
What you will learn
With a focus on practical applications, the course covers:
- Big data
- Data analytics
- Data engineering
- Data integration
- Data management
What products and services will you use and learn about in this course
- OneLake
- Data Factory
- Dataflows Gen2
- Lakehouse
- Data Warehouse
- Real-Time Intelligence (Real-time Analytics )
- KQL Database & Kusto Query Language (KQL
- Notebooks
- Activator
- PySpark (Python)
- T-SQL (Transact-SQL)
- KQL
Prepare for the Microsoft Certified: Fabric Data Engineer Associate Certification
This course is designed to help students confidently prepare for the DP-700: Microsoft Certified: Fabric Data Engineer Associate exam.
Note: To pass the certification test, studying outside the course may be required to ensure all the concepts are fully understood.
Learning Path: Explore end-to-end analytics with Microsoft Fabric
Modules:
- Introduction
- Get started with lakehouses in Microsoft Fabric
- Use Apache Spark in Microsoft Fabric
- Work with Delta Lake tables in Microsoft Fabric
- Ingest data with Dataflows (Gen2) in Microsoft Fabric
Exercise:
- Create and ingest data with a Microsoft Fabric lakehouse
- Analyze data with Apache Spark
- Use delta tables in Apache Spark
- Create and use a Dataflow Gen2 in Microsoft Fabric
Learning Path: Orchestrate processes and data movement
Modules:
- Organize a Fabric lakehouse using medallion architecture design
- Get started with Real-Time Intelligence in Microsoft Fabric
- Use real time eventstreams in Microsoft Fabric
- Work with real-time data in a Microsoft Fabric eventhouse
Exercises
- Ingest data with a pipeline
- Organize your Fabric lakehouse using a medallion architecture
- Get started with Real-Time Intelligence in Microsoft Fabric
- Ingest real-time data with Eventstreams in Microsoft Fabric
- Work with data in a Microsoft Fabric eventhouse
Learning Path: Create Real-Time Dashboards Use Activator
Modules:
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Fabric SQL DB
- Monitor a Microsoft Fabric data warehouse
- Secure a Microsoft Fabric data warehouse
- Tools for Fabric – VS Code
Exercises:
- Get started with Analyzing in data warehouse
- Load data into a Microsoft Fabric data warehouse
- Work with SQL Database in Microsoft Fabric
- Monitor a data warehouse in Microsoft Fabric
Learning Path: Implement continuous integration/continuous delivery (CI/CD)
Modules:
- Introduction
- Monitor activities in Microsoft
- One Lake security
- Secure data access in Microsoft Fabric
- Administer Microsoft Fabric
Exercises:
- Implement deployment pipelines in Microsoft Fabric
- Use Activator in Fabric
- Monitor Fabric activity in the Monitor hub
- Secure data access in Microsoft Fabric
