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.
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.