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

by Xavier Morera

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.

What you'll learn

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

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. He has spent a great deal of his career working on cutting-edge projects with a primary focus on .NET, Solr, and Hadoop among a few other interesting technologies. Throughout multiple projects, he has acquired skills to deal... more

Ready to upskill? Get started