Back to SQL Window Functions for Analytics
Learner Reviews & Feedback for SQL Window Functions for Analytics by Coursera Project Network
33 ratings
About the Course
Welcome to this project-based course SQL Window Functions for Analytics. This is a hands-on project that will help SQL users use window functions extensively for database insights. In this project, you will learn how to explore and query the project-db database extensively. We will start this hands-on project by retrieving the data in the table in the database.
By the end of this 2-hour-and-a-half-long project, you will be able to use different window functions to retrieve the desired result from a database. In this project, you will learn how to use SQL window functions like ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), and LAST_VALUE() to manipulate data in the project-db database. Also, we will consider how to use aggregate window functions. These window functions will be used together with the OVER() clause to query this database. By extension, we will use grouping functions like GROUPING SETS(), ROLLUP(), and CUBE() to retrieve sublevel and grand totals.
Top reviews
MC
Jul 23, 2024
good hands-on experience on all sort of window functions
BB
Dec 30, 2023
All topics are explained in detail with clear examples
Filter by:
1 - 5 of 5 Reviews for SQL Window Functions for Analytics
By Manoj K C
•Jul 24, 2024
good hands-on experience on all sort of window functions
By Brindha
•Dec 31, 2023
All topics are explained in detail with clear examples
By DANIEL L
•Oct 4, 2021
Very useful!
By Muhammed E B
•Mar 29, 2022
Good
By Victor F P
•Jan 12, 2023
Waste of money and time ...