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

Postgres is an advanced open-source relational database that can serve as a foundation for AI-powered systems and data intelligence applications.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database professionals and developers who wish to integrate, manage, and optimize AI capabilities directly within Postgres.

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

• Set up and configure Postgres extensions for AI workloads.
• Implement embeddings and similarity search using pgvector.
• Integrate open source and proprietary LLMs with Postgres for real-time insights.
• Optimize Postgres for handling AI-driven queries and workflows.

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.

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

This instructor-led live training, available online or on-site, is designed for intermediate to advanced data engineers, database administrators (DBAs), and solution architects looking to design, implement, and govern enterprise-grade AI systems utilizing PostgreSQL.

Upon completing this program, participants will acquire the skills necessary to:

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

Course Format

• Engaging lectures coupled with enterprise case study discussions.
• Practical exercises and real-world laboratory sessions.
• Hands-on implementation in a live PostgreSQL environment.

Customization Options

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

This instructor-led live training in South Korea (available online or onsite) is designed for database administrators and cloud architects who wish 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 determine which database best meets business objectives and needs.
• Prepare databases to transfer definitions, data, and procedures from Oracle to the AzureSQL or PostgreSQL database system.
• Carry out post-migration steps to test, optimize, update, and maintain the migrated database.

This course explores the core principles of PostgreSQL server extensions and libraries designed to incorporate AI capabilities into database environments. Key topics include semantic and similarity search utilizing embedding vectors, Text-to-SQL query generation, and Retrieval-Augmented Generation (RAG). Participants will acquire the skills to install PgVector and PgAI, generate and import vector embeddings, establish vector indexes, and execute semantic search and RAG workflows. Additionally, learners will build Text-to-SQL applications leveraging LangChain with Python or JavaScript. Through practical demonstrations and hands-on exercises, the essential concepts and technical competencies are reinforced.

This practical course delves into the essential 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 case studies and hands-on exercises, attendees will learn to identify and resolve performance bottlenecks at both the database and system levels.

This course covers the administration and performance tuning of PostgreSQL databases. Participants will gain expertise in utilizing specialized PostgreSQL (also known as Postgres) modules, including replication, connection pooling, and full-text searching.

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

Participants will gain comprehensive knowledge of PostgreSQL architecture, installation procedures, design principles, and techniques for performing database backups and recovery.

This course is tailored for Database Administrators and Architects seeking to master the tools and methodologies required to implement robust backups, high availability solutions, and comprehensive database security within PostgreSQL.
Participants will also gain insights into identifying slow queries, monitoring database performance, and optimizing PostgreSQL for peak efficiency.

Designed for Database Administrators and Architects, this training covers PostgreSQL Streaming Replication and demonstrates how pgpool-II can be leveraged to achieve automatic failovers and establish a highly available PostgreSQL database cluster.

This course is tailored for Database Administrators and Architects aiming to enhance the performance of PostgreSQL databases. Participants will learn how to capture slow query logs, identify potential bottlenecks within queries, and explore critical parameters that must be adjusted to achieve optimal system performance.

In this instructor-led, live training conducted in South Korea (onsite or remote), participants will explore both general and advanced aspects of PostgreSQL. The curriculum includes administration, performance tuning, advanced development, and replication, reinforced by hands-on, live-lab exercises that cover setup, configuration, testing, deployment, and troubleshooting.

By the end 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 designed to empower database teams with AI-driven automation for cloning, testing, and optimizing PostgreSQL environments.

This instructor-led training, available online or onsite, targets advanced DevOps professionals and database engineers seeking to implement PostgresAI at an enterprise level for enhanced database monitoring, cloning, and AI-driven optimization.

Upon completing this training, participants will be equipped to:

• Deploy and configure PostgresAI within enterprise settings.
• Seamlessly integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Utilize AI-driven insights to optimize queries and fine-tune performance.
• Establish governance, auditing, and data privacy controls for cloned environments.

Course Format

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

Customization Options

• For customized training arrangements, please contact us to discuss your specific needs.

This course is designed to help learners master the programmatic interaction with PostgreSQL databases. It covers the essential techniques, syntaxes, and structural concepts required to build high-quality applications backed by PostgreSQL. Additionally, the training includes SQL Tuning, focusing on best practices for writing highly efficient SQL code.

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

This instructor-led, live training in South Korea (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.