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