PostgreSQL Training in Bangkok

This live, instructor-led training in Bangkok is designed to equip advanced DevOps professionals and database engineers with the skills to implement PostgresAI at enterprise scale. Through hands-on exercises in a live-lab environment, participants will master key techniques in database cloning, AI-driven query optimization, and comprehensive monitoring.

This 21-hour instructor-led training in Bangkok empowers data engineers and DBAs to integrate AI models into PostgreSQL. Participants will learn to deploy optimized architectures, implement vector search, and enforce strict governance, thereby ensuring secure and high-performance enterprise-grade AI solutions.

Gain mastery over AI integration in Postgres through this live, instructor-led training in Bangkok. You will learn to configure extensions, apply pgvector embeddings, and connect LLMs for real-time insights. Optimize query performance and build intelligent systems in a hands-on live-lab setting.

This instructor-led live training in Bangkok (delivered online or on-site) is tailored for entry-level professionals seeking to acquire the skills to utilize PostgreSQL for database creation, SQL query writing, data manipulation, and table management using both SQL commands and PGAdmin. The curriculum also includes a fundamental introduction to the Timescale extension for managing time-series data.

By the conclusion of this training, participants will possess the ability to:

• Comprehend relational database principles and the architecture of PostgreSQL.
• Successfully install, configure, and navigate PostgreSQL and PGAdmin.
• Draft and execute SQL queries for data selection, filtering, grouping, and joining.
• Perform data manipulation with SQL statements and manage database objects.
• Create and oversee views, and explore PostgreSQL extensions such as Timescale.

This instructor-led, live training in Bangkok (delivered online or onsite) is tailored for intermediate-level developers and administrators seeking to exploit the latest capabilities and refinements in PostgreSQL 16.

By the end of the session, participants will be prepared to:

• Grasp the architectural design and key components of PostgreSQL 16.
• Utilize advanced SQL functionalities and PostgreSQL extensions.
• Establish security best practices and manage access controls.
• Carry out database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Use PostgreSQL’s internal tools for high availability and replication.
• Connect PostgreSQL with modern application development frameworks.

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 Bangkok (onsite or remote), participants will dive into the general and advanced aspects of PostgreSQL. Key topics include administration, performance tuning, advanced development, and replication. The learning process involves a series of hands-on, live-lab exercises covering setup, configuration, testing, deployment, and troubleshooting.

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

• Utilize advanced administration techniques to configure and manage PostgreSQL servers.
• Optimize the database and queries for peak performance.
• Replicate and scale PostgreSQL servers.

This live, instructor-led session in Bangkok (online or onsite) is designed for database administrators and system administrators looking to leverage PostgreSQL for managing large-scale datasets. The focus is on optimizing database systems for high availability and superior performance.

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

• Install and configure the PostgreSQL environment.
• Comprehend the core features and architectural components of PostgreSQL.
• Execute standard database operations using SQL.
• Implement backup and recovery strategies to safeguard against data loss.
• Configure server settings to ensure high availability.
• Apply specific tools and methodologies for performance tuning.
• Utilize external utilities for comprehensive monitoring and observability.

This course delves into the essential PostgreSQL server extensions and libraries that facilitate the integration of AI techniques within database systems. It highlights critical features such as similarity and semantic search using embedding vectors, Text-to-SQL querying, and Retrieval-Augmented Generation (RAG). Learners will master the installation of PgVector and PgAI, the generation and loading of vector embeddings, and the creation of vector indexes. The curriculum also covers the implementation of semantic search and RAG, as well as the development of Text-to-SQL applications utilizing LangChain in Python and JavaScript. Through a blend of demonstrations and hands-on practice, students will reinforce their grasp of core concepts and practical skills.

This program explores the core concepts of extending PostgreSQL server capabilities to incorporate AI methodologies into database environments, with a specific focus on similarity and semantic search driven by embedding vectors. Participants will be guided through the process of installing PgVector, generating and importing vector embeddings, constructing vector indexes, and executing semantic queries. Through a combination of live demonstrations and practical exercises, the course solidifies key theoretical principles and enhances applied technical proficiency.

This practical course is dedicated to the real-world application of performance tuning in PostgreSQL. Learners will gain the skills to examine query execution, refine indexing strategies, fine-tune memory and system settings, and effectively oversee workloads. Through practical scenarios and live exercises, participants will discover how to pinpoint and eliminate performance bottlenecks at both the database and system levels.

This program delivers an extensive examination of replication, high availability, and cluster management in PostgreSQL. Students will learn to construct and manage multi-node setups, automate failover configurations, and utilize load balancing and connection pooling solutions. The course incorporates live replication exercises and recovery drills to ensure practical competency.

This intensive one-day practical course is designed to master distributed database architecture and deployment using the Citus extension for PostgreSQL.
Learners will explore methods for sharding extensive datasets, executing distributed queries, and constructing highly scalable and fault-tolerant PostgreSQL clusters.
Through real-world scenarios and hands-on labs, the course covers performance optimization, replication integration, and the management of distributed workloads