PostgreSQL Advanced: Replication and High Availability (RepMgr, PgPool-II) Training Course

Develop expertise in AI integration with Postgres through this instructor-led live training in New Zealand. Gain the skills to configure extensions, implement pgvector embeddings, and connect LLMs for instant insights. Refine query performance and build intelligent systems in a practical, hands-on live-lab setting.

This 21-hour live training in New Zealand assists data engineers and DBAs in embedding AI models into PostgreSQL. Learners will master the deployment of optimised architectures, the implementation of vector search, and the enforcement of strict governance, ensuring secure, high-performance, enterprise-grade AI solutions.

This course explores the foundational aspects of PostgreSQL server extensions and libraries designed to embed artificial intelligence techniques within database systems. Key topics include similarity and semantic search utilising embedding vectors, Text-to-SQL querying, and Retrieval-Augmented Generation (RAG). Participants will acquire the skills to install PgVector and PgAI, generate and load vector embeddings, create vector indexes, implement semantic search and RAG, and develop Text-to-SQL applications using LangChain with Python or JavaScript. Through demonstrations and hands-on practice, learners will reinforce their core concepts and practical abilities.

This module explores the essential PostgreSQL server extensions designed to embed artificial intelligence capabilities within database architectures, with a particular focus on similarity and semantic search leveraging embedding vectors. Participants will gain proficiency in installing PgVector, generating and loading vector embeddings, constructing vector indexes, and deploying semantic search functionality. Through a combination of live demonstrations and practical exercises, learners will consolidate their understanding of these core concepts while developing robust professional skills.

This practical course focuses on real-world performance tuning for PostgreSQL. You will learn to dissect query execution, streamline indexing, modify memory and system settings, and monitor workloads with precision. Using live scenarios and hands-on exercises, the course illustrates how to detect and fix performance bottlenecks at both the database and system levels.

This course provides the essential knowledge required to install, configure, and manage PostgreSQL databases effectively. Participants will learn how to handle user security, perform backups and restores, manage logs, and tune basic parameters. Through practical exercises, learners will perform real-world administration tasks and prepare for advanced topics such as performance and replication.

In this instructor-led, live training in New Zealand (onsite or remote), participants will explore both fundamental and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication. This is achieved through a series of practical, hands-on lab exercises covering setup, configuration, testing, deployment, and troubleshooting.

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

• Apply advanced administrative techniques to configure and manage a PostgreSQL server.
• Optimise databases and queries to achieve maximum performance.
• Replicate and scale a PostgreSQL server.

This instructor-led, live training in New Zealand prepares advanced DevOps professionals and database engineers to implement PostgresAI at enterprise scale. Participants will master database cloning, AI-driven query optimisation, and monitoring through hands-on exercises in a live-lab environment.

This instructor-led, live training in New Zealand (delivered online or on-site) is designed for intermediate-level developers and administrators seeking to harness the latest features and enhancements in PostgreSQL 16.

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

• Understand the architecture and core components of PostgreSQL 16.
• Leverage advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls.
• Carry out essential database administration tasks, including backup, recovery, and monitoring.
• Optimise database performance through effective tuning and indexing strategies.
• Utilise PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks.