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

Focused View

Xavier Morera

1:49:59

26 View

01 - Course Overview

01 - Course Overview.mp4

02:26

02 - Querying JSON with T-SQL

02 - Querying JSON in Microsoft SQL Server.mp4

03:51

03 - What Is JSON What About JSON in SQL Server.mp4

06:10

04 - Querying JSON Documents with T-SQL.mp4

04:46

05 - Converting Data into JSON with FOR JSON PATH and AUTO.mp4

05:59

06 - Using SQL JSON Functions - JSON VALUE, JSON QUERY, JSON MODIFY, and IS JSON.mp4

03:12

07 - Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4

06:48

08 - Handling Missing Properties with LAX and STRICT Mode.mp4

05:18

09 - Takeaway.mp4

01:30

03 - Querying XML Data with T-SQL

10 - Querying XML Data in Microsoft SQL Server with T-SQL.mp4

01:52

11 - What is XML How Do I Build Good XML.mp4

06:18

12 - Selecting Data from XML - OPENXML and the query and value Methods.mp4

11:11

13 - Getting to Know the XPath Syntax and XQuery Language.mp4

08:38

14 - Providing Rowset Views with OPENXML and the nodes Method.mp4

07:25

15 - Updating XML with modify and the XML Data Modification Language.mp4

04:24

16 - Filtering XML Data with Contains and Exist.mp4

03:57

17 - Takeaway.mp4

01:30

04 - Utilizing Temporal Tables

18 - Utilizing Temporal Tables.mp4

00:52

19 - Understanding Temporal or System-versioned Tables.mp4

04:24

20 - Creating Temporal and History Tables.mp4

02:35

21 - Adding and Modifying Data in Temporal Tables.mp4

04:58

22 - Selecting Data from Temporal Tables at Specific Points in Time.mp4

04:50

23 - Recovering Data in a Temporal Table.mp4

03:07

24 - Takeaway.mp4

01:17

05 - Final Takeaway

25 - Final Takeaway.mp4

02:41

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Database Programming

Xavier Morera

Instructor's Courses

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 with complex enterprise software solutions, working with companies that range from startups to Microsoft. Xavier also worked as a worldwide v-trainer/evangelist for Microsoft.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.