Querying JSON, XML, and Temporal Data with T-SQL

The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables.
Course info
Level
Advanced
Updated
Oct 23, 2019
Duration
1h 50m
Table of contents
Description
Course info
Level
Advanced
Updated
Oct 23, 2019
Duration
1h 50m
Description

Querying structured data is the most common scenario with SQL Server. However, there are cases where the schema is not known up front or more flexibility is needed. Additionally, sometimes it is required to know the value of a particular field at a specific point in time. In this course, Querying JSON, XML, and Temporal Data with T-SQL, you’ll gain the ability to use JSON and XML to store, modify, and query semi-structured data. First, you’ll learn how to work with JSON in SQL Server. Next, you’ll discover how to work with XML. Finally, you’ll explore how to retrieve values at any point in time with temporal tables. When you’re finished with this course, you’ll have the skills and knowledge of JSON, XML, and temporal tables needed to work with semi-structured data and historic data in SQL Server. Software required: Microsoft SQL Server.

About the author
About the author

Xavier is very passionate about teaching, helping others understand search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP.

More from the author
T-SQL Data Manipulation Playbook
Intermediate
2h 54m
Sep 27, 2019
More courses by Xavier Morera
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone! My name is Xavier Morera, and welcome to my course, Querying JSON, XML, and Temporal Data with T-SQL. SQL is the lingua franca of working with data, data being something that is extremely valuable in this day of age of information explosion. Thus, knowing SQL is a very valuable skill, with T-SQL being what you use with Microsoft SQL Server. And data in SQL Server is commonly stored neatly organized in rows and columns. However, as the amount of data keeps growing, a new need came to be, namely, the need to store semi-structured data. This capability was initially fulfilled by XML and later on expanded with JSON. SQL Server supports storing, querying, and handling semi-structured data using these two very popular formats, XML and JSON. Additionally, there is a growing need to query or recover data at an earlier point in time by using temporal tables. And that's why we're here. Some of the major topics that we will cover include how to query and return JSON data, including how to use the available JSON functions in SQL Server, how to store and import JSON documents in SQL Server, how to query and work with XML data in SQL Server, understanding how XML data is stored and handled, and how to work with temporal tables, which let you automatically keep a version of data in your tables, letting you query for the state of the data at specific points in time. By the end of this course, you will know and understand how to work with semi-structured data in JSON or XML, as well as using temporal tables to inspect data at any point in time and to recover to last good, known, real versions. Before beginning the course, you should be familiar with the basic mechanics of SQL. This course is not a deep dive on SQL. Instead, it compliments your existing SQL knowledge to help you work with semi-structured data and historic table data. I hope you will join me on this journey to improve your SQL querying skills with the Querying JSON, XML, and Temporal Data with T-SQL course, at Pluralsight.