Introduction to SQL Window Functions
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.
Buy Now Free
- Level Intermediate
- Duration 2 hours
- Course by Coursera
-
Offered by
About
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.Modules
Your Learning Journey
-
3
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Introduction to SQL Window Functions
1
Labs
- Introduction to SQL Window Functions
3
Readings
- Project Overview
- SQL files and data sets for the project
- Links to PostgreSQL Window Functions Documentation
Auto Summary
Dive into the dynamic world of SQL with Coursera's "Introduction to SQL Window Functions." This intermediate-level, hands-on course focuses on mastering SQL window functions like ROW_NUMBER(), LEAD(), LAG(), and FIRST_VALUE() to query and manipulate data. Over 2.5 hours, you'll actively engage with the project-db database, enhancing your data retrieval skills. Perfect for IT and Computer Science enthusiasts, this free course offers practical, project-based learning for those looking to advance their SQL expertise.
Arimoro Olayinka Imisioluwa