Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam

Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam

freeCodeCamp.org via freeCodeCamp Direct link

Normalized vs Denomralized data

20 of 130

20 of 130

Normalized vs Denomralized data

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Azure Data Fundamentals Certification (DP-900) - Full Course to PASS the Exam

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Auzre Core Data Related Services
  2. 2 Types of Cloud Computing
  3. 3 Azure Data Related Roles
  4. 4 Database Administrator Common tools
  5. 5 Data Engineering Common tools
  6. 6 Data Analyst Common tools
  7. 7 Data Overview
  8. 8 Introduction to Data
  9. 9 Data documents
  10. 10 Data sets
  11. 11 Data types
  12. 12 Schema vs Schemaless
  13. 13 Query and Querying
  14. 14 Batch vs Stream processing
  15. 15 Relational data
  16. 16 Relational data Relationships
  17. 17 Row store vs Column store
  18. 18 Database Index
  19. 19 Data Integegrity vs Data Corruption
  20. 20 Normalized vs Denomralized data
  21. 21 Pivot table
  22. 22 Strongly consistent vs Eventually consistent
  23. 23 Synchronus vs Asynchronous
  24. 24 Non relational data
  25. 25 Data source
  26. 26 Data store
  27. 27 Database
  28. 28 Data warehouse
  29. 29 Data mart
  30. 30 Data lakes
  31. 31 Data lakehouse
  32. 32 Data structures
  33. 33 Unstructured data
  34. 34 Semi structured
  35. 35 Semi structured Data Structures
  36. 36 Semi structure JSON
  37. 37 semi structure ORC
  38. 38 semi structure Parquets
  39. 39 semi structure AVRO
  40. 40 Structured Data
  41. 41 Data mining
  42. 42 Data mining methods
  43. 43 Data wrangling
  44. 44 Ddata modeling
  45. 45 ETL vs ELT
  46. 46 Data analytics
  47. 47 Key performance indicators KPI
  48. 48 Data Analytic Techniques
  49. 49 Microsoft One Drive
  50. 50 Microsoft Sharepoint
  51. 51 Data Core Concepts CheatSheet
  52. 52 Azure Synapse Analytics
  53. 53 Sypanse SQL and pools
  54. 54 Synapse Key Features
  55. 55 Azure Data Lake Gen 2
  56. 56 Polybase
  57. 57 Synapse ELT
  58. 58 Azure Data Lake Analytics
  59. 59 Azure Sypanse and Data Lakes CheatSheet
  60. 60 Azure Blob Storage
  61. 61 Azure Files
  62. 62 Azure Storage Accounts CheatSheet
  63. 63 Business Intelligence
  64. 64 Power BI
  65. 65 Power BI Visualizations
  66. 66 Power BI Embedded
  67. 67 Power BI Interactive Reports
  68. 68 Power BI Service and Dashboards
  69. 69 Reports vs Dashboards
  70. 70 Paginated Reports
  71. 71 Power BI CheatSheet
  72. 72 Structured Query Language
  73. 73 OLAP vs OLAP
  74. 74 Open Source Relational Databases
  75. 75 Read Replicas
  76. 76 Citus Postgres Hyperscale
  77. 77 Azure SQL Family
  78. 78 Elastic pools
  79. 79 Relational Databases CheatSheet
  80. 80 T SQL
  81. 81 Data Defintion Language
  82. 82 Data Manipulation Language
  83. 83 Data Query Language
  84. 84 Data Control Language
  85. 85 Transaction Control Langauge
  86. 86 SQL Document Comparsions
  87. 87 T SQL CheatSheet
  88. 88 Connectivity Architecture
  89. 89 Database Authentication
  90. 90 Network Connectivity
  91. 91 Azure Defender for SQL
  92. 92 Azure Database Server Firewalls
  93. 93 Always Encrypted
  94. 94 Role Based Access Controls
  95. 95 Transparent Data Encryption
  96. 96 Dynamic Data Masking
  97. 97 Private Links
  98. 98 Database Security Cheatsheet
  99. 99 Key Value Store
  100. 100 Document Store
  101. 101 Mongo DB
  102. 102 Graph Database
  103. 103 Apache Tinkerpop and Gremlin
  104. 104 Azure Tables
  105. 105 Azure Cosmos DB
  106. 106 Azure Table Account Storage vs Cosmos DB
  107. 107 Azure Tables and CosmosDB CheatSheet
  108. 108 Apache Hadoop
  109. 109 Apache Kafka
  110. 110 HDInsights
  111. 111 Hadoop CheatSheet
  112. 112 Apache Spark
  113. 113 Azure Databricks
  114. 114 Apache Spark and Databricks CheatSheet
  115. 115 SQL Server Management Studio
  116. 116 SQL Server Data Tools
  117. 117 Azure Data Studio
  118. 118 Azure Data Factory
  119. 119 SQL Server Integration Services
  120. 120 ETL and SQL Tools CheatSheet
  121. 121 Install and Use Power BI
  122. 122 Launch Azure SQL and Use Data Studio
  123. 123 Use Azure SQL as data source in Power BI
  124. 124 Use SSMS to perform a query on Azure SQL
  125. 125 Create Blob and File storage
  126. 126 Explore CosmosDB various NoSQL engines
  127. 127 Create a ELT job from Azure SQL to Blob Storage
  128. 128 Explore Azure Databricks
  129. 129 Explore Azure Synapse Analytics
  130. 130 Cleanup

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.