Microsoft · DP-800
Advanced T-SQL
DP-800 · Lesson 6 of 20 · 34:58
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-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: common table expressions and recursion, window functions with partitions and frames, correlated subqueries and EXISTS, and error handling with TRY CATCH, THROW, and XACT_ABORT. Includes three original practice questions.
Preview the topics
- A report must list the two most expensive products of each category, and exactly two per category, even when prices tie. What should the query use?
- Marketing wants the customers who have never placed an order, from the Customer and SalesOrder tables. Which pattern fits best?
- A procedure updates prices, then order totals, in one transaction. If the second update fails, nothing may remain, and the caller must still receive the error. What should the CATCH block do?