ACID, SQL statement types and relational objects

DP-900 · Relational data on Azure · Updated

Learn the four ACID properties, DDL, DML and DCL statements, and when to use views, indexes, stored procedures and joins.

This lesson is part of full DP-900 access

The first 2 DP-900 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-900 question bank.

In this lesson
  • ACID
  • SQL statement categories
  • Joins
  • Database objects
  • Normalization
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-900 course outline

All 8 lessons · Course overview
  1. Structured, semi-structured and unstructured dataCore data concepts Free
  2. Data roles, OLTP and analytical workloadsCore data concepts Free
  3. ACID, SQL statement types and relational objectsRelational data on Azure Full access
  4. Azure SQL family and open-source databasesRelational data on Azure Full access
  5. NoSQL data store typesNon-relational data on Azure Full access
  6. Azure Cosmos DB and Azure StorageNon-relational data on Azure Full access
  7. Analytics services on Azure and Microsoft FabricAnalytics workloads on Azure Full access
  8. Power BI and types of analyticsAnalytics workloads on Azure Full access