Lectures

Learn how to automate report creation in PostgreSQL: from writing procedures to setting up schedules with pg_cron or system schedulers. In this lecture — function examples, tips to avoid mistakes, and practical scenarios for automatic reporting.

Learn how to save the history of your analytics metrics in special log tables in PostgreSQL: capture key indicators, automate logging with functions, analyze trends, and avoid common mistakes. Real-world examples for retail, services, and finance.

In this lecture, you'll learn how to calculate the average order value for the last three months using SQL and PL/pgSQL: from a manual query to automating it with a procedure and a task scheduler. We'll look at creating tables, handling errors, and regularly logging the metric for business analytics.

In this lecture, you'll learn how to speed up analytical queries in PostgreSQL using indexes and partitioning. We'll look at examples of creating indexes, partitioned tables, as well as common mistakes and best practices for optimizing work with large amounts of data.

In this lecture, you’ll learn about the most common mistakes when writing analytical procedures in PL/pgSQL: from missing indexes and inefficient queries to calculation errors and performance issues. We’ll break down examples, ways to prevent them, and best practices to boost the reliability and speed of your analytical procedures.