Master the SQL SELECT statement part 12: Temporal Tables and Queries
This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!
This video we will cover Temporal tables. Temporal tables store current data plus all changes made do the data over time in a history table. The video will explain how to create a temporal table, then demonstrate how to query the data. Temporal queries allow us to add FOR SYSTEM_TIME to the FROM clause to query our data at a point in time, or over a span of time without the need to perform date comparisons or access the history table directly.
The SQL code is available here: https://github.com/mafudge/learn-data...
If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. • Learn Databases Walkthrough
This video is part of the textbook Applied Database Management https://applieddb.com
Here's the entire playlist: • Applied Database Management with SQL
![Complete online adult ballet center [30 minutes]](https://images.videosashka.com/watch/IgZEpRMQ-cE)
