Wrap-Up
1. Wrap-Up
Congratulations! We have finished this course on time series analysis in PostgreSQL.2. What we've learned:
We've gone through quite a bit of information. We started off by learning about date and time data types, how to work with time zones, and how to convert between different data types with various functions including TO_DATE, EXTRACT and many more. We learned about time granularity and how to manipulate it with functions. How to add, subtract, and aggregate time series data - even with statistical aggregates!3. What we've learned:
It doesn't stop there. We learned about partitioning, window functions, and ranking functions. And enhanced our time series analysis even further by calculating running totals, running averages, and moving averages. We're ready to go out in the world and do some time series analysis!4. Congratulations!
Well done!Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.