Lectures

Get to know analytical functions in SQL and PL/pgSQL: why you need them, what problems they solve, and how they help automate analytics right on the database side. Learn how to analyze key metrics, build reports and trends, compare periods, and use analytics in real business scenarios.

Window functions in SQL let you do analytical calculations over rows without merging them into one, but by adding new values to each row. In this lecture, you'll learn how to use ROW_NUMBER, RANK, DENSE_RANK, and other window functions for ranking, numbering, and analyzing data across groups and orders.

In this lecture, you'll learn how to use SQL aggregate functions (COUNT, SUM, AVG) to quickly build basic analytical reports: count the number of orders, sum up revenue, find averages, and analyze sales by categories, regions, and customers.

In this lecture, you'll learn how to create and use temporary tables in PostgreSQL for analytics, handling intermediate results, speeding up complex queries, and isolating data within a session or transaction. Examples, syntax, practical cases, and common mistakes — everything you need for working effectively with temporary tables.

In this lecture, you'll learn how to create analytical reports in PostgreSQL using procedures and functions in PL/pgSQL: from simple aggregates to complex reports with temp tables, filtering, and formatting. Real-world examples and tips will help you automate analytics and make working with data way easier.