JSON Tutorial - PART 2 | How to Work with JSON in SQL Server | Parse JSON in SQL Server

This is the PART 2 of how to work with JSON data in SQL Server where I talk about parsing JSON into a table using OPENJSON and also creating a JSON object from a database table using FOR JSON clause. This JSON tutorial also includes live demo where I demonstrate different strategies that we can employ while parsing out the JSON. This video is for database developers and database administrators who are new to JSON and its use in SQL Server. It will also help aspiring data engineers get familiar with JSON and many of its use cases.

Since JSON is the most popular data exchange format these days and is widely used in big data applications, It is no surprise that it has also found its place in the relational database systems like SQL Server. Microsoft added its support in SQL Server 2016 and provided built in features like OPENJSON and FOR JSON to help parse complex nested JSONs or convert a dataset into JSON. Hence it is important for SQL Server professionals to learn JSON skills and be able to apply them when needed.

********* Video Contents *********
0:00 - Intro
0:18 - Recap of Part 1
1:55 - Today's topic
2:46 - Demo
17:02 - Final Thoughts

#json #jsontutorial #parsejson #readjson #openjson #sqlserver

[ravi]

Can we fetch only selective columns in json format as a new column, and rest other column will remain same