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

Focused View

1:02:02

87 View

01 - Introduction

01 - Storing relational data on Azure.mp4

00:54

02 - Preparing for the DP-900 exam.mp4

01:04

02 - 1. Organizing Data with the Relational Model

01 - Data table structures.mp4

03:05

02 - Choosing appropriate data types.mp4

03:17

03 - Create a relationship between tables.mp4

02:23

04 - The three types of table relationships.mp4

02:35

03 - 2. Normalizing Table Designs

01 - Create tables for each entity.mp4

03:34

02 - Create columns for each attribute.mp4

02:12

03 - Use keys to uniquely identify entities.mp4

04:30

04 - Link tables with foreign keys.mp4

01:54

04 - 3. Structured Query Language

01 - A brief history of SQL.mp4

03:41

02 - Data Manipulation Language statements.mp4

05:16

03 - Data Definition Language statements.mp4

04:24

04 - Data Control Language statements.mp4

02:14

05 - 4. Additional Database Objects

01 - Create a view of the data.mp4

03:09

02 - Add programmatic stored procedures.mp4

03:24

03 - Locate data with indexes.mp4

01:57

06 - 5. Database Services on the Azure Cloud Platform

01 - Run SQL Server with a virtual machine.mp4

02:23

02 - Benefits of Azure SQL Managed Instance.mp4

01:55

03 - Cloud-native Azure SQL Database.mp4

03:27

04 - Tailor an IoT solution with Azure SQL Edge.mp4

01:45

05 - Open-source database solutions.mp4

01:47

07 - Conclusion

01 - Next steps.mp4

01:12

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.