Phân tích chuỗi thời gian trong PostgreSQL

In this chapter, you’ll be introduced to date and time data types. You’ll learn how to convert text and numeric data to date and time format—and how to convert the other way around too!

It’s time to get granular. In this chapter, you’ll learn how to set the granularity of your time series reports. You’ll then get to grips with adding, subtracting, and aggregating as you discover how to analyze time series data.

In this chapter, you’ll work with window functions. You'll begin learning about partitions and partitioning and how they work with window functions. You'll be able to find the top items when ranking your data.

In the final chapter, you’ll level up your skills by calculating the running total, running average, and even moving average to enhance your time series analysis.