Microsoft · DP-800
Patterns, fuzzy matching, and graphs
DP-800 · Lesson 7 of 20 · 41:24
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: regular expression functions (REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, and more), fuzzy string matching with EDIT_DISTANCE and Jaro-Winkler, and graph queries with MATCH and SHORTEST_PATH. Includes three original practice questions.
Preview the topics
- A check constraint must reject any product code that is not two uppercase letters, a dash, and four digits. Which function fits?
- Support types a name heard on the phone, like Jon Smyth, and wants a score from 0 to 100 to rank the candidate customers. Which function fits?
- The recommendation team wants the products bought by the people that a customer knows, through the Knows and Bought edge tables. What should the query use?