Home Categories Postgresql

PostgreSQL Summary Stats and Window Functions

Learners: 20,300

Instructor: /

Duration:

Explore the essentials of PostgreSQL Summary Stats and Window Functions▼▲

Course Feature Course Overview Course Provider

Go to class

Course Feature

Cost:

Free

Provider:

Datacamp

Certificate:

No Information

Language:

English

Start Date:

Course Overview

❗The content presented here is sourced directly from Datacamp platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 11th, 2023]

Learn about window functions and the two basic subclauses of window functions ORDER BY and PARTITION BY
Learn three practical applications of window functions: fetching values from various parts of the table ranking rows based on their values and binning rows into different tables
how to use aggregate functions like AVG() and SUM() as window functions as well as how to define frames to change the output of a window function
Learn some techniques and functions that can be used in conjunction with window functions