PostgreSQL AI: Introduction to semantic search Training Course
The course covers the fundamentals of PostgreSQL server extensions used to integrate AI techniques into database systems, including similarity/semantic search based on embedding vectors. Students will learn how to install PgVector, generate and load vector embeddings, create vector indexes, implement semantic search. Demonstrations and hands-on practices will reinforce the core concepts and practical skills.
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
Course outcome: By the end of the course, students will understand the popular AI-powered PostgreSQL extensions. They will gain practical experience with techniques for integrating large language models (LLMs) and vector search into real-world applications.
Requirements
basic knowledge of SQL, basic experience with PostgreSQL
Lab environment: DaDesktops running Linux virtual machines (Provided by NobleProg)
Audience: database application developers, system architects, data analysts
Need help picking the right course?
azerbaijan@nobleprog.com
PostgreSQL AI: Introduction to semantic search Training Course - Enquiry
PostgreSQL AI: Introduction to semantic search - Consultancy Enquiry
Testimonials (1)
how to use LLM in daily work
Cont - Everymatrix
Course - PostgreSQL AI: Introduction to semantic search
Related Courses
AI for Postgres
21 HoursMaster AI integration in Postgres with this instructor-led live training in Azərbaycan. Learn to configure extensions, implement pgvector embeddings, and connect LLMs for real-time insights. Optimize queries and build intelligent systems in a hands-on live-lab environment.
AI for PostgreSQL: Enterprise-Grade Integration, Optimization & Governance
21 HoursThis 21-hour instructor-led training in Azərbaycan helps data engineers and DBAs integrate AI models into PostgreSQL. Participants learn to deploy optimized architectures, implement vector search, and enforce strict governance, ensuring secure and high-performance enterprise-grade AI solutions.
PostgreSQL AI for Developers
14 HoursThe course covers the fundamentals of PostgreSQL server extensions and libraries used to integrate AI techniques into database systems, including: similarity/semantic search based on embedding vectors, Text-to-SQL querying, and Retrieval-Augmented Generation (RAG). Students will learn how to install PgVector and PgAI, generate and load vector embeddings, create vector indexes, implement semantic search and RAG, develop Text-to-SQL applications using LangChain with Python/JavaScript. Demonstrations and hands-on practice reinforce the core concepts and practical skills.
PostgreSQL Advanced - Performance Management
14 HoursThis hands-on course focuses on the practical aspects of performance tuning in PostgreSQL. Participants will learn to analyse query execution, optimise indexing, adjust memory and system parameters, and monitor workloads effectively. Real-world scenarios and live exercises demonstrate how to identify and resolve bottlenecks at both the database and system levels.
PostgreSQL Administration and Development
28 HoursPostgreSQL for Developers: PL/pgSQL Programming
21 Hours
This practical 3-day training covers the complete skill set required to develop robust applications using PostgreSQL.
Participants learn advanced SQL, procedural programming with PL/pgSQL, and database design techniques that improve performance and maintainability.
Real-world exercises focus on building stored functions, triggers, and automation logic directly inside PostgreSQL.
PostgreSQL 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 in Azərbaycan (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step 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 Azərbaycan equips advanced DevOps professionals and database engineers to implement PostgresAI at enterprise scale. Participants will master database cloning, AI-driven query optimization, and monitoring using hands-on exercises in a live-lab environment.
PostgreSQL for Developers
14 HoursPostgreSQL Advanced: Replication and High Availability (RepMgr, PgPool-II)
14 HoursThis course provides in-depth coverage of replication, high availability, and cluster management in PostgreSQL. Participants will build and manage multi-node environments, configure failover automation, and explore load balancing and connection pooling solutions. The course includes live replication labs and recovery simulations.