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
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
Course Overview
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 19m
Feb 2, 2018
More courses by Alex Korban
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Alex Korban. Welcome to my course, PostgreSQL: Time and Temporal Data. I'm a freelance developer and author and I have been working with Postgres for the last decade focusing primarily on time series and geospatial data. In almost every database you will find time values and temporal data. Time is a fascinating subject, but dealing with time calculations, time zones, and temporal relationships gets very complicated quickly. In this course you will learn a structured approach for handling the time dimension of your data. First, you will learn the rich repertoire of date and time related types and functions provided by PostgreSQL. Next, you will learn how to work with time zones and daylight savings time. Then you will find out how to structure your tables according to the kind of time related questions you need to answer. Spoiler, there is more than one type of time. After that you will learn how to build SQL statements to effectively create and modify temporal data. Finally, you will find out what to consider when interfacing with client applications. When you're finished you will have a good understanding of time representations and temporal data and a solid foundation for managing temporal data effectively. Please be aware that this course requires familiarity with PostgreSQL. I hope you will join me on this journey to learn about handling temporal data in Postgres with the PostgreSQL Time and Temporal Data course.