Prepare for your DP-203 exam
Requirements
- Students need to have a basic understanding on basic data formats - CSV, JSON
- Students should have some basic knowledge on any one database system along with Structured Query Language
Description
This course is designed for students who want to attain the "Microsoft Certified: Azure Data Engineer Associate" certificationThis course has contents for the Exam DP-203
The objectives covered in this course are
- Design and implement data storage (40-45%)
- Design and develop data processing (25-30%)
- Design and implement data security (10-15%)
- Monitor and optimize data storage and data processing (10-15%)
- What is the purpose of an Azure Data Lake Gen 2 storage account
- Basics on Transact-SQL commands
- How to work with Azure Synapse. This will include building a data warehouse into a dedicated SQL Pool.
- How to build an ETL pipeline with the help of Azure Data Factory. There will be various scenarios on how to create mapping data flows.
- How to stream data with the use of Azure Stream Analytics. You can see how SQL commands can be used for your streaming data.
- Basics on the Scala programming language, and SPARK
- How to work with SPARK, Scala in Azure Databricks. We will see how to work with Notebooks. We will also see how to stream data into Azure Databricks.
- The different security measures and monitoring aspects to consider when working with Azure services
Who this course is for:
- Those who want to pursue the Microsoft Certified: Azure Data Engineer Associate
- Those who want to pass the DP-203 Certification exam
