Microsoft · DP-900
Relational concepts and SQL
DP-900 · Lesson 5 of 12 · 28:19
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-900 exam (Microsoft Certified: Azure Data Fundamentals). In this lesson: tables, primary and foreign keys, normalization, SQL statements in DDL, DCL, and DML, and database objects like views, stored procedures, and indexes. Includes three original practice questions.
Preview the topics
- Product names and prices are repeated on every order row, and prices go out of sync after updates. What design process fixes this?
- A developer must give the reporting team read access to the sales table. Which statement group, and which statement, fit?
- Queries that look up orders by customer ID scan the whole table, and they are slow. What should be created?