SkillUp EdTech
Prep for Microsoft Azure Data Engineer Associate Cert DP-203
SkillUp EdTech

Prep for Microsoft Azure Data Engineer Associate Cert DP-203

Taught in English

Course

Gain insight into a topic and learn the fundamentals

Skill-Up EdTech Team
Prateek Kumar

Instructors: Skill-Up EdTech Team

Intermediate level

Recommended experience

2 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Explain how to design data for analysis using Azure Databricks, Apache Spark, and Azure Synapse pipelines.

  • Describe how to ingest, clean, and transform data using Azure Synapse.

  • Identify data processing solutions using Azure Databricks and manage pipelines in Azure Synapse pipelines.

  • Discuss the steps to secure, optimize, and monitor data storage using Azure Synapse Analytics.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

December 2023

Assessments

8 assignments

See how employees at top companies are mastering in-demand skills

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 3 modules in this course

In this module, you will be introduced to the Azure tools available for designing and implementing data storage and data exploration layers. You will gain insight into the three important data engineering tools: Azure Synapse Analytics, Azure Databricks, and Azure Data Lake. You will gain insight into the key concepts and strategies of data partitioning for files, focusing on both Azure Synapse Analytics and Azure Data Lake Storage Gen2. Additionally, you will learn to browse and search metadata in Microsoft Purview Data Catalog for data exploration. The module also delves into the process of creating and executing a compute solution in Azure, which will enable you to make informed decisions regarding data partitioning, enhancing data cataloging capabilities, and efficiently managing data storage and processing resources in Azure.

What's included

6 videos2 readings2 assignments

In this module, you will gain an understanding of data ingestion and transformation techniques. You will also learn about Transact SQL for data transformation, Azure Synapse Pipelines for ETL, Apache Spark for processing, and exploratory data analytics. The module also discusses data loading with PolyBase, the creation of data pipelines, and integration with Jupyter and Python notebooks. Additionally, it delves into configuring data snapshots with Delta Lake and building stream processing solutions using Spark Structured Streaming. Finally, you will gain a comprehensive understanding of data processing options and techniques.

What's included

8 videos1 reading3 assignments

In this module, you will learn about the importance of implementing robust data security measures in Azure, encompassing data encryption, access control through Azure RBAC, and secure data handling. Additionally, you can learn the steps to monitor data storage, optimize query performance through indexers and caching, and troubleshoot Spark job and pipeline run failures effectively. This knowledge is vital for maintaining efficient data storage and retrieval, contributing to improved data processing and analytics. You will also gain insight into two critical areas of Azure data management: Data security and performance optimization. You will also learn some insights on implementing robust data security measures to protect sensitive information effectively.

What's included

7 videos4 readings3 assignments

Instructors

Skill-Up EdTech Team
SkillUp EdTech
45 Courses41,298 learners

Offered by

SkillUp EdTech

Recommended if you're interested in Data Management

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions