Skip to main content
HomeSQL

course

PostgreSQL Summary Stats and Window Functions

Intermediate
4.3+
82 reviews
Updated 12/2024
Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!
Start course for free

Included for FreePremium or Teams

SQLSoftware Development4 hours12 videos44 exercises3,550 XP87,328Statement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Have you ever wondered how data professionals use SQL to solve real-world business problems, like generating rankings, calculating moving averages and running totals, deduplicating data, or performing time intelligence? If you already know how to select, filter, order, join and group data with SQL, this course is your next step. By the end, you will be writing queries like a pro! You will learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon! Using flights data, you will discover how simple it is to use window functions, and how flexible and efficient they are.

Prerequisites

Data Manipulation in SQL
1

Introduction to window functions

Start Chapter
2

Fetching, ranking, and paging

Start Chapter
3

Aggregate window functions and frames

Start Chapter
4

Beyond window functions

Start Chapter
PostgreSQL Summary Stats and Window Functions
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Don’t just take our word for it

*4.3
from 82 reviews
61%
22%
12%
5%
0%
  • SEYED N.
    29 days

    Everythings very smooth and you can practice as you go.

  • Karthika M.
    about 1 month

    Wonderful course and easy to understand and remember the dataset

  • Jose A.
    about 2 months

    Awesome

  • Tatiana U.
    2 months

    I like it.

  • Mona S.
    3 months

    Best course in the SQL Fundamentals track so far! I really appreciated Michel going through the time to properly explain what the code was doing, and the multiple choice questions were also very helpful in checking understanding too!

"Everythings very smooth and you can practice as you go."

SEYED N.

"Wonderful course and easy to understand and remember the dataset"

Karthika M.

"Awesome"

Jose A.

Join over 15 million learners and start PostgreSQL Summary Stats and Window Functions today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.