Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
MySQL: Functions
How to create complete databases.Preview the first lesson free — get full access to all 5 lessons.
Advanced Provider : Kati Gordon 5 Lessons · 7m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
In this module, you will look at a few different functions, including the over partition function and lag and lead, to see how to use the window function in PostgreSQL. The window function performs a calculation across a set of table rows that are somehow related to the current row. This is the final module in this advanced SQL course and will give you an improved understanding of how to create complete databases in PostgreSQL, as well as how to add, access, and process data stored in a computer database.
What You'll Learn
- Understand the purpose and necessity of window functions in PostgreSQL
- Use the OVER PARTITION clause to perform calculations across related sets of table rows
- Apply the LAG and LEAD window functions to reference data in other rows
- Work with the FIRST VALUE and RANK functions in PostgreSQL
- Explore the use of range in PostgreSQL window functions
- Create complete databases and add, access, and process data stored in PostgreSQL
Key Takeaways
- A window function performs a calculation across a set of table rows that are somehow related to the current row.
- This module covers several functions, including the OVER PARTITION function as well as LAG and LEAD.
- This is the final module in the advanced SQL course and reinforces how to create complete databases in PostgreSQL.
- The course covers how to add, access, and process data stored in a computer database.
- Learning objectives focus on the purpose and necessity of window functions and range in PostgreSQL.
Frequently Asked Questions
What does this module cover?
It covers several functions, including the OVER PARTITION function and LAG and LEAD, to show how to use the window function in PostgreSQL. Lessons include Windows Function, Over Partition, First Value, Rank Function, and Lag & Lead.
What is a window function?
A window function performs a calculation across a set of table rows that are somehow related to the current row.
Where does this module fit in the course?
This is the final module in the advanced SQL course, and it gives an improved understanding of how to create complete databases in PostgreSQL, as well as how to add, access, and process data stored in a computer database.
What skills does this course build?
The course builds skills in MySQL, Mysql++, PostgreSQL, stored functions, table functions, and window functions.
