Microsoft

Data Engineering on Microsoft Azure Training

(DP-203)

Data Engineering on Microsoft Azure (DP-203)

This course equips participants with the knowledge and skills to design and build secure, scalable, and efficient data processing solutions on Microsoft Azure. Students will learn how to integrate, transform, and consolidate data from various structured and unstructured sources into a format suitable for analytics. The course also covers implementing data storage, managing data pipelines, and optimizing data solutions for performance and cost.

Training at a glance

Level

Intermediate

Duration

4 Days

Experience

1 year: Microsoft

Average Salary

$155,000

Labs

Yes

Training Details

  • Design and implement data storage solutions on Azure
  • Build and manage data pipelines for batch and streaming data
  • Integrate and transform data using Azure Data Factory and Synapse Analytics
  • Implement security and compliance features for data solutions
  • Monitor, troubleshoot, and optimize data processing systems
  • Work effectively with Azure Databricks, Data Lake, and related services
  • Identify design decisions to ensure security and recoverability (disaster recovery)
  • Module 1: Introduction to Data Engineering on Azure
    • Overview of Azure data services and architecture
    • Roles and responsibilities of a Data Engineer
    • Core principles of data engineering in the cloud

  • Module 2: Designing and Implementing Data Storage
    • Choosing the right data storage option
    • Implementing Azure Data Lake Storage Gen2
    • Managing and securing data in Azure storage solutions

  • Module 3: Data Ingestion and Integration
    • Designing data ingestion strategies
    • Building pipelines with Azure Data Factory
    • Working with event-based and streaming data ingestion

  • Module 4: Data Transformation and Processing
    • Using Azure Synapse Analytics for ETL/ELT
    • Data transformation using Azure Databricks
    • Working with structured and unstructured data

  • Module 5: Designing and Developing Data Solutions
    • Implementing batch and real-time data processing
    • Managing data pipelines and orchestration
    • Handling data partitioning and performance tuning

  • Module 6: Securing and Monitoring Data Solutions
    • Applying data security and governance
    • Implementing data masking and encryption
    • Monitoring and troubleshooting data pipelines

  • Module 7: Performance Optimization and Cost Management
    • Optimizing queries and storage performance
    • Managing cost through data lifecycle policies
    • Automating performance tuning and scaling

  • Module 8: Preparing for the DP-203 Exam
    • Review of key concepts and best practices
    • Sample questions and hands-on exercises
    • Exam tips and study strategies


  • Data Engineers
  • Data Architects
  • Business Intelligence (BI) Professionals
  • Basic understanding of cloud concepts and Azure services
  • Experience with data processing languages such as SQL or Python
  • Familiarity with core data concepts (relational and non-relational data)

Upcoming Classes

We offer more than just Microsoft Training

Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

Strategic Planning & Project Management

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.

IT & Cybersecurity

ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.

Leadership & Management

Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.