PostgreSQL Summary Stats and Window Functions
- Offered byDataCamp
PostgreSQL Summary Stats and Window Functions at DataCamp Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
PostgreSQL Summary Stats and Window Functions at DataCamp Highlights
- Earn a certificate after completion of the course
- Learn from the industry best faculty
PostgreSQL Summary Stats and Window Functions at DataCamp Course details
Data Analysts and Scientists
Data Engineers
Business Analysts
Database Administrators
Introduction to Window Functions
Basic Syntax and Usage
Core Window Functions
Advanced Applications
Optimization and Performance
Practical Scenarios and Case Studies
In this course students 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
This course provides an in-depth understanding of how window functions work and how they can be applied to perform complex calculations over data sets without the need for subqueries or joins, thereby optimizing query performance and simplifying query structure
PostgreSQL Summary Stats and Window Functions at DataCamp Curriculum
Window functions vs GROUP BY
Numbering rows
Numbering Olympic games in ascending order
ORDER BY
Numbering Olympic games in descending order
Numbering Olympic athletes by medals earned
Future gold medalists
First athlete by name
Last country by name
Ranking
Ranking athletes by medals earned
Ranking athletes from multiple countries
Running totals of athlete medals
Maximum country medals by year
Minimum country medals by year
Frames
Number of rows in a frame
A basic pivot
Pivoting with ranking
ROLLUP and CUBE
Country-level subtotals
Other courses offered by DataCamp
Student Forum
Anything you would want to ask experts?