Vector Search with Relational Databases using PostgreSQL

SkillUp EdTech via Coursera

Go to Course: https://www.coursera.org/learn/vector-search-with-relational-databases-using-postgresql

Introduction

Describe the principles of modeling vector data in Relational databases (RDBMS). 

Apply the commands necessary to store, retrieve, and query vectors efficiently in PostgreSQL. 

Implement indexing techniques and optimization strategies for enhancing vector search performance. 

Demonstrate, through hands-on labs, how to set up environments and perform vector searches using PostgreSQL. 

Syllabus

Vector Search Practices for SQL Databases

Welcome to this module, where you’ll learn how to implement vector searches using relational databases. You’ll begin with a recap of RDBMS and then dive into the structures RDBMS uses to support vector data types and queries. You’ll apply what you know to perform similarity search tasks using special operators available in PostgreSQL. And, with a focus on PostgreSQL, you’ll learn how to create tsvector data, perform tsquery tasks, and perform bulk inserts using pg-vector for Node.js and psycopg2 for Python.