Using Postgres Window Functions
|
Learn how to use window functions in Postgres to analyze data efficiently. Discover how to rank records, calculate percentiles, create running totals, and more. Unlock the power of raw SQL for complex data analysis.
In this course we will show you how to wield the power behind the elusive window function. Which five movies were the highest grossing each year? Who are the highest performers in each department relative to their peers? These questions ask us to partition records into subgroups and answer questions about those groups — that’s the power of a window function.
Many programmers will reach for their favorite scripting language to solve problems like these, but window functions allow you to answer them with the speed and efficiency of the Postgres query planner.
Plus, with the power to further slice and dice this derivative information, there’s no limit to the questions you can answer with raw SQL.
If you’re interested in the Postgres client that is used in this course you can
to check it out and follow along.
Course Content
Learn What A Window Function Can Do
Rank Records with Rank and Dense Rank
Perform Weighted Ranking with Percent Rank
Define Windows Using Multiple Factors
Find Percentiles Using ntile
Create Running Totals Using Window Functions
Understand Frame Clauses
Compare Related Rows Using Lag and Lead
Compare the Outliers Using First Value and Last Value
Combine Window Functions to Answer Complex Questions
User Reviews
Be the first to review “Using Postgres Window Functions”
You must be logged in to post a review.
There are no reviews yet.