Microsoft · DP-800
Database projects and testing
DP-800 · Lesson 13 of 20 · 1:33: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: SQL database projects and the SDK-style format, source control and reference data in post-deployment scripts, branches, pull requests, and conflicts, and unit, negative, and integration tests in the pipeline. Includes three original practice questions.
Preview the topics
- The OrderStatuses lookup table must hold the same five rows in every environment, and deployments run several times a week. How should the team manage it?
- Two branches merged in Git without any conflict: one renamed the Email column of Customers, and the other added a procedure that still selects Email. What catches the problem before it reaches main?
- A procedure must raise an error when someone cancels an order that has already shipped. Which test proves it?