Microsoft Certified Fabric Data Engineer Associate (DP-700) Training
About This Course
This Microsoft Certified Fabric Data Engineer Associate (DP-700) Training equips participants with the practical knowledge and skills to design, implement, and manage modern data solutions using Microsoft Fabric. Learners will identify optimal data sources and processing methods based on business requirements and learn to orchestrate data movement, implement real-time intelligence, and use Apache Spark for data transformations. The course emphasizes practical application of lakehouses and Delta Lake tables, as well as maintaining data accuracy and business alignment through robust transformation techniques.
Participants will gain hands-on experience in managing data environments, including secure access control, activity monitoring, and CI/CD implementation within Microsoft Fabric. Through various real-world scenarios, learners will process multiple data streams, maintain data integrity, and construct optimized data warehouse systems. This course is ideal for professionals seeking to boost their data engineering capabilities and prepare for the DP-700 certification.
What You'll Learn
LO1: Identify and propose data sources and processing methods, focusing on business requirements and data specifications to optimize data gathering.
LO2: Operate and document data warehouse systems, balancing data access optimization with loading, and map relationships among varied data systems.
LO3: Process multiple data streams, utilizing system capabilities to address new data challenges and enhance data processing methods.
LO4: Apply data transformation techniques to maintain data integrity, focusing on optimizing data accuracy and functionality in line with business needs.
Topics Covered:
Topic 1 Ingest data with Microsoft Fabric
- Ingest Data with Dataflows Gen2 in Microsoft Fabric
- Orchestrate processes and data movement with Microsoft Fabric
- Use Apache Spark in Microsoft Fabric
- Get started with Real-Time Intelligence in Microsoft Fabric
Topic 2 Implement a Lakehouse with Microsoft Fabric
- Introduction to end-to-end analytics using Microsoft Fabric
- 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
Topic 3 Implement Real-Time Intelligence with Microsoft Fabric
- 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
- Create Real-Time Dashboards with Microsoft Fabric
Topic 4 Implement a data warehouse with Microsoft Fabric
- Introduction to end-to-end analytics using Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
Topic 5 Manage a Microsoft Fabric environment
- Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric
- Monitor activities in Microsoft Fabric
- Secure data access in Microsoft Fabric
Entry Requirements
Knowledge and Skills
• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience
Target age group: 21-65 years old