Microsoft · DP-800
Views, functions, procedures, and triggers
DP-800 · Lesson 5 of 20 · 28:40
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: views and WITH CHECK OPTION, scalar, inline, and multi-statement functions, stored procedures with transactions and error handling, and DML and DDL triggers, AFTER or INSTEAD OF. Includes three original practice questions.
Preview the topics
- The customer portal needs each customer’s orders between two dates, as a result set that other queries can join and filter. What should you create?
- The checkout must check stock, insert the order, and update inventory, all or nothing, with the customer and the cart as inputs. What fits?
- Every change to the Price column must be logged with the old and the new value, whatever application or script makes the change. What fits?