PostgreSQL Advanced: Scalability and Sharding (Citus) Training Course

PostgreSQL is a sophisticated open-source relational database system that serves as a robust foundation for AI-powered systems and data intelligence applications.

This instructor-led, live training (available online or onsite) is designed for intermediate-level database professionals and developers aiming to integrate, manage, and optimize AI capabilities directly within PostgreSQL.

Upon completion of this training, participants will be able to:

• Install and configure PostgreSQL extensions specifically for AI workloads.
• Implement embeddings and perform similarity searches using pgvector.
• Connect both open-source and proprietary Large Language Models (LLMs) with PostgreSQL to gain real-time insights.
• Optimize PostgreSQL performance for handling AI-driven queries and workflows.

Course Format

• Interactive lectures and group discussions.
• Extensive exercises and practical practice sessions.
• Hands-on implementation in a live laboratory environment.

Customization Options

• For customized training requests, please contact us to arrange the details.

PostgreSQL is a robust, open-source relational database that can be augmented with AI capabilities to deliver enterprise data intelligence, predictive analytics, and process automation.

This instructor-led live training (available online or onsite) is designed for intermediate to advanced data engineers, DBAs, and solution architects aiming to design, implement, and govern enterprise-grade AI systems powered by PostgreSQL.

Upon completing this program, participants will acquire the expertise to:

• Seamlessly integrate AI models and vector search capabilities directly into PostgreSQL.
• Deploy AI-optimized architectures tailored for high-volume enterprise workloads.
• Establish robust governance, auditing, and compliance frameworks for AI data pipelines.
• Safely leverage both open-source and proprietary AI frameworks within PostgreSQL environments.

Course Format

• Interactive lectures combined with enterprise-focused case studies.
• Practical exercises and real-world laboratory sessions.
• Hands-on implementation in a live PostgreSQL environment.

Customization Options

• For customized training requests, please contact us to arrange a tailored solution.

This instructor-led live training in Serbia (online or on-site) is intended for database administrators and cloud architects who aim to migrate Oracle databases to Azure SQL or PostgreSQL.

By the end of this training, participants will be able to:

• Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
• Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
• Perform post-migration steps to test, optimize, update, and maintain a migrated database.

This course explores the core principles of PostgreSQL server extensions and libraries designed to embed artificial intelligence capabilities within database systems. Key topics include semantic search and similarity matching using embedding vectors, Text-to-SQL query generation, and Retrieval-Augmented Generation (RAG). Participants will acquire the skills to install and configure PgVector and PgAI, generate and import vector embeddings, construct vector indexes, and implement semantic search and RAG workflows. Additionally, the curriculum covers building Text-to-SQL applications with LangChain using Python or JavaScript. Through live demonstrations and practical exercises, learners will solidify both theoretical knowledge and technical proficiency.

This practical course emphasizes the hands-on techniques for tuning PostgreSQL performance. Participants will gain the skills to analyze query execution, optimize indexing strategies, fine-tune memory and system parameters, and effectively monitor workloads. Through real-world scenarios and live exercises, the course demonstrates how to identify and resolve bottlenecks at both the database and system levels.

This training is intended for Database Administrators and Architects seeking to master the fundamentals of PostgreSQL.

Participants will gain knowledge on PostgreSQL's architecture, installation procedures, design principles, as well as methods for performing database backup and recovery in PostgreSQL.

This program is tailored for Database Administrators and Architects seeking to master the tools and techniques for implementing backups, high availability, and database security within PostgreSQL.
Participants will also acquire the skills to identify slow queries, monitor database performance, and optimize PostgreSQL for enhanced speed and efficiency.

This course is tailored for Database Administrators and Architects seeking to master Streaming Replication in PostgreSQL. Participants will learn how to leverage pgpool-II to enable automatic failovers and establish a robust, highly available PostgreSQL Database Cluster.

This training program is tailored for Database Administrators and Architects aiming to optimize PostgreSQL databases for peak performance. Participants will learn techniques to log slow-running workloads and identify potential bottlenecks within queries. Additionally, the course covers the critical parameters that require tuning to achieve optimal system efficiency.

In this instructor-led, live training session Serbia (onsite or remote), participants will gain insight into the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication. Learning is facilitated through a series of hands-on, live-lab exercises that cover setup, configuration, testing, deployment, and troubleshooting.

By the conclusion of this training, participants will be able to:

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

PostgresAI is a platform that enables database teams to clone, test, and optimize PostgreSQL environments using AI-driven automation.

This instructor-led, live training (online or onsite) is aimed at advanced-level DevOps professionals and database engineers who wish to implement PostgresAI at enterprise scale for database monitoring, cloning, and AI-driven optimization.

By the end of this training, participants will be able to:

• Deploy and configure PostgresAI in enterprise environments.
• Integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Leverage AI-driven insights for query optimization and performance tuning.
• Implement governance, auditing, and data privacy controls for cloned environments.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This course explores programmatic interaction with PostgreSQL databases. Participants will master the techniques, syntaxes, and structures required to build high-quality applications backed by PostgreSQL. The training also delves into SQL Tuning, highlighting best practices for writing efficient SQL code.

The target audience comprises developers seeking to utilize or extend PostgreSQL, as well as database architects.

This program offers comprehensive insights into replication, high availability, and cluster management within the PostgreSQL ecosystem. Attendees will learn to construct and oversee multi-node setups, set up automated failover mechanisms, and investigate load balancing and connection pooling strategies. The curriculum features hands-on replication laboratories and recovery simulations.

This instructor-led, live training in Serbia (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications.

By the end of this training, participants will be able to:

• Install and configure PostgreSQL 13.
• Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
• Learn how to configure Postgres database tables and schemas.
• Learn how to perform data manipulations and queries.
• Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.