
Build a production-grade rag pipeline with Postgres pgvector for company knowledge base and ecommerce semantic search, including vectorization, chunking, ingestion, vector indexes, Redis caching, Evals, and reranking.
Install and configure tools and API keys for a hands-on rag project: Visual Studio Code, Docker Desktop, PGAdmin, OpenAI, Langsmith, and Cohere, enabling embeddings and LLM models.
Download a zip of the lecture resources, unzip to access the slides used in this course, including a Keynote file for Mac and a PowerPoint file for Windows.
Download the zip to access completed and skeleton projects, including company knowledge assistant. Drag the assistant into Visual Studio Code and follow shop wise ecommerce skeleton for the assignment.
PostgreSQL with pgVector offers a unified vector store for rag applications, combining vectors, sql filters, and metadata in a reliable, open source production-ready database.
Develop a company knowledge assistant by building a vectorization ingestion pipeline that creates embeddings in a vector store and powers a LangChain RAG workflow from data directory files.
Learn to extract a folder name as a category during ingestion, assign it to each document chunk, and store this metadata in the vector store using ingest.py load docs method.
Add category filtering to the rag pipeline by introducing a category parameter, updating the store.asRetriever search kw arguments, and applying a metadata category filter before embedding-based search.
Learn how to pass a category to the API by defining a category variable as 'guides' and passing it into answerWithDocsAsync during build chain, using data from the guides folder.
Explore metadata filtering in action by querying guides data, vectorizing content, and extracting a category field to enable accurate answers and ingestion workflows.
Expose a RAG pipeline in LangChain as an MCP tool, letting an AI agent fetch policies from a vector store, reason about HR expense claims, and approve or reject them.
Update the expense policy by downloading the latest policy and replacing the file in the policies folder, validate the pre-approval for expenses above 10,000, then re-ingest data to observe chunks.
Download the project zip, replace api.py and data files in the app folder, configure the fast mcp REST API with tools, and launch the mcp server with mapped routes.
Open mcp__requirements.txt, copy MCP, langchain__mcp__adapters, streamlet, and langgraph into your project, then install via pip3 and run the local streamlet app to launch the MCP server and agent.
Implement the MCP tools to run a ragg pipeline that returns answer, sources, and context, and complete two dummy tools that print and return approved or rejected.
Test the MCP server by relaunching the app, connecting via Postman to localhost:8000/mcp, and validating the rag_ask, approve, reject tools and the MCP health endpoint.
Walk through implementing a policy-driven human resources expense compliance agent with an mcp-based workflow to fetch policies, evaluate claims, and output json decisions.
Create an agent in policy_underscore_agent.py by configuring the MCP URL and tools with a streamable HTTP transport, then set up an OpenAI LLM and invoke the agent.
Explore agentic rag in action by running a streamlit app to process a claim json and review approve or reject decisions via a rag pipeline.
Retrieval-Augmented Generation (RAG) is one of the most powerful ways to make Large Language Models (LLMs) smarter, more reliable, and production-ready. Instead of depending only on what the model “knows,” RAG allows us to fetch relevant knowledge from external sources and provide precise, up-to-date answers.
In this hands-on course, you’ll go beyond the basics and actually build RAG pipelines step by step using LangChain, the leading framework for LLM applications. Whether you are a developer, data scientist, or AI enthusiast, this course will give you the practical skills to design, implement, and optimize real-world RAG projects.
What You’ll Learn
Real-World Project: Build two end-to-end RAG Projects on Company Data and E-Commerce Semantic Search.
Caching Strategies: Use embedding and response caching to reduce cost, latency, and improve efficiency.
Indexing: Explore Flat, IVF Flat, HNSW, and disk-based indexes; learn which one to use for your dataset.
Reranking: Improve answer precision using similarity scores, cross-encoders, and LLM-based reranking.
Evaluations (Evals & Ragas): Measure faithfulness, relevance, and retrieval quality with Ragas metrics.
Metadata: Use metadata filters to make retrieval precise, context-aware, and production-ready.
Why Take This Course?
It’s hands-on — you won’t just learn theory; you’ll build working RAG pipelines.
You’ll learn best practices for scaling from demo to production.
Content is designed for real-world applications in enterprise, startups, and research.
You’ll walk away with code, skills, and confidence to build your own RAG-powered apps.
Who This Course Is For
Developers and data scientists interested in LangChain and LLM applications.
AI/ML engineers who want to deploy production-ready RAG systems.
Professionals curious about vector databases, embeddings, and retrieval systems.
Anyone who wants to go beyond ChatGPT and build AI that leverages their own data.
By the end of this course, you’ll have the knowledge and hands-on experience to design and implement efficient RAG pipelines with LangChain — and the skills to apply them to your own projects or business use cases.