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
August 16, 2017
Duration
3h 37m
Table of contents
Description
Course info
Level
Intermediate
Updated
August 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
C++11 Language Features
Intermediate
3h 21m
13 Nov 2013
Ruby Fundamentals
Intermediate
3h 42m
20 Jun 2013