Here is another popular lab from Hands-On-Lab library: JSON Support in SQL Server 2016.
JSON is a short form of Java Script Object Notation which is a simple and lightweight format for exchanging data between multiple sources. The main advantage of using JSON is, it is easy to read. SQL Server 2016 empowers us to work with JSON text. In this lab, we will learn to work with JSON text format and its supporting functions. In the first exercise, we will learn to convert relational composition to JSON text using FOR JSON clause. In the second exercise, we will learn to query the JSON text using JSON_QUERY, JSON_VALUE and JSON_MODIFY functions. In the third and final exercise, we will learn about OPENJSON function to retrieve data into relational format from JSON query.
Exercise 1: Relational composition to JSON format
Exercise 2: Querying JSON text
Exercise 3: OPENJSON function
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.