Chapter 2 of 4 · Microsoft DP-900
Identify Considerations for Relational Data on Azure
Relational concepts, normalization, SQL statements, database objects and the Azure SQL family.
- 3topics
- 16 minfast track
- 1diagrams and exhibits
- 20–25%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Relational Concepts and NormalizationDP-900 relational concepts: tables, primary and foreign keys, relationship types, constraints, and normalization to first, second…5 min
- 2SQL Statements and Database ObjectsDP-900 SQL basics: DDL, DML and DCL statements, the clauses of a SELECT query, joins, and database objects such as views, indexes…5 min
- 3Azure Relational Data ServicesDP-900 Azure relational services: Azure SQL Database, SQL Managed Instance, SQL Server on Azure VMs, Azure Database for…Diagram6 min
About this chapter
What this chapter covers
This chapter covers relational data: how tables, keys and relationships work, how you read and change data with SQL, and which Azure service hosts a relational database.
It carries about a fifth of the exam, and the questions mix plain concepts with short SQL statements and a choice between Azure SQL options.
How the topics fit together
The pages move from the idea of a relational database, to the language you use on it, to the Azure services that run it.
- Relational concepts and normalization covers tables, keys, relationships, constraints and why data is split into several tables.
- SQL statements and database objects covers the statement groups DDL, DML and DCL, the parts of a query, and views, indexes and stored procedures.
- Azure relational data services covers the Azure SQL family and the open source database services.
Read each SQL example slowly. The exam often shows a short statement and asks what it returns or which statement group it belongs to.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with examples and tables.
- What to remember for the exam: the facts to memorise and how questions are phrased.
- Common mistakes: the classic traps.
- Check yourself: three questions to test your understanding.
Ready for more practice?
The full Microsoft DP-900 question bank has 503 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.