PROMPTPILOTPRO — FREE RAG COURSE DOWNLOADS ========================================= LESSONS ------- 1. LESSON_01_Build_First_RAG.html — Build Your First RAG System 2. LESSON_02_Add_Chat_Interface.html — Add a Chat Interface 3. LESSON_03_Deploy_to_Live_URL.html — Deploy to a Live URL STARTER NOTEBOOK ---------------- NOTEBOOK_01_RAG_Starter.py — Python starter code for Lesson 1 Full RAG flow: LOAD → SPLIT → EMBED → STORE → RETRIEVE → GENERATE PRACTICE DATA (Northwind Traders — Microsoft sample database) -------------------------------------------------------------- northwind_categories.txt — 8 product categories northwind_products.txt — 15 products with prices, stock, supplier info northwind_customers.txt — 10 customers across 7 countries northwind_suppliers.txt — 5 suppliers across 4 countries Try asking your RAG system: - "Which products are discontinued?" - "What is the most expensive product?" - "Which customers are in Germany?" - "Who supplies the Tofu product?" DEPENDENCIES ------------ streamlit openai langchain-openai langchain-chroma langchain-text-splitters chromadb DATA SOURCE AND LICENSE ----------------------- Source: Microsoft Northwind sample database URL: github.com/microsoft/sql-server-samples (samples/databases/northwind-pubs) License: MIT License — github.com/microsoft/sql-server-samples This is a small subset of the original database, selected for RAG practice exercises.