AI Academy
Promotion
CodeGym University
Learning
Courses
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
My Progress
Courses
University
Quest Map
Lessons
SQL
SQL
Level 60
Automatic Scheduled Report Generation
SQL SELF
Level 60,
Lesson 0
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.
Logging Analytical Data into Separate Tables
SQL SELF
Level 60,
Lesson 1
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.
Example: Calculating the Average Order Value for the Last 3 Months
SQL SELF
Level 60,
Lesson 2
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.
Optimizing Analytical Functions for Big Data: Indexing and Partitioning
SQL SELF
Level 60,
Lesson 3
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.
Analyzing Common Mistakes When Creating Analytical Procedures
SQL SELF
Level 60,
Lesson 4
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.
Please enable JavaScript to continue using this application.