Temporal Tables in SQL Server 2016 – Part 1

Home/Administration, SQL Server/Temporal Tables in SQL Server 2016 – Part 1

Temporal Tables in SQL Server 2016 – Part 1

$15.00 $4.00

SQL Server 2016 introduces a new feature called Temporal tables/ System versioned temporal tables which helps us in performing point in time analysis, data auditing and repairing Row-Level Data Corruption. In this lab, we will learn about temporal tables. In the first exercise, we will learn to create and query the system versioned temporal tables. In the second exercise, we will learn to change the schema of the temporal tables. In third exercise, we will learn the internals of temporal table data retrieval process.

Exercise 1: Creating and Querying System Versioned Temporal Tables
Exercise 2: Changing Schema of Temporal Table
Exercise 3: Insights in Temporal Table Data Retrieval

Categories: ,

Description

SQL Server 2016 introduces a new feature called Temporal tables/ System versioned temporal tables which helps us in performing point in time analysis, data auditing and repairing Row-Level Data Corruption. In this lab, we will learn about temporal tables. In the first exercise, we will learn to create and query the system versioned temporal tables. In the second exercise, we will learn to change the schema of the temporal tables. In third exercise, we will learn the internals of temporal table data retrieval process.

Exercise 1: Creating and Querying System Versioned Temporal Tables
Exercise 2: Changing Schema of Temporal Table
Exercise 3: Insights in Temporal Table Data Retrieval

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.