Course Details
Course Details
What You'll Learn
This course prepares you for the DP-700 certification exam, covering all official exam domains and their approximate weightings:
Domain 1 Implement and manage an analytics solution (32.5%)
- Configure Microsoft Fabric workspace settings (Spark, domain, OneLake, Apache Airflow)
- Implement lifecycle management: version control, database projects, deployment pipelines
- Configure security and governance: workspace/item-level access controls, row/column/object/file-level security, dynamic data masking, sensitivity labels, item endorsement, audit logs, OneLake security
- Orchestrate processes: choose between Dataflow Gen2, pipeline, and notebook; design schedules and event-based triggers; implement orchestration patterns with parameters and dynamic expressions
Domain 2 Ingest and transform data (32.5%)
- Design and implement full and incremental data loading patterns, including for dimensional models and streaming data
- Ingest and transform batch data: choose appropriate data store and transformation tool (Dataflows Gen2, notebooks, KQL, T-SQL), create OneLake shortcuts, implement mirroring, ingest via pipelines
- Transform data using PySpark, SQL, and KQL; denormalize, group/aggregate data; handle duplicate, missing, and late-arriving data
- Ingest and transform streaming data: choose streaming engine, process data via Eventstreams, Spark structured streaming, and KQL; create windowing functions
Domain 3 Monitor and optimize an analytics solution (32.5%)
- Monitor Fabric items: data ingestion, data transformation, semantic model refresh, and configure alerts
- Identify and resolve errors in pipelines, Dataflow Gen2, notebooks, Eventhouse, Eventstream, T-SQL, and OneLake shortcuts
- Optimize performance of Lakehouse tables, pipelines, data warehouses, Eventstreams/Eventhouses, Spark jobs, and queries
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
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: 18-65 years old
Minimum Software/Hardware Requirement
Software:
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Engineer
- Azure Data Engineer
- Cloud Data Engineer
- Business Intelligence Developer
- Data Architect
- Data Scientist
- Machine Learning Engineer
- Big Data Engineer
- Data Analyst
- Database Administrator
- Cloud Solutions Architect
- DevOps Engineer
- Software Developer
- IT Professional
- Systems Analyst
Trainers
Trainers
Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.
Review
Customer Reviews (8)
- Good course materials Review by Course Participant/Trainee
-
The trainer is an expert in the subject and shared many practical insights from real projects. (Posted on 12/04/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Learned a lot Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 09/04/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Excellent course Review by Course Participant/Trainee
-
Really enjoyed the training. The examples were relevant and the pace was just right. (Posted on 05/03/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Practical and relevant Review by Course Participant/Trainee
-
The trainer is an expert in the subject and shared many practical insights from real projects. (Posted on 05/03/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Hands-on and practical Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 08/02/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses