본문으로 바로가기

강의

Time Series Analysis in PostgreSQL

중급기술 수준

업데이트됨 2025. 11.

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

무료로 강의 시작

SQLData Manipulation

4시간

14 동영상

46 연습 문제

3,800 XP

2,529

성취 증명서

수천 개 기업의 학습자들이 사랑하는

팀을 교육하시나요?

비즈니스용으로 체험해 보세요

강의 설명

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.

선수 조건

Joining Data in SQL

1

Introduction to Date and Time Data in 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!

Introduction to date and time data types

PostgreSQL data types

INSERT time INTO table

Working with time zone information

Find the time zones

Convert to a different time zone

Converting between date, time, and text

Casting dates

Converting dates

Converting date and times

2

Working with Time Series

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.

Manipulating the granularity of time series data

Temperatures by century

Busiest hour of day

Adding and subtracting date and time data

Calculate the age

Calculate arrival time in minutes

Calculating intervals

Aggregating time series data

Count the number of data per time series

Aggregating temperature data

Calculate yearly average temperature

Applying statistical aggregates to time series data

Calculating monthly temperature swings

Analyze data distribution

Sensor data analysis

3

Using Window Functions 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.

Partitioning and window functions

Partitioned table

Partition by

Top items with window functions

Find the three highest values per partition

Most active hours of day per news article

Ranking functions

Ranking cold weather

Ranking hot weather

Temperature percentile

4

Calculating Running Totals and Moving Averages

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.

Running total

Next station

Calculate a running total

Running total with lag

Running average

Single running average

Multi running average

Moving Average

Identifying trending news

Running average and moving average yearly temperature

Time Series Analysis in PostgreSQL

강의
완료

수료증 획득

LinkedIn 프로필, 이력서 또는 CV에 이 인증서를 추가하세요
소셜 미디어와 성과 평가에서 공유하세요지금 등록

19백만 명 이상의 학습자와 함께 Time Series Analysis in PostgreSQL을(를) 시작하세요!

DataCamp for Mobile을 통해 데이터 분석 능력을 향상시키세요.

모바일 강좌와 매일 5분 코딩 챌린지를 통해 이동 중에도 학습 효과를 높이세요.