Core Data Concepts and Relational Data on Azure

Data formats, storage, roles and workloads, and relational databases on Azure, for the DP-900 exam.

MSAZ-120 12 lessons planned ▶ Video lessons coming soon

Offered by HSM University · Microsoft Certification Prep

Course content

  1. 1Structured, semi-structured and unstructured dataComing
  2. 2File formats and data storesComing
  3. 3Transactional and analytical workloadsComing
  4. 4Data roles: administrator, engineer and analystComing
  5. 5Relational concepts: tables, keys and normalizationComing
  6. 6SQL basics: DDL, DML and queriesComing
  7. 7Views, stored procedures and indexesComing
  8. 8The Azure SQL familyComing
  9. 9Azure SQL Database, Managed Instance and SQL on VMsComing
  10. 10Open-source databases on Azure: PostgreSQL and MySQLComing
  11. 11Choosing a relational serviceComing
  12. 12Security basics for relational dataComing

Description

Data formats, storage, roles and workloads, and relational databases on Azure, for the DP-900 exam.