• Home
  • DP-203 Microsoft Azure Data Engineer Associate Training

DP-203 Microsoft Azure Data Engineer Associate Training

Course Information

  • Sessions 4 days
  • Duration 30 hrs
  • Level Intermediate
  • Assessment NA

Venue

Course Brochure

Download Course Brochure

Certification

  • Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

DP-203 Microsoft Azure Data Engineer Associate Training

Course Code: C1000

8 Review(s) | Add Your Review

Share

What's This Course About

Harness the full potential of PowerPoint with this essential training. Beginning with crafting impactful presentations, whether starting from scratch or utilizing templates, you will delve into integrating text, images, tables, and videos seamlessly. Learn the art of slide design with Slide Master, Theme, and Designer tools, ensuring your presentations always maintain a professional edge. SmartArt, a pivotal feature, aids in embedding diagrams, enhancing visual comprehension for your audience.

Advance your presentation prowess with techniques that elevate user experience. Dive into formatting images, arranging objects, and optimizing slide transitions. The course also spotlights the potent Morph transition, which adds a dynamic flair to your decks. For those aiming to perfect their delivery, the addition of speaker notes and the use of Presenter Coach will be invaluable. Finally, with the Presenter View, seamlessly manage your slides during live presentations, ensuring a smooth and impactful delivery every time.

Bonus: Free Practice Exams

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

WSQ Funding

Full Fee ₵5,500.00 Before GST
GST ₵495.00 9% of fee
Baseline Nett ₵3,245.00 SG/PR age 21+ · 50% funded
MCES / SME Nett ₵2,145.00 SG age 40+ · 70% funded
Funding and Grant Applications

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - Infographics and Data Visualization with PowerPoint

Course Fee

₵5,500.00

Course Date

Course Time

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to info@tertiarycourses.com.gh and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
  • Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

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

is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies

Review

Customer Reviews (8)

Would attend again Review by Course Participant/Trainee
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
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 8/1/2024)
Good course materials Review by Course Participant/Trainee
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
The trainer is an expert in the subject and shared many practical insights from real projects. (Posted on 7/5/2024)
Hands-on and practical Review by Course Participant/Trainee
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
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 1/3/2024)

Items 6 to 8 of 8 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: DP-203 Microsoft Azure Data Engineer Associate Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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