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.

1. Course Overview

1. Course Overview

2. Querying JSON with T-SQL

1. Version Check

2. Querying JSON in Microsoft SQL Server

3. What Is JSON What About JSON in SQL Server

4. Querying JSON Documents with T-SQL

5. Converting Data into JSON with FOR JSON PATH and AUTO

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

7. Parsing and Importing JSON with OPENROWSET and OPENJSON

8. Handling Missing Properties with LAX and STRICT Mode

9. Takeaway

3. Querying XML Data with T-SQL

1. Querying XML Data in Microsoft SQL Server with T-SQL

2. What is XML How Do I Build Good XML

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

4. Getting to Know the XPath Syntax and XQuery Language

5. Providing Rowset Views with OPENXML and the nodes Method

6. Updating XML with modify and the XML Data Modification Language

7. Filtering XML Data with Contains and Exist

8. Takeaway

4. Utilizing Temporal Tables

1. Utilizing Temporal Tables

2. Understanding Temporal or System-versioned Tables

3. Creating Temporal and History Tables

4. Adding and Modifying Data in Temporal Tables

5. Selecting Data from Temporal Tables at Specific Points in Time

6. Recovering Data in a Temporal Table

7. Takeaway

5. Final Takeaway

1. Final Takeaway

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight