PostgreSQL AI for Developers Training Course
This course explores the fundamentals of PostgreSQL server extensions and libraries designed to integrate artificial intelligence techniques into database systems. 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, create vector indexes, implement semantic search and RAG, and develop Text-to-SQL applications using LangChain with Python or JavaScript. Demonstrations and hands-on practice reinforce the core concepts and practical skills.
This course is available as onsite live training in Botswana or online live training.Course Outline
Introduction to:
- vectors
- AI vector embeddings
- popular AI embedding models
- semantic search
- distance measures
Overview of vector indexing techniques:
- IVFFlat index
- HNSW index
PgVector extension for PostgreSQL:
- installation
- storing and querying high-dimensional vectors
- distance measures
- using vector indexes
PgAI extension for PostgreSQL:
- installation
- generating embeddings
- implementing Retrieval-Augmented Generation
- advanced development patterns
Overview of Text-to-SQL solutions: LangChain framework
Course outcome: By the end of the course, students will be able to:
- design and build elements of AI-powered database applications using PostgreSQL extensions and libraries.
- gain practical experience with techniques for integrating large language models (LLMs) and vector search into real-world systems, enabling them to develop applications such as semantic search engines, AI assistants, and natural-language database interfaces.
Requirements
Basic knowledge of SQL, basic experience with PostgreSQL, and foundational understanding of Python or JavaScript programming languages
Audience: Database developers, system architects
Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
PostgreSQL AI for Developers Training Course - Enquiry
Testimonials (1)
Tables indexes and qq reperforming & tuning in order to improve them
Roberto Esposito
Course - PostgreSQL AI for Developers
Related Courses
AI for Postgres
21 HoursGain mastery over AI integration within Postgres through this live, instructor-led training held in Botswana. You will learn to configure essential extensions, deploy pgvector embeddings, and link LLMs for real-time analytical insights. Furthermore, you will optimize query performance and construct intelligent systems within a hands-on live lab setting.
AI for PostgreSQL: Enterprise-Grade Integration, Optimization & Governance
21 HoursThis 21-hour instructor-led training in Botswana 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, ensuring the delivery of secure, high-performance enterprise-grade AI solutions.
PostgreSQL AI: Introduction to semantic search
7 HoursThis module explores the key principles of leveraging PostgreSQL server extensions to embed AI capabilities within database environments, specifically concentrating on semantic and similarity search through embedding vectors. Participants will gain insight into installing PgVector, generating and loading vector embeddings, establishing vector indexes, and executing semantic search. A combination of live demonstrations and practical exercises will be utilized to reinforce these essential concepts and refine hands-on abilities.
PostgreSQL Advanced - Performance Management
14 HoursThis practical course delves into the core strategies for optimising PostgreSQL performance. Learners will develop the skills to evaluate query execution, refine indexing strategies, fine-tune memory and system configurations, and oversee workload efficiency. Through real-world case studies and interactive sessions, participants will explore methods for pinpointing and eliminating performance bottlenecks across both database and system layers.
PostgreSQL Administration and Development
28 HoursPostgreSQL Server Administration
14 HoursThis 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.
PostgreSQL Essentials
14 HoursPostgreSQL Advanced DBA
14 HoursImplementing High Availability in PostgreSQL
7 HoursPostgreSQL Performance Tuning
14 HoursPostgreSQL Administration, Optimization and Replication
35 HoursIn this instructor-led live training Botswana (onsite or remote), participants will explore the general and advanced aspects of PostgreSQL. The course covers administration, performance tuning, advanced development, and replication 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.
PostgresAI at Enterprise Scale: Monitoring, Cloning & AI-Driven Operations
21 HoursThis instructor-led, live training in Botswana prepares advanced DevOps professionals and database engineers to implement PostgresAI at an enterprise level. Participants will gain proficiency in database cloning, AI-driven query optimization, and monitoring through hands-on exercises in a live-lab environment.
PostgreSQL for Developers
14 HoursPostgreSQL Advanced: Replication and High Availability (RepMgr, PgPool-II)
14 HoursThis course delivers an in-depth examination of replication, high availability, and cluster management in PostgreSQL. Participants will develop and control multi-node setups, implement automated failover, and study load balancing and connection pooling strategies. The program includes hands-on replication labs and recovery simulations.
PostgreSQL 16 for Developers and Administrators
21 HoursThis instructor-led, live training in Botswana (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.
- Utilise advanced SQL features and PostgreSQL extensions.
- Implement security best practices and access controls.
- Perform database administration tasks, including backup, recovery, and monitoring.
- Optimise database performance through tuning and indexing strategies.
- Utilise PostgreSQL's built-in tools for high availability and replication.
- Integrate PostgreSQL with modern application development frameworks.
