Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

PostgreSQL 9: Time and Temporal Data

via Pluralsight

Overview

In every database you will find temporal data. This course teaches you how to deal with time, time zones, and more complex temporal data in PostgreSQL.

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.

Syllabus

  • Course Overview 1min
  • Getting Started with Times, Dates, and Intervals 46mins
  • Working with Ranges, Current Time, and Sequences 25mins
  • Dealing with Time Zones 26mins
  • Keeping Track of Changing Entities 47mins
  • Querying and Maintaining Temporal Data 33mins
  • Interacting with Client Applications 21mins
  • Managing Time Related Configuration 13mins

Taught by

Alex Korban

Reviews

Start your review of PostgreSQL 9: Time and Temporal Data

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.