PostgreSQL AI for Developers Training Course
This course introduces the core concepts of PostgreSQL server extensions and libraries designed to incorporate artificial intelligence into database systems. Key topics include semantic and similarity search using 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, creating vector indexes, and implementing semantic search and RAG functionalities. Additionally, the curriculum covers building Text-to-SQL applications with LangChain using Python or JavaScript. Through demonstrations and practical exercises, learners will reinforce both theoretical knowledge and technical proficiency.
This course is available as onsite live training in Nigeria 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
Prerequisites include foundational knowledge of SQL, basic experience with PostgreSQL, and familiarity with either 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 proficiency in integrating AI with Postgres through this live, instructor-led session held in Nigeria. You will learn to configure necessary extensions, deploy pgvector for embeddings, and connect LLMs for instantaneous insights. Furthermore, optimize your queries and build intelligent systems through practical, hands-on exercises in a live-lab setting.
AI for PostgreSQL: Enterprise-Grade Integration, Optimization & Governance
21 HoursThis 21-hour instructor-led training in Nigeria 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, thereby ensuring secure and high-performance enterprise-grade AI solutions.
PostgreSQL AI: Introduction to semantic search
7 HoursThis program explores the essential PostgreSQL server extensions designed to embed AI capabilities directly into database environments, with a particular focus on similarity and semantic search utilizing embedding vectors. Participants will acquire the skills necessary to deploy PgVector, process and ingest vector embeddings, construct vector indexes, and execute semantic queries. Through practical demonstrations and hands-on exercises, the course solidifies both theoretical understanding and applied proficiency.
PostgreSQL Advanced - Performance Management
14 HoursThis practical course is dedicated to the real-world application of performance tuning within PostgreSQL. It guides participants through the process of analyzing query execution, refining indexing strategies, tuning memory and system settings, and monitoring active workloads. Through real-world scenarios and live practical exercises, you will learn how to pinpoint and resolve performance bottlenecks at both the database and system levels.
PostgreSQL Administration and Development
28 HoursPostgreSQL Server Administration
14 HoursThis course delivers the foundational skills needed to deploy, configure, and oversee PostgreSQL databases with confidence. Participants will gain proficiency in securing user access, executing robust backup and restoration strategies, overseeing log management, and optimizing core parameters. Through hands-on exercises, learners will tackle practical administration scenarios while building a strong base for exploring advanced concepts like high performance and data 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 conducted Nigeria (either on-site or remotely), participants will explore the core and advanced capabilities of PostgreSQL. The programme includes administration, performance tuning, advanced development, and replication, guided by 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 administrative methods to configure and oversee a PostgreSQL server.
- Enhance the performance of the database and queries to maximum potential.
- Execute replication and scaling of a PostgreSQL server.
PostgresAI at Enterprise Scale: Monitoring, Cloning & AI-Driven Operations
21 HoursThis instructor-led, live training in Nigeria empowers advanced DevOps professionals and database engineers to implement PostgresAI at an enterprise scale. Participants will gain mastery over database cloning, AI-driven query optimization, and monitoring through hands-on exercises in a live-lab setting.
PostgreSQL for Developers
14 HoursPostgreSQL Advanced: Replication and High Availability (RepMgr, PgPool-II)
14 HoursThis course delivers a detailed look into PostgreSQL replication, high availability, and cluster administration. Participants will construct and manage multi-node setups, implement automated failover mechanisms, and explore load balancing and connection pooling options. The curriculum incorporates hands-on replication labs and recovery exercises.
PostgreSQL 16 for Developers and Administrators
21 HoursThis instructor-led, live training in Nigeria (online or in-person) is designed for intermediate developers and administrators eager to exploit the newest 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.
