Go beyond the basics and become a SQL master. Learn modern SQL features that let you write more complex and effective queries.Start learning
21 free interactive coding challenges
This learning path is for people who know some SQL and want to learn the language’s more advanced features and latest trends. Scroll down for details.
You want to improve your SQL skills. You already know the basics; now it's time to go to the next level. The Advanced SQL track will teach you the most up-to-date, efficient, and time-saving querying techniques.
Discover Window Functions that enable you to use aggregate functions without collapsing rows. Window functions (also called analytical functions or OVER() functions) let you rank data, compute running totals, and create reports with day-to-day or month-to-month deltas. Common Table Expressions make your code better organized and simpler to read. Recursive Queries allow you to process hierarchical data like trees and graphs using SQL. And advanced GROUP BY clauses like ROLLUP, CUBE, and GROUPING SETS add power and flexibility to your queries.
In other words, the Advanced SQL learning path will help you become a qualified programmer, data analyst, or DBA with fully modern skills.
A window function is an advanced SQL concept that enables you to maximize efficiency and minimize the complexity of queries that analyze partitions (windows), subgroups or sections of a data set. In this online course, you'll learn how to build complex aggregations with PostgreSQL window functions: OVER, RANK, PARTITION BY. Note: This is the only online course on PostgreSQL window functions you can find on the Internet.
In this online course, you will master PostgreSQL recursive queries, also known as WITH clauses, and common table expressions (CTEs).