Wrap-Up

Time Series Analysis in PostgreSQL

Jasmin Ludolf

Content Developer, DataCamp

What we've learned:

  • Date and time data types
  • How to work with time zones
  • How to convert between different date and time data types with TO_DATE() and EXTRACT() and more
  • Manipulate time granularity with DATE_TRUNC() and DATE_PART()
  • How to add, subtract, and aggregate time series data
  • Including with statistical aggregates!

illustration of a clock and a page of a calendar

Time Series Analysis in PostgreSQL

What we've learned:

navy illustration of a trophy

  • Partitioning
  • Window functions
  • Ranking functions
  • Running totals
  • Running averages
  • Moving averages
Time Series Analysis in PostgreSQL

Congratulations!

Time Series Analysis in PostgreSQL

Preparing Video For Download...