Chevron Left
Back to SQL Window Functions for Analytics

Learner Reviews & Feedback for SQL Window Functions for Analytics by Coursera Project Network

4.7
stars
28 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

Filter by:

1 - 4 of 4 Reviews for SQL Window Functions for Analytics

By brindha h

•

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 ...