List of lectures for the course SQL, 30 quest level on JavaRush

Comparing Window Functions and Aggregate Functions: GROUP BY vs PARTITION BY
SQL SELF
30 level,0 lecture
Find out how SQL window functions ( PARTITION BY) are different from aggregate functions ( GROUP BY): differences in results, query examples, when to use each approach, pros, and common mistakes.
Open
Examples of Using Window Functions for Data Analysis
SQL SELF
30 level,1 lecture
Check out some hands-on examples of how to use SQL window functions for data analysis: ranking, cumulative sums, splitting into quantiles, and time series analysis. These techniques will help you get a deeper understanding of what analytical queries can do.
Open
Setting up a window frame with ROWS and RANGE
SQL SELF
30 level,2 lecture
Learn how to control the range of rows for window functions in SQL using the ROWS and RANGE keywords. Detailed examples, approach comparisons, and common mistakes will help you confidently use window frames for analytics tasks.
Open
Query Optimization with Window Functions
SQL SELF
30 level,3 lecture
Learn how to speed up SQL queries with window functions in PostgreSQL: indexes, filtering, partitioning, materialized views, and other optimization tricks for working with big data volumes.
Open
Common Mistakes When Using Window Functions
SQL SELF
30 level,4 lecture
Check out the most common mistakes people make when working with window functions in SQL and learn how to avoid them. This article gives you practical examples, explanations, and tips for optimizing your queries.
Open