dp203

KO | EN

gitlite — search

#python #react #ai #typescript #llm #golang #docker #macos #windows #cli #kubernetes #mcp #openai #open-source

(★ 81)

Exam DP-203: Data Engineering on Microsoft Azure Crash Course

File Explorer

Download Latest Version (.zip)

- - 01_BUG_REPORT.md
  - 02_FEATURE_REQUEST.md
  - 03_CODEBASE_IMPROVEMENT.md
  - 04_SUPPORT_QUESTION.md
  - config.yml
- CODEOWNERS
- PULL_REQUEST_TEMPLATE.md
- - DatabaseLog.csv
  - DimAccount.csv
  - DimCurrency.csv
  - DimCustomer.csv
  - DimDate.csv
  - DimDepartmentGroup.csv
  - DimEmployee.csv
  - DimGeography.csv
  - DimOrganization.csv
  - DimProduct.csv
  - DimProductCategory.csv
  - DimProductSubcategory.csv
  - DimPromotion.csv
  - DimReseller.csv
  - DimSalesReason.csv
  - DimSalesTerritory.csv
  - DimScenario.csv
  - FactAdditionalInternationalProductDescription.csv
  - FactCallCenter.csv
  - FactCurrencyRate.csv
  - FactFinance.csv
  - FactInternetSales.csv
  - FactInternetSalesReason.csv
  - FactProductInventory.csv
  - FactResellerSales.csv
  - FactSalesQuota.csv
  - FactSurveyResponse.csv
  - instawdbdw.sql
  - NewFactCurrencyRate.csv
  - ProspectiveBuyer.csv
  - sysdiagrams.csv
- - 01.sql
- - LICENSE.txt
  - Microsoft.ServiceBus.dll
  - Microsoft.ServiceBus.xml
  - Microsoft.WindowsAzure.Configuration.dll
  - Microsoft.WindowsAzure.Configuration.xml
  - Newtonsoft.Json.dll
  - Newtonsoft.Json.xml
  - telcodatagen.exe
  - telcodatagen.exe.config
  - telcodatagen.vshost.exe
  - telcodatagen.vshost.exe.config
  - telcodatagen.vshost.exe.manifest
- 01_Create_Customer_Tables.sql
- AdventureWorks Sales.pbix
- AdventureWorks Sales.xlsx
- Analyze_Spark_Pool.ipynb
- audio2.wav-speech-to-text-csv-output.csv
- Automobile price data _Raw_.csv
- aworks.sql
- azure-sql-database-firewall-rules.sql
- azure-sql-row-level-security.sql
- azuresql-database-firewall.sql
- azuresql-database-tde.ps1
- bankmarketing_train.csv
- batman.wav-speech-to-text-csv-output.csv
- Change-Distribution (1).sql
- clients.csv
- Contoso-DDL.sql
- Contoso-LOAD.sql
- cosmos-container-rbac.ps1
- CosmosDB-Link.ipynb
- create-emp-table.sql
- create-tables-example.sql
- create-tables.sql
- create-user.sql
- DP-203-ETL.dbc
- emp.txt
- emp2.txt
- enable-azuresql-database-tde.ps1
- families.json
- families2.json
- HVAC.csv
- Import_PolyBase_Copy.sql
- InputStream.json
- insert-data-into-tables.txt
- moviesDB.csv
- mysql-queries.sql
- new-db-user.sql
- NutritionData.json
- NYCTripSmall.parquet
- Partition-Switch.sql
- Partition_Tables.sql
- PolyBase-Load.sql
- PolyBase.sql
- Query_Serverless_Pool.sql
- restore-db-managed-instance.sql
- sale-small-20191230-snappy.parquet
- sale-small-20191231-snappy.parquet
- sample-sql-queries.sql
- SampleCourseData
- SampleCreditData
- SamplePersonData
- SampleStudentData
- SELECTParquetData.sql
- Spark-Pool-Notebook.ipynb
- speech_pandas_dataframe_output.csv
- stopwords.csv
- stream-analytics-queries.sql
- stream-analytics-query.saql
- synapse-data-load-copy.sql
- synapse-data-load-polybase.sql
- synapse-etl.sql
- Test_Data_Flow.sql
- TestOrcFile.testTimestamp.orc
- titanic.csv
- tweets.csv
- twitter.avro
- userdata1.parquet
- vnet.json
- VolcanoData.json
- whatstheweatherlike.wav-speech-to-text-csv-output.csv
- load-synapse-sql.sql
- query-synapse-sql.sql
.gitignore
dls.bicep
DP-203-course-TOC.md
image.png
LICENSE
powershell.ps1
README.md
sql.json
warner-DP-203-slides.pptx

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Exam DP-203: Data Engineering on Microsoft Azure Certification Study Blueprint

## Theoretical Knowledge

* [Azure documentation](https://docs.microsoft.com/en-us/azure/)
* [Data Lake Storage Gen 2 docs](https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-introduction)
* [Storage account docs](https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview)
* [Azure Synapse docs](https://docs.microsoft.com/en-us/azure/synapse-analytics/)
* [Azure Data Factory docs](https://docs.microsoft.com/en-us/azure/data-factory/introduction)
* [Azure SQL Database docs](https://docs.microsoft.com/en-us/azure/azure-sql/database/)
* [Cosmos DB docs](https://docs.microsoft.com/en-us/azure/cosmos-db/)
* [Azure Databricks docs](https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks)
* [Slowly changing dimensions](https://docs.microsoft.com/en-us/learn/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/)
* [Azure Synapse: Copy and Transform Data](https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse?tabs=data-factory)
* [Azure Databricks: ETL with Scala](https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-extract-load-sql-data-warehouse)
* [Microsoft Learn SCD tutorial](https://docs.microsoft.com/en-us/learn/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/)
* [Raspberry Pi IoT Online Simulator](https://azure-samples.github.io/raspberry-pi-web-simulator/)
* [Transact-SQL Language Reference](https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15)
* [Microsoft Fabric](https://learn.microsoft.com/en-us/fabric/get-started/microsoft-fabric-overview)
* [Microsoft Purview](https://learn.microsoft.com/en-us/purview/purview)

## Hands-on Skill Development

* [Microsoft Learn](https://docs.microsoft.com/en-us/learn/certifications/roles/data-engineer)
* [Microsoft Official Curriculum DP-203 Labs](https://github.com/MicrosoftLearning/DP-203-Data-Engineer)
* [Pluralsight](https://app.pluralsight.com/paths/skills/microsoft-exam-dp-203-data-engineering-on-microsoft-azure)
* [Cloud Academy](https://cloudacademy.com/learning-paths/dp-203-exam-preparation-data-engineering-on-microsoft-azure-3191/)
* [Log Analytics Query Playground](https://portal.loganalytics.io/demo)
* [Raspberry Pi Azure IoT Online Simulator](https://azure-samples.github.io/raspberry-pi-web-simulator/#GetStarted)

## Practice exams

* [MeasureUp Official DP-203 Practice Test](https://www.measureup.com/microsoft-practice-test-dp-203-data-engineering-azure.html)
* [Microsoft Certification Practice Assessments](https://learn.microsoft.com/en-us/certifications/practice-assessments-for-microsoft-certifications)
* [Whizlabs](https://www.whizlabs.com/microsoft-azure-certification-dp-203/)
* [Tim's MeasureUp vs Whizlabs Comparison Video](https://www.youtube.com/watch?v=_aH4DbpcJWA&t=2s)
* [Udemy](https://www.udemy.com/course/data-engineering-on-microsoft-azure/)

## About the exam

* [Exam DP-203](https://docs.microsoft.com/en-us/learn/certifications/exams/dp-203)
* [DP-203 exam blueprint](https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-203#skills-measured-as-of-november-2-2023)
* [Azure Data Engineer Associate certification](https://docs.microsoft.com/en-us/learn/certifications/azure-data-engineer/)
* [Microsoft Certification Special Offers](https://www.microsoft.com/en-us/learning/offers.aspx)
* [About Online Exams](https://www.microsoft.com/en-us/learning/online-exams.aspx)
* [MS Certification Policies and FAQs](https://www.microsoft.com/en-us/learning/certification-exam-policies.aspx)
* [Pearson VUE Grievances](https://home.pearsonvue.com/microsoft/contact)
* [Tim's online testing helper video](https://www.youtube.com/watch?v=myf6r5nulj0&feature=youtu.be)
* [Tim's exam registration helper video](https://www.youtube.com/watch?v=FOFWbSYbbVI)
* [Microsoft Learn blog](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog)
* [Certification Dashboard](https://aka.ms/certdashboard)

dp203

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

dp203

File Explorer

Today's picks

Was this content helpful?

Recent Feedback

Download README