PostgreSQL Training in Porto

This instructor-led live training in Porto 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 gain mastery over database cloning, AI-driven query optimization, and advanced monitoring techniques.

This 21-hour instructor-led course in Porto equips data engineers and DBAs with the skills to integrate AI models into PostgreSQL. Participants will learn to deploy optimized architectures, implement vector search, and enforce strict governance, ensuring secure and high-performance enterprise-grade AI solutions.

Gain mastery over AI integration in Postgres through this live, instructor-led training in Porto. You will learn to configure extensions, implement pgvector embeddings, and connect LLMs for real-time insights. Optimise queries and build intelligent systems within a hands-on live-lab environment.

This instructor-led, live training in Porto (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

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

• Understand relational database principles and PostgreSQL architecture.
• Install, configure, and navigate PostgreSQL and PGAdmin.
• Write and run SQL queries for data selection, filtering, grouping, and joining.
• Manipulate data with SQL statements and manage database objects.
• Create and manage views and explore PostgreSQL extensions like Timescale.

This instructor-led, live training in Porto (online or onsite) targets intermediate-level developers and administrators looking to capitalize on the new features and improvements introduced in PostgreSQL 16.

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

• Comprehending the architecture and components of PostgreSQL 16.
• Utilizing advanced SQL functionalities and PostgreSQL extensions.
• Implementing security best practices and managing access controls.
• Carrying out database administration duties, including backup, recovery, and monitoring.
• Optimizing database performance via tuning and indexing methods.
• Employing PostgreSQL's native tools for high availability and replication.
• Integrating PostgreSQL with modern application development frameworks.

Designed to equip you with the core competencies for installing, configuring, and overseeing PostgreSQL databases, this module focuses on essential operational tasks. You will gain proficiency in implementing user security protocols, executing backup and recovery procedures, overseeing system logs, and optimising fundamental parameters. By engaging in hands-on scenarios, you will execute realistic administrative duties while building a strong foundation for advanced subjects such as performance tuning and replication strategies.

In this instructor-led, live training in Porto (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving 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.

This instructor-led, live training in Porto (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

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

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

This course explores the core concepts of PostgreSQL server extensions and libraries designed to incorporate artificial intelligence techniques into database architectures. Key topics include similarity and semantic search utilizing embedding vectors, Text-to-SQL query capabilities, and Retrieval-Augmented Generation (RAG). Participants will acquire the skills necessary to install PgVector and PgAI, generate and ingest vector embeddings, construct vector indexes, and implement semantic search alongside RAG solutions. Additionally, attendees will develop Text-to-SQL applications leveraging LangChain with either Python or JavaScript. These learning experiences are solidified through live demonstrations and practical exercises that reinforce both theoretical understanding and technical proficiency.

This course explores the foundational PostgreSQL server extensions designed to incorporate AI techniques into database environments, specifically highlighting similarity and semantic search through the use of embedding vectors. Learners will be guided through the processes of installing PgVector, creating and loading vector embeddings, building vector indexes, and implementing semantic search. The course utilizes practical demonstrations and hands-on activities to solidify key concepts and develop essential practical skills.

This practical course delves into the essential aspects of performance tuning in PostgreSQL. Learners will gain skills in analysing query execution, refining indexing strategies, tuning memory and system parameters, and effectively monitoring workloads. Through real-world case studies and live practical exercises, the course illustrates how to pinpoint and eliminate performance bottlenecks at both the database and system levels.

This course delivers detailed coverage of replication, high availability, and cluster management in PostgreSQL. Participants will construct and manage multi-node setups, configure automated failover, and explore solutions for load balancing and connection pooling. The program includes live replication labs and recovery simulations.

This intensive one-day, hands-on workshop is dedicated to the design and implementation of distributed database solutions using the Citus extension for PostgreSQL. Learners will gain practical insights into sharding large datasets, managing distributed queries, and constructing scalable, fault-tolerant PostgreSQL clusters. Through real-world scenarios and practical labs, the course illustrates techniques for performance tuning, integrating replication, and managing distributed workloads.