Time Series Analysis in PostgreSQL

Intermediate

Updated 12/2024

Learn how to use PostgreSQL to handle time series analysis effectively and apply these techniques to real-world data.

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Course Description

This course teaches you how to leverage PostgreSQL to handle date and time data. You'll learn about functions and calls to help you parse through and manipulate this data, make calculations, and use window functions.

Work with time series data

You’ll learn about various date and time data types and how to convert between them, manipulate their granularity, and perform calculations, including aggregations, partitioning, and running averages. These insights will help you add value to existing time series data.

Apply time series analysis to real-world data

You'll apply these techniques to real-world data to analyze temperatures, look at train schedules, and review how the popularity of news articles can change over time.

Prerequisites

Joining Data in SQL

Introduction to Date and Time Data in PostgreSQL

Start Chapter

Introduction to date and time data types

Course Description

Work with time series data

Apply time series analysis to real-world data

Earn Statement of Accomplishment

Join over .css-nklxlk{color:var(--wf-brand--main, #03EF62);}15 million learners and start Time Series Analysis in PostgreSQL today!

Create Your Free Account

Join over 15 million learners and start Time Series Analysis in PostgreSQL today!