Azure Data Engineer Certification Preparation

This week i got my new Azure Certification badge (Azure Data Engineer) and today i am writing this article to share all of the resources i collected it during my study this is not a technical article I will not explain any concept or any technical information here this article is repository article.

Exam information

To get Azure Data Engineer Badge you should pass two exams DP-200 and DP-201

1. DP-200 (Implementing an Azure Data Solution)
2. DP-201 (Designing an Azure Data Solution)

Both exams are They are very similar DB-200 related for How to do and How to Implement and DB-201 related for How to design, how to provide a solution, how to choose between data sources, what is the best solution for data movement …etc.

DP-201 Exam contain many cases questions you should read the case very well and answer the questions on this case

Also, during the study, you can prepare for the other two exams because both of them are covering the same concept of Azure Data Engineer. Study well and enter the 4 exams (DP-200, DP-2001, DP-300, DP-900)

1. DP-300 (Administering Relational Databases on Microsoft Azure)
2. DP-900 (Microsoft Azure Data Fundamentals)

After passing two exams you should earn the badge like this https://www.youracclaim.com/badges/b14fd62d-59ca-44c2-aa6d-b0ff85140b0b

Most Important subjects on exams

The most important subjects that you need to understand the concept of it and 90% of both exams are talking about them:

1. Azure SQL DB
2. Azure Cosmos DB
3. Azure Synapse
4. Azure Storage blob and Data lake Gen 2
5. Azure Databricks
6. Azure Data Factory
7. Azure Data Lake Analytics
8. Azure Analysis Services
9. Azure Stream Analytics

Most topics you should cover it on these services:

1. Concept
2. Component
3. How to provisions
4. How to secure
5. How to Optimize
6. How to Monitor

Free Resources

1. Azure SQL for beginners: https://aka.ms/azuresql4beginners or from here https://aka.ms/azuresql4beginnersch9
2. Azure SQL Bootcamp:  https://aka.ms/azuresqlbootcamp
3. Azure SQL Workshop: https://aka.ms/sqlworkshops
4. Azure SQL Workshop Slides: https://aka.ms/azuresqlworkshopslides
5. Azure SQL fundamentals:  https://aka.ms/azuresqlfundamentalsm
6. Data Exposed: https://channel9.msdn.com/Shows/Data-Exposed/
7. My Azure SQL Articles: https://lnkd.in/edn6nyY/#AzureSQL
8. My Azure Cosmos DB Articles: https://lnkd.in/edn6nyY/#AzureCosmosDB
9. Azure Cosmos DB Blog https://devblogs.microsoft.com/cosmosdb/
10. Get Started With Azure Cosmos DB: https://www.youtube.com/playlist?list=PLmamF3YkHLoLLGUtSoxmUkORcWaTyHlXp
11. Implementing Azure Databricks: https://skillmeup.com/course/bypath/azure-data-bricks
12. Introduction to Azure Databricks: https://youtu.be/pIvgEry-zso
13. The month of Azure Databricks: https://www.youtube.com/playlist?list=PLHN2ijxAWBaNM3EA0hM6ZxWuOvVAeDzha
14. Azure Databricks: https://www.youtube.com/playlist?list=PLMWaZteqtEaKi4WAePWtCSQCfQpvBT2U1
15. Databricks Channel: https://www.youtube.com/channel/UC3q8O3Bh2Le8Rj1-Q-_UUbA/playlists
16. Azure Databricks Webinar#1: https://databricks.com/p/webinar/azure-databricks-training-series
17. Azure Databricks Webinar#2: https://pages.databricks.com/azure-databricks-training-series-thank-you-webinar.html
18. Azure Databricks Webinar#3: https://pages.databricks.com/WB-azuretraining-01.html
19. Azure Databricks Webinar#4: https://pages.databricks.com/WB-azuretraining-02.html
20. Azure Databricks Webinar#5: https://pages.databricks.com/WB-azuretraining-03.html
21. Azure Data Factory: https://channel9.msdn.com/Tags/azure-data-factory
22. Azure Data Factory With CI/CD Using Azure Pipeline: https://youtu.be/cLf3nAiGG3Q
23. Azure Data Factory Channel: https://www.youtube.com/playlist?list=PLMWaZteqtEaLTJffbbBzVOv9C0otal1FO
24. Azure Data Factory Real-Time Scenarios: https://www.youtube.com/playlist?list=PLMWaZteqtEaLacN3eS3s8pw2jtwBVb1BH
25. Orchestrating Big Data with Azure Data Factory: https://www.edx.org/course/orchestrating-big-data-with-azure-data-factory
26. Azure Synapse Analytics – An Introduction: https://5minutebi.com/2019/12/04/learning-path-azure-synapse-analytics/
27. Azure SQL Data Warehouse Synapse: https://www.udemy.com/course/azure-sql-data-warehouse-synapse-analytics-free-version/
28. Azure Synapse SQL Analytics: https://youtu.be/h7Dy87CC-Ao
29. My Azure Synapse Articles: https://lnkd.in/edn6nyY/#AzureSynapse
30. The Synapse Sessions: https://www.youtube.com/playlist?list=PLHN2ijxAWBaMl5Bl1KlLpGx-uend0WHP0
31. Delivering a Data Warehouse in the Cloud Course https://www.edx.org/course/delivering-a-data-warehouse-in-the-cloud
32. Creating Databases in Azure SQL Datawarehouse https://channel9.msdn.com/Shows/Cortana-Intelligence-Corner/Creating-Databases-in-Azure-SQL-Datawarehouse
33. Analytics in Azure virtual event https://info.microsoft.com/Analytics-in-Azure-virtual-event-Accelerate-Time-to-Insight-with-Azure-Synapse-Analytics-On-Demand-Registration.html
34. Azure Data Lake: https://channel9.msdn.com/Series/AzureDataLake
35. Processing Big Data with Azure Data Lake Analytics: https://www.edx.org/course/processing-big-data-with-azure-data-lake-analytics
36. Azure Data Engineers QA interview: https://www.sqlshack.com/data-engineer-interview-questions-and-answers-sql-workload-migration-to-microsoft-azure-database-platforms/

Another Free Resources Full Courses

• Data Analyst with SQL Server https://www.datacamp.com/tracks/data-analyst-with-sql-server
• Python Programming https://www.datacamp.com/tracks/python-programming
• Data Engineer with Python https://www.datacamp.com/tracks/data-engineer-with-python

Paid Full Courses

• DP-200 – Implementing an Azure Data Solution
• DP-201 – Designing an Azure Data Solution
• Implementing Azure Data Solution
• DP-200 Implementing Azure Data Exam Prep In One Day
• Professional Azure SQL Database Administration
• DP-300 Administering Relational Databases on Microsoft Azure
• DP-900 Azure Data Fundamentals Exam Prep In One Day

Exam Test Practices

• DP-200 Exam Test : https://www.examtopics.com/exams/microsoft/dp-200/
• DP-201 Exam Test: https://www.examtopics.com/exams/microsoft/dp-201/

Keep Following

• WordPress
• Facebook
• Twitter
• LinkedIn
• YouTube
• Link
• Link

Cloud Tech Website blog survey

IF you found this blog is helpful and sharing useful content please take few second to do rate the website blog from here