CodeGym
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
  • 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.
    Available
  • 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.
    Available
  • 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.
    Available
  • 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.
    Available
  • 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.
    Available
Learn
  • Registration
  • Java Course
  • Help with Tasks
  • Pricing
  • Java Syntax
Community
  • Users
  • Articles
  • Forum
  • Chat
  • Success Stories
  • Activity
  • Affiliate Program
Company
  • About us
  • Contacts
  • Reviews
  • Press Room
  • CodeGym for EDU
  • FAQ
  • Support
CodeGym CodeGym is an online course for learning Java programming from scratch. This course is a perfect way to master Java for beginners. It contains 1200+ tasks with instant verification and an essential scope of Java fundamentals theory. To help you succeed in education, we’ve implemented a set of motivational features: quizzes, coding projects, content about efficient learning, and a Java developer’s career.
Follow us
Interface language
English
Deutsch Español हिन्दी Français Português Polski বাংলা 简体中文 मराठी தமிழ் Italiano Bahasa Indonesia 繁體中文 Nederlands 日本語 한국어 Bulgarian Danish Hungarian Basa Jawa Malay Norwegian Romanian Swedish Telugu Thai Українська Filipino Turkish Azərbaycan Русский Vietnamese
Programmers Are Made, Not Born © 2026 CodeGym
MastercardVisa
Programmers Are Made, Not Born © 2026 CodeGym