Skip to content
SkillSpring

Cheat sheet

Azure Data Fundamentals (DP-900)

Core data concepts and the relational, non-relational and analytics services on Azure.

Study & career skills · Beginner · English · 128 videos · 4 h 41 min · videos by ExamPro

By the end you should be able to

  1. Explain relational and non-relational data concepts
  2. Identify the Azure data services for each workload
  3. Describe analytics and data-warehouse workloads

Watch in this order

  1. 1.Introduction to the DP-9006 min
  2. 2.Meet Your Instructor2 min
  3. 3.Exam Guide5 min
  4. 4.Core Data Related Services5 min
  5. 5.Types of Cloud Computing2 min
  6. 6.Azure Data Related Roles2 min
  7. 7.DP-900: database administrator common tools2 min
  8. 8.Data Engineering Common Tools1 min
  9. 9.Data Analyst Common Tools1 min
  10. 10.Dp 900: Data Overview1 min
  11. 11.Introduction to Data1 min
  12. 12.Data Documents1 min
  13. 13.Data Sets3 min
  14. 14.Data Types4 min
  15. 15.Schema vs Schemaless2 min
  16. 16.Query and Querying2 min
  17. 17.Batch vs Stream Processing3 min
  18. 18.Relational Data2 min
  19. 19.Relational Data Relationships1 min
  20. 20.Row Store vs Column Store2 min
  21. 21.Database Index1 min
  22. 22.Data Integrity vs Data Corruption2 min
  23. 23.Pivot Table2 min
  24. 24.Strongly Consistent vs Eventually Consistent1 min
  25. 25.DP 900— Synchronous vs Asynchronous2 min
  26. 26.Non Relational Data1 min
  27. 27.Data Source1 min
  28. 28.Data Store1 min
  29. 29.Database1 min
  30. 30.Data Warehouse2 min
  31. 31.Data Mart1 min
  32. 32.Data Lakes1 min
  33. 33.Data Lakehouse1 min
  34. 34.Data Structures1 min
  35. 35.Unstructured Data1 min
  36. 36.Semi Structured1 min
  37. 37.Semi Structured Data Structures1 min
  38. 38.Semi Structure JSON1 min
  39. 39.Semi Structure ORC1 min
  40. 40.Semi Structure Parquets1 min
  41. 41.Semi Structure AVRO1 min
  42. 42.Structured Data1 min
  43. 43.Data Mining1 min
  44. 44.Data Mining Methods1 min
  45. 45.Data Wrangling1 min
  46. 46.Data Modeling2 min
  47. 47.ETL vs ELT2 min
  48. 48.Data Analytics1 min
  49. 49.Key Performance Indicators1 min
  50. 50.Data Analytic Techniques2 min
  51. 51.Microsoft One Drive1 min
  52. 52.Microsoft Sharepoint1 min
  53. 53.Data Core Concepts CheatSheet8 min
  54. 54.Azure Synapse Analytics2 min
  55. 55.Sypanse SQL and pools2 min
  56. 56.Synapse Key Features1 min
  57. 57.Azure Data Lake (Gen 2)1 min
  58. 58.Polybase1 min
  59. 59.Synapse Elt1 min
  60. 60.Azure Data Lake Analytics1 min
  61. 61.Azure Sypanse and Data Lakes CheatSheet1 min
  62. 62.Azure Blob Storage1 min
  63. 63.Azure Files2 min
  64. 64.Azure Storage Accounts CheatSheet1 min
  65. 65.Business Intelligence1 min
  66. 66.Power Bi3 min
  67. 67.Power Bi Visulations2 min
  68. 68.Power Bi Embedded1 min
  69. 69.Power Bi Interactive Reports2 min
  70. 70.Power Bi Service and Dashboards1 min
  71. 71.Reports vs Dashboards1 min
  72. 72.Paginated Reports1 min
  73. 73.DP 900 —PowerBi CheatSheet2 min
  74. 74.Olap vs Oltp1 min
  75. 75.Open Source Relational Databases3 min
  76. 76.Read Replicas1 min
  77. 77.Citus Postgres Hyperscale1 min
  78. 78.Azure SQL Family2 min
  79. 79.Elastic Pools1 min
  80. 80.Relational Databases CheatSheet2 min
  81. 81.T SQL1 min
  82. 82.DDL1 min
  83. 83.DML1 min
  84. 84.DQL1 min
  85. 85.DCL1 min
  86. 86.TCL1 min
  87. 87.SQL Documents Comparisons1 min
  88. 88.T SQL CheatSheet1 min
  89. 89.DP 900: Connectivity Architecture SQL1 min
  90. 90.Database Authentication1 min
  91. 91.Network Connectivity1 min
  92. 92.Azure Defender for SQL1 min
  93. 93.Azure Database Server Firewalls1 min
  94. 94.Always Encrypted1 min
  95. 95.Database Role Based Access Controls1 min
  96. 96.Transparent Data Encryption1 min
  97. 97.Dynamic Data Masking1 min
  98. 98.Private Links1 min
  99. 99.Database Security Cheatsheet2 min
  100. 100.Document Store in Azure Cosmos DB1 min
  101. 101.Introduction to MongoDB in Azure Cosmos DB2 min
  102. 102.Graph Database in Azure Cosmos DB1 min
  103. 103.Apache Tinkerpop and Gremlin API in Azure Cosmos DB2 min
  104. 104.Understanding Azure Tables1 min
  105. 105.Introduction to Azure Cosmos DB2 min
  106. 106.Azure Table Storage vs Cosmos DB2 min
  107. 107.Apache Hadoop1 min
  108. 108.Apache Kafka1 min
  109. 109.HDInsights1 min
  110. 110.Hadoop CheatSheet1 min
  111. 111.Apache Spark2 min
  112. 112.Azure Databricks2 min
  113. 113.Apache Spark and Databricks CheatSheet1 min
  114. 114.SQL Server Management Studio1 min
  115. 115.SQL Server Data Tools1 min
  116. 116.Azure Data Studio1 min
  117. 117.Azure Data Factory1 min
  118. 118.ETL and SQL Tools CheatSheet1 min
  119. 119.Install and Use Power BI3 min
  120. 120.Launch Azure SQL and Use Data Studio27 min
  121. 121.Use Azure SQL as data source in Power BI9 min
  122. 122.Use SSMS to perform a query on Azure SQL3 min
  123. 123.Create Blob and File Storage10 min
  124. 124.Exploring Various NoSQL Engines in CosmosDB Follow Along29 min
  125. 125.Create a ELT job from Azure SQL to Blob Storage6 min
  126. 126.Explore Azure Databricks7 min
  127. 127.Explore Azure Synapse Analytics5 min
  128. 128.Cleanup3 min

Before you start: None

skillspring · Videos belong to ExamPro and play from YouTube. Printed for personal study.