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

Course details

Understanding and working with relational data is a key skill for anybody working with their organization's data platform. Relational data skills are also vital for individuals preparing for the DP-900 Azure Fundamentals exam. In this course, Adam Wilbert covers the basics of working with relational data, and touches on how these basics are implemented using the Azure data services. Go over the steps to organize data with the relational model. Learn how to normalize table designs and link tables with foreign keys. Get a thorough introduction to structured query language (SQL) and how you can use it, then explore additional database objects and the database services that you can find on the Azure Cloud Platform. This course maps to the "Describe How to Work with Relational Data on Azure" skill domain from the DP-900, Azure Data Fundamentals certification Skills Measured doc.

Concepts

0. Introduction

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

1. Organizing Data with the Relational Model

03 - Data table structures
04 - Choosing appropriate data types
05 - Create a relationship between tables
06 - The three types of table relationships

2. Normalizing Table Designs

07 - Create tables for each entity
08 - Create columns for each attribute
09 - Use keys to uniquely identify entities
10 - Link tables with foreign keys

3. Structured Query Language

11 - A brief history of SQL
12 - Data Manipulation Language statements
13 - Data Definition Language statements
14 - Data Control Language statements

4. Additional Database Objects

15 - Create a view of the data
16 - Add programmatic stored procedures
17 - Locate data with indexes

5. Database Services on the Azure Cloud Platform

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

Conclusion

23 - Next steps