PostgreSQL Advanced: Scalability and Sharding (Citus) Training Course

Postgres, an advanced open-source relational database, serves as a robust foundation for building AI-powered systems and data intelligence applications.

This instructor-led live training, available online or on-site, targets intermediate-level database professionals and developers seeking to integrate, manage, and optimize AI capabilities directly within Postgres.

Upon completing this training, participants will be able to:

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

Format of the Course

• Interactive lecture and discussion.
• Extensive exercises and practical 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 augmented with AI capabilities to deliver enterprise data intelligence, predictive analytics, and automation.

This instructor-led live training (available online or onsite) is designed for intermediate to advanced data engineers, DBAs, and solution architects who aim to design, implement, and govern enterprise-grade AI systems built on PostgreSQL.

Upon completing this program, participants will acquire the expertise to:

• Integrate AI models and vector search capabilities directly within PostgreSQL.
• Deploy AI-optimized architectures tailored for high-volume enterprise workloads.
• Establish robust governance, auditing, and compliance frameworks for AI data pipelines.
• Safely leverage both open-source and proprietary AI frameworks within PostgreSQL environments.

Course Format

• Interactive lectures complemented by enterprise case study discussions.
• Practical exercises and real-world laboratory sessions.
• Hands-on implementation within a live PostgreSQL environment.

Customization Options

• To request tailored training for this course, please contact us to arrange details.

This instructor-led live training, conducted Romania (online or on-site), is intended for database administrators and cloud architects who wish to migrate their Oracle databases to Azure SQL or PostgreSQL.

By the end of the course, participants will be able to:

• Compare Azure SQL and PostgreSQL to determine which database best suits their business objectives and needs.
• Prepare databases to facilitate the transfer of definitions, data, and procedures from Oracle to Azure SQL or PostgreSQL.
• Carry out post-migration steps to test, optimize, update, and maintain the migrated database.

This course explores the foundational aspects of PostgreSQL server extensions and libraries designed to incorporate AI methodologies into database environments. Key topics include similarity and semantic search utilizing embedding vectors, Text-to-SQL querying, and Retrieval-Augmented Generation (RAG). Participants will acquire skills in installing PgVector and PgAI, generating and loading vector embeddings, establishing vector indexes, and implementing semantic search and RAG mechanisms. Additionally, the curriculum covers developing Text-to-SQL applications with LangChain in Python or JavaScript. These concepts and practical competencies are solidified through live demonstrations and hands-on exercises.

This practical, hands-on course concentrates on the real-world application of performance tuning within PostgreSQL. Participants will gain expertise in analysing query execution, refining indexing strategies, fine-tuning memory and system parameters, and effectively monitoring workload patterns. Through live exercises and real-world scenarios, the course demonstrates how to pinpoint and address performance bottlenecks at both the database and infrastructure levels.

This hands-on, three-day course provides a comprehensive set of skills needed to build resilient applications with PostgreSQL.
Attendees will master advanced SQL techniques, procedural programming using PL/pgSQL, and database design strategies that enhance both performance and maintainability.
Practical exercises center on developing stored functions, triggers, and automation logic directly within the PostgreSQL environment.

This course delivers the foundational expertise needed to install, configure, and effectively manage PostgreSQL databases. Participants will acquire skills in managing user security, executing backups and restores, handling logs, and fine-tuning core parameters. Through hands-on exercises, learners will carry out practical administration tasks and prepare for advanced subjects like performance optimization and replication.

PostgresAI is a platform that enables database teams to clone, test, and optimize PostgreSQL environments using AI-driven automation.

This instructor-led, live training (online or onsite) is aimed at advanced-level DevOps professionals and database engineers who wish to implement PostgresAI at enterprise scale for database monitoring, cloning, and AI-driven optimization.

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

• Deploy and configure PostgresAI in enterprise environments.
• Integrate PostgresAI with CI/CD pipelines and PostgreSQL clusters.
• Leverage AI-driven insights for query optimization and performance tuning.
• Implement governance, auditing, and data privacy controls for cloned environments.

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.

This program offers a comprehensive exploration of replication, high availability, and cluster management within PostgreSQL. Attendees will learn to construct and oversee multi-node setups, set up automated failover processes, and investigate options for load balancing and connection pooling. The curriculum features hands-on replication exercises and disaster recovery simulations.

This instructor-led, live training in Romania (online or onsite) is designed for beginner-level professionals who want 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, held in Romania (online or on-site), is intended for developers and administrators seeking to build secure, reliable, and scalable applications by integrating PostgreSQL with Python.

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

• Install, configure, and connect PostgreSQL with Python.
• Review Python programming fundamentals.
• Understand the benefits of using PostgreSQL with Python.
• Perform basic SQL operations using Python.
• Utilize advanced PostgreSQL features with Python.
• Implement strategies for data safety, security, monitoring, and optimization.