PostgreSQL Advanced: Scalability and Sharding (Citus) Training Course

Postgres is a sophisticated open-source relational database that serves as a robust foundation for AI-driven systems and data intelligence applications.

This instructor-led, live training (available online or onsite) is designed for intermediate-level database professionals and developers looking 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 specifically for AI workloads.
• Implement embeddings and perform similarity searches using pgvector.
• Integrate both open-source and proprietary LLMs with Postgres to gain real-time insights.
• Optimize Postgres to efficiently handle AI-driven queries and workflows.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical activities.
• Hands-on implementation within a live-lab environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange it.

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

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

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

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

Course Format

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

Course Customization Options

• For customized training requests, please contact us to arrange suitable options.

This instructor-led, live training in Sweden (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 choose the database that best meets business objectives and needs.
• Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
• Perform post-migration steps to test, optimize, update, and maintain a migrated database.

This course delves into the fundamentals of PostgreSQL server extensions and libraries designed to integrate AI techniques 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 to install PgVector and PgAI, generate and load vector embeddings, create vector indexes, and implement semantic search and RAG. Additionally, the course covers developing Text-to-SQL applications using LangChain with Python or JavaScript. Demonstrations and hands-on practice are used to reinforce core concepts and practical skills.

This practical course concentrates on the hands-on techniques for tuning PostgreSQL performance. Students will acquire the skills to examine query execution, refine indexing strategies, configure memory and system settings, and track workloads efficiently. Through real-life cases and interactive exercises, learners will see how to detect and fix bottlenecks at both the database and system levels.

This course covers the administration and performance tuning of PostgreSQL databases. Participants will learn to utilize specialized PostgreSQL (also known as Postgres) modules, including replication, connection pooling, and full-text search capabilities.

This training is intended for Database Administrators and Architects who wish to gain a foundational understanding of PostgreSQL.

Participants will cover PostgreSQL architecture, installation procedures, design principles, and techniques for performing backup and recovery operations on PostgreSQL databases.

This course is tailored for Database Administrators and Architects seeking to master the tools and methodologies for implementing Backups, High Availability, and Database Security within PostgreSQL.
Participants will also gain skills in identifying slow queries, monitoring database performance, and optimizing PostgreSQL settings for enhanced efficiency.

This program is tailored for Database Administrators and Architects seeking to master Streaming Replication within PostgreSQL. It demonstrates how pgpool-II can facilitate automatic failover mechanisms and the creation of a highly available PostgreSQL Database Cluster.

This training is tailored for Database Administrators and Architects aiming to optimize PostgreSQL for peak performance. You will learn how to log slow queries and identify potential bottlenecks. The course also addresses the critical parameters that must be adjusted to achieve optimal performance.

Through this instructor-led live training in Sweden (onsite or remotely), participants will gain insights into both fundamental and advanced PostgreSQL concepts. This includes administration, performance tuning, advanced development techniques, and replication. The curriculum involves a series of practical, live laboratory exercises covering setup, configuration, testing, deployment, and troubleshooting.

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

• Apply advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and its queries to achieve maximum performance.
• Implement replication and scaling strategies for a PostgreSQL server.

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 course explores programmatic interaction with PostgreSQL databases. You will acquire the techniques, syntax, and structural knowledge required to build high-quality applications backed by PostgreSQL. The training also addresses SQL Tuning, presenting best practices for crafting efficient SQL code.

The target audience comprises developers aiming to utilize or extend PostgreSQL, as well as database architects.

This course offers a comprehensive exploration of replication, high availability, and cluster management within PostgreSQL. Participants will learn to construct and administer multi-node environments, set up automated failover processes, and investigate load balancing and connection pooling strategies. The curriculum features hands-on replication labs and recovery simulations.