Introduction to SQL Window Functions

Go to class
Write Review

Introduction to SQL Window Functions provided by Coursera is a comprehensive online course, which lasts for 2 hours worth of material. Introduction to SQL Window Functions is taught by Arimoro Olayinka Imisioluwa. Upon completion of the course, you can receive an e-certificate from Coursera. The course is taught in Englishand is Paid Course. Visit the course page at Coursera for detailed price information.

Overview
  • Welcome to this project-based course Introduction to SQL Window Functions. This is a hands-on project that introduces SQL users to the world of window functions. 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(), LEAD(), LAG(), and FIRST_VALUE() to manipulate data in the project-db database. These window functions will be used together with the OVER() clause to query this database.