# Prompt Engineering + Basic RAG Day 2 Lab

> In this lab, Zach sets up a retrieval-augmented generation (RAG) system, which included creating a vector database in Supabase. During the session, he demonstrates how to load synthetic job and profile data into this table, emphasizing the importance of avoiding duplicate vectors to preserve system…

- Web page: https://www.dataexpert.io/lesson/prompt-engineering-day2-lab-oct2025
- Program: [AI Engineering Boot Camp starting October 20th, 2025](https://www.dataexpert.io/program/the-ai-engineering-challenge-starting-october-20th-2025)
- Access: Requires enrollment in AI Engineering Boot Camp starting October 20th, 2025
- Length: 1 h 1 min video
- Skills: SQL, Python, LLMs
- Academy: DataExpert.io Academy

## About this lesson

In this lab, Zach sets up a retrieval-augmented generation (RAG) system, which included creating a vector database in Supabase. During the session, he demonstrates how to load synthetic job and profile data into this table, emphasizing the importance of avoiding duplicate vectors to preserve system performance. He also creates a Python script designed to generate embeddings and retrieve relevant job listings based on user queries.

## Navigation

- Previous lesson: [Prompt Engineering + Basic RAG Day 2 Lecture](https://www.dataexpert.io/lesson/prompt-engineering-day2-lecture-oct2025.md)
- Next lesson: [RAG optimisation + Reranking Day 1 Lecture](https://www.dataexpert.io/lesson/rag-optimisation-reranking-day1-lecture-oct-2025.md)