PostgreSQL Training in Sao Paulo

This live, instructor-led training in Sao Paulo prepares advanced DevOps professionals and database engineers to implement PostgresAI at enterprise scale. Through hands-on exercises in a live-lab setting, participants will gain mastery over database cloning, AI-driven query optimization, and monitoring capabilities.

This 21-hour instructor-led training in Sao Paulo empowers data engineers and DBAs to seamlessly integrate AI models into PostgreSQL. Learners will master the deployment of optimized architectures, the implementation of vector search, and the enforcement of strict governance, resulting in secure, high-performance enterprise-grade AI solutions.

Gain expertise in AI integration within Postgres through this instructor-led live training in Sao Paulo. Discover how to configure extensions, apply pgvector embeddings, and connect LLMs for real-time insights. Enhance query optimization and build intelligent systems in a hands-on live-lab setting.

This instructor-led, live training in Sao Paulo (online or onsite) is designed for 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 Sao Paulo (online or onsite) is aimed at intermediate-level developers and administrators who wish to leverage the latest features and improvements in PostgreSQL 16.

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

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

This course delivers the foundational expertise needed to install, configure, and oversee PostgreSQL databases. It covers critical areas such as user security, backup and recovery workflows, log management, and parameter adjustment. Through practical application, you will gain experience in real-world administrative duties, positioning yourself to tackle advanced topics like performance tuning and replication.

In this instructor-led, live training in Sao Paulo (onsite or remote), participants will explore both the general and advanced aspects of PostgreSQL, including administration, performance tuning, advanced development, and replication. The curriculum involves stepping through a series of hands-on, live-lab exercises that cover setup, configuration, testing, deployment, and troubleshooting.

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

• Utilize 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 Sao Paulo (online or onsite) is designed for database administrators and system administrators who want to use PostgreSQL to manage large-scale data while optimizing database systems for high availability and performance.

Upon completion 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 using 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 external tools for monitoring and observability.

This course explores the essential PostgreSQL server extensions and libraries designed to incorporate AI 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 solutions, and develop Text-to-SQL applications with LangChain using Python or JavaScript. Through demonstrations and hands-on exercises, the core concepts and practical skills are reinforced.

This course explores the fundamentals of PostgreSQL server extensions designed to integrate AI capabilities into database environments, with a specific focus on similarity and semantic search using embedding vectors. Participants will acquire the skills to install PgVector, generate and load vector embeddings, construct vector indexes, and execute semantic search queries. Through live demonstrations and practical exercises, the core concepts and hands-on competencies will be solidified.

This practical course is dedicated to the real-world application of performance tuning within PostgreSQL. Learners will gain the skills to dissect query execution, refine indexing strategies, fine-tune memory and system parameters, and oversee workloads with precision. Through live exercises and practical case studies, the course illustrates techniques for pinpointing and eliminating performance bottlenecks at both the database and system levels.

This module offers a comprehensive exploration of PostgreSQL replication, high availability, and cluster management. Learners will gain hands-on experience in constructing and administering multi-node environments, setting up automated failover mechanisms, and integrating load balancing with connection pooling. The curriculum features practical replication exercises and recovery simulations to reinforce core concepts.

This intensive one-day hands-on workshop is dedicated to the design and implementation of distributed databases utilizing the Citus extension for PostgreSQL.
Attendees will gain practical skills in sharding extensive datasets, managing distributed queries, and constructing scalable, fault-tolerant PostgreSQL clusters.
Through real-world case studies and practical labs, the course demonstrates techniques for performance tuning, replication integration, and the management of distributed workloads.