PostgreSQL Advanced: Scalability and Sharding (Citus) Training Course

Postgres is a sophisticated open-source relational database that serves as an ideal foundation for building AI-powered systems and data intelligence applications.

This instructor-led live training, available both online and onsite, targets intermediate-level database professionals and developers aiming to seamlessly integrate, manage, and optimize AI capabilities directly within Postgres.

Upon completing this course, participants will be equipped to:

• Configure and set up Postgres extensions tailored for AI workloads.
• Leverage pgvector to implement embeddings and perform similarity searches.
• Integrate both open-source and proprietary LLMs with Postgres to derive real-time insights.
• Optimize Postgres performance for AI-driven queries and operational workflows.

Course Format

• Interactive lectures paired with discussions.
• Extensive hands-on exercises and practical practice.
• Real-world implementation within a live-lab environment.

Course Customization Options

• For tailored training needs, please reach out to us to arrange a customized session.

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

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

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

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

Format of the Course

• Interactive lectures combined with enterprise case discussions.
• Practical exercises and real-world labs.
• Hands-on implementation in a live PostgreSQL environment.

Course Customization Options

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

This course explores the foundational aspects of PostgreSQL server extensions and libraries designed to incorporate artificial intelligence capabilities into database systems. Key topics include similarity and semantic search using embedding vectors, Text-to-SQL querying, and Retrieval-Augmented Generation (RAG). Participants will learn how to install PgVector and PgAI, generate and load vector embeddings, build vector indexes, implement semantic search and RAG workflows, and develop Text-to-SQL applications utilizing LangChain with Python or JavaScript. Through demonstrations and hands-on exercises, the core concepts and practical skills are reinforced.

This practical course emphasizes the hands-on techniques for tuning PostgreSQL performance. Participants will gain skills in analyzing query execution, optimizing indexing strategies, configuring memory and system settings, and effectively monitoring workloads. Through real-world scenarios and live exercises, attendees will learn to identify and resolve bottlenecks at both the database and system levels.

Effectively managing and developing PostgreSQL databases demands a profound understanding of performance tuning, data replication strategies, and connection pooling techniques. This comprehensive course explores server administration, core SQL principles, client-side connectivity, server-side scripting, and internal database mechanics. Through practical, hands-on exercises, Database Administrators and developers will learn to optimize query performance, handle backup procedures, set up monitoring systems, and establish resilient, enterprise-ready PostgreSQL configurations.

This training program is tailored for Database Administrators and Architects aiming to master PostgreSQL from the ground up.

Participants will gain comprehensive knowledge of PostgreSQL's architecture, installation procedures, database design principles, and essential backup and recovery techniques.

This course is tailored for Database Administrators and Architects aiming to master the essential tools and methodologies for implementing backups, high availability, and robust security within PostgreSQL.
Participants will also acquire skills in identifying slow queries, monitoring overall database performance, and optimizing PostgreSQL settings to enhance system efficiency.

Achieving zero-downtime PostgreSQL deployments demands expert Streaming Replication and automated failover management. This course covers synchronous and asynchronous replication, cascaded replication, transaction log archiving, base backups, and monitoring streaming configurations. Learn to deploy pgpool-II for connection pooling, automated high availability setup, and production-grade database reliability for critical enterprise environments serving high-traffic business applications.

This training is tailored for Database Administrators and Architects aiming to optimize PostgreSQL databases for peak performance. You will learn techniques to log slow-running workloads, identify potential bottlenecks in queries, and configure the critical parameters necessary for achieving optimal system efficiency.

In this instructor-led live training in Vietnam (onsite or remote), participants will explore both general and advanced aspects of PostgreSQL. This includes administration, performance tuning, advanced development techniques, and replication. Through a series of hands-on lab exercises, learners will navigate setup, configuration, testing, deployment, and troubleshooting processes.

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

• Utilize advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize databases and queries to achieve maximum performance.
• Implement replication and scaling strategies for PostgreSQL servers.

PostgresAI provides a platform that empowers database teams to clone, test, and optimize PostgreSQL environments through AI-driven automation.

This instructor-led live training, available online or onsite, targets advanced DevOps professionals and database engineers looking to implement PostgresAI at an enterprise scale for monitoring, cloning, and AI-assisted optimization.

Upon completing this training, participants will be able to:

• Deploy and configure PostgresAI within enterprise settings.
• Integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Utilize 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.
• Numerous exercises and practical activities.
• Hands-on implementation in a live laboratory environment.

Course Customization Options

• For customized training requests, please contact us to make arrangements.

This course teaches how to programmatically interact with PostgreSQL databases. Participants will learn the necessary techniques, syntaxes, and structures to build high-quality applications using PostgreSQL as a backend. The training also includes SQL Tuning, focusing on best practices for writing efficient SQL code.

The target audience consists of developers who wish to use or extend PostgreSQL, as well as database architects.

This course offers a comprehensive exploration of replication, high availability, and cluster management within PostgreSQL. Participants will construct and oversee multi-node environments, set up automated failover mechanisms, and investigate load balancing and connection pooling options. The curriculum incorporates hands-on replication labs and disaster recovery simulations.

This instructor-led live training in Vietnam (online or onsite) targets intermediate-level developers and administrators aiming to utilize the newest features and improvements in PostgreSQL 16.

By the conclusion of this training, participants will be capable of:

• Understanding the architecture and components of PostgreSQL 16.
• Utilizing advanced SQL features and PostgreSQL extensions.
• Implementing security best practices and access controls.
• Performing database administration tasks, including backup, recovery, and monitoring.
• Optimizing database performance through tuning and indexing strategies.
• Using PostgreSQL's built-in tools for high availability and replication.
• Integrating PostgreSQL with modern application development frameworks.