You can find out here of “Advanced Relational Databases (PostgreSQL)” course.
Themes are below.
- GROUPING SETS
- Ordered-Set Aggregate Functions
- Hypothetical-Set Aggregate Functions
- Window Function
- Frame Rows / Range / Groups
- User Defined aggregators
- User Hypothetical aggregators
- Parallel workers
Please if you have some comments / questions or remarks , just let me know about it.