Azure Data Fundamentals (DP-900) Cert Prep: 2 Working with Relational Data on Azure

Introduction

• Storing relational data on Azure
• Preparing for the DP-900 exam

1. Organizing Data with the Relational Model

• Data table structures
• Choosing appropriate data types
• Create a relationship between tables
• The three types of table relationships

2. Normalizing Table Designs

• Create tables for each entity
• Create columns for each attribute
• Use keys to uniquely identify entities
• Link tables with foreign keys

3. Structured Query Language

• A brief history of SQL
• Data Manipulation Language statements
• Data Definition Language statements
• Data Control Language statements

4. Additional Database Objects

• Create a view of the data
• Add programmatic stored procedures
• Locate data with indexes

5. Database Services on the Azure Cloud Platform

• Run SQL Server with a virtual machine
• Benefits of Azure SQL Managed Instance
• Cloud-native Azure SQL Database
• Tailor an IoT solution with Azure SQL Edge
• Open-source database solutions

Conclusion

• Next steps