Microsoft · DP-800
JSON in SQL
DP-800 · Lesson 4 of 20 · 22:29
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: the native json data type, validation with JSON_PATH_EXISTS and ISJSON, lax and strict modes, computed columns and JSON indexes, JSON_VALUE, JSON_QUERY, OPENJSON, and JSON_CONTAINS, and building JSON with JSON_OBJECT, JSON_ARRAY, JSON_ARRAYAGG, and FOR JSON. Includes three original practice questions.
Preview the topics
- Product attributes live in a native json column, and frequent queries filter on the season rating with JSON_VALUE. The team wants an index, without adding any column. What fits?
- Each order row holds its cart items as a JSON array, and a report needs one row per item, with typed product IDs and quantities, joined with the products table. What should the query use?
- The partner API needs one row per category, with all of its products as an array of objects, each with an id, a name, and a price. What should the query use?