Here is another popular lab from Hands-On-Lab library: Temporal Tables in SQL Server 2016 – Part 1.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.