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.
Author Name: Xavier Morera
Author Description:
Xavier Morera is driven by one passion: taking on the challenge of understanding complex topics and sharing that knowledge with others. He’s currently focused on the transformative fields of AI, machine learning, generative AI, search, and big data. As an entrepreneur, project manager, technical author, and trainer, Xavier brings a diverse set of skills and deep expertise to every project he takes on. He holds multiple certifications with Cloudera, Microsoft, and the Scrum Alliance and has been… more

Table of Contents

• Course Overview
  2mins
• Querying JSON with T-SQL
  37mins
• Querying XML Data with T-SQL
  45mins
• Utilizing Temporal Tables
  22mins
• Final Takeaway
  2mins