PostgreSQL: 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.
Course info
Level
Intermediate
Updated
Aug 16, 2017
Duration
3h 37m
Table of contents
Course Overview
Getting Started with Times, Dates, and Intervals
Working with Ranges, Current Time, and Sequences
Dealing with Time Zones
Keeping Track of Changing Entities
Querying and Maintaining Temporal Data
Interacting with Client Applications
Managing Time Related Configuration
Description
Course info
Level
Intermediate
Updated
Aug 16, 2017
Duration
3h 37m
Description

When your data has a temporal aspect, dealing with time, time zones, and time-based relationships gets very complicated quickly. In this course, PostgreSQL: 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.

About the author
About the author

Alex Korban is an author and consultant with an interest in functional programming, databases and geospatial applications. He co-founded a company to visualize geospatial data and wrote several books.

More from the author
Building Real World Applications with Elm
Intermediate
2h 18m
2 Feb 2018
C++11 Language Features
Intermediate
3h 21m
13 Nov 2013