PostgreSQL 9: Time and Temporal Data
In almost every database you will find time values and temporal data. This course will teach you how to deal with time, time zones, and more complex temporal data in PostgreSQL effectively.
What you'll learn
When your data has a temporal aspect, dealing with time, time zones, and time-based relationships gets very complicated quickly. In this course, PostgreSQL 9: Time and Temporal Data, you'll learn how to handle the time dimension of your data in a structured way. First, you'll learn about the date and time related types, and functions built into PostgreSQL. Next, you'll explore how to work with time zones. Finally, you'll discover how to design temporal tables, and how to query and maintain data in them. When you’re finished with this course, you'll have the skills and understanding of temporal data and time representations needed to manage temporal data effectively. Software required: PostgreSQL.
Table of contents
- Overview 3m
- Problems Solved with Temporal Data 7m
- Avoiding Temporal Data 7m
- Types of Time and Time-varying Tables 5m
- Constraints for Different Types of Time 5m
- Transaction Time Tables 5m
- Foreign Key Constraints 7m
- Valid Time Tables and Bitemporal Tables 4m
- SQL:2011 Temporal Features Overview 4m
- Summary 1m
About the author
Alex Korban is an author and independent consultant with an interest in functional programming, databases, and geospatial applications. He's written several books about C++11 and C++14. Alex co-founded a company to visualize geospatial data for the heavy construction industry in order to improve safety and productivity when building highways, tunnels, and other infrastructure. Prior to that he worked on a wide range of software, such as early mobile applications, a flight simulator, and GPS-base... more