Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close

This online course will be of interest to database analysts, students, developers, and more. The prerequisite for the course is knowing the basics of SQL. Scroll down for more details.

Window functions (also known as analytic functions or OVER functions) are a very useful tool, especially when it comes to data aggregation. PostgreSQL's documentation describes the concept of window functions rather well:

A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of calculation that can be done with an aggregate function. But unlike regular aggregate functions, the use of a window function does not cause rows to become grouped into a single output row – the rows retain their separate identities. Behind the scenes, the window function is able to access more than just the current row of the query result.

These functions were introduced into the standard relatively recently, and that's why there are not many online courses that cover this concept. Fortunately, this course does!

This online course covers the syntax and semantics of PostgreSQL window functions and showcases how tremendously powerful they are. After you complete the course, you'll know the typical use cases of window functions, how to use OVER, ORDER BY and PARTITION BY to structure a frame, and the difference between ROWS and RANGE clauses.

RANGE OVER PostgreSQL window functions and crack complex aggregations today!

What's in It for Me?

  • 218 interactive exercises. Learn at your own pace, from anywhere and anytime. Interact with hands-on exercises for improved retention.
  • Lifetime access to the course. When you purchase the course, you'll get instant personal access to all of its content.
  • Online certification. Complete all of the exercises successfully and you'll get a certificate. You can publish the certificate on your LinkedIn profile (here's how.)
  • 30-day money-back guarantee. If you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints for the exercises. You can make use of ready-made hints for exercises, or ask questions and share insights with other members of the Vertabelo Academy community through the Discuss tab. You can also drop us a line at academy@vertabelo.com, and we'll be more than happy to answer!

What Are the Requirements?

  • Web browser
  • Internet connection
  • Knowledge of basic SQL provided in our SQL Basics in PostgreSQL course (or equivalent)

Learn How to:

  • Define the function window with PostgreSQL PARTITION BY.
  • RANK rows with window functions.
  • Create sophisticated window frames for your window functions.
  • Use the most essential analytic functions: LEAD, LAG, VALUE.
  • Create advanced statistics computed independently for various groups of rows.
  • Master all the skills you acquired in our extensive practice section.
  • Deeply understand PostgreSQL aggregate functions.

Who Should Take This Course?

  • PostgreSQL users who want to advance their querying skills
  • Developers who want to refresh what they already know
  • Beginner database analysts working with PostgreSQL
  • Students taking classes in relational databases
  • Anyone who wants to improve the use of PostgreSQL window functions
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1512

    One to Rule 'Em All

    Includes 40 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $199

    35 hours left at this price!

    72%
    off

    Reg. price
    $324

    PostgreSQL Complete Track

    Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $89

    35 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 218 exercises done

    1. Introduction

    Window functions? We'll explain what it's all about.

    More details Less
    Start now

    0% completed 0 of 8 exercises done

    2. OVER()

    Your first encounter with window functions.

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    3. OVER(PARTITION BY)

    Discover how you can define the function window with PARTITION BY

    More details Less
    Start now

    0% completed 0 of 16 exercises done

    4. Ranking Functions

    Learn how you can rank rows with window functions.

    More details Less
    Start now

    0% completed 0 of 26 exercises done

    5. Window Frame

    Get to know how to create sophisticated window frames for your window functions.

    More details Less
    Start now

    0% completed 0 of 26 exercises done

    6. Analytics functions

    Learn the most essential analytic functions.

    More details Less
    Start now

    0% completed 0 of 30 exercises done

    7. PARTITION BY ORDER BY

    Create advanced statistics computed independently for various groups of rows.

    More details Less
    Start now

    0% completed 0 of 25 exercises done

    8. Window functions - evaluation order

    Do you know when window functions are evaluated in a PostgreSQL query? Let's find out.

    More details Less
    Start now

    0% completed 0 of 23 exercises done

    9. Practice field

    Master all the skills you acquired so far in our big practice part.

    More details Less
    Start now

    0% completed 0 of 32 exercises done

    10. Final Quiz

    Test the skills you acquired in the whole course with this final quiz.

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    Reviews

    Average rating

    5/5100.0 (1)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0