How to build RAG Document Platform from Scratch | FastAPI + PostgreSQL + Streamlit | AI-200

In this video, we build Cogni Docs, a real-world retrieval augmented generation platform, demonstrating how to create enterprise-level artificial intelligence document systems. This project serves as a practical guide for viewers to build similar ai projects, including setting up prerequisites and implementing Azure Functions. The system leverages advanced ai search capabilities and integrates with an llm for enhanced document processing.

In this video we build CogniDocs — a real-world Retrieval-Augmented Generation (RAG) document platform on Azure — from the ground up. We start with the local foundation: a FastAPI REST backend, a PostgreSQL database with pgvector for future vector search, and a Streamlit frontend. No fluff — every line of code is explained.

This is Video 1 of the AI-200 Certification Study Series. By the end of this video you'll have a fully running local app ready to connect to Azure services in the next videos.

What you'll learn:

How to structure a Python project for Azure (FastAPI + Streamlit)
PostgreSQL with pgvector — why we use it and how to run it locally with Docker
FastAPI startup events, APIRouter, async endpoints (with .NET comparisons)
Streamlit as a rapid UI for Python backends
Docker Compose for local multi-service development
How this maps to real enterprise RAG architecture used in production

Timestamps:
00:00 - AI-200 Certification Preparation Intro
00:25 - What is CogniDocs and why we're building it
01:40 - Software setup | Python, Docker Desktop
02:25 - AI-200 exam overview and what this series covers
05:07 - Project structure walkthrough
07:30 - Docker Compose: PostgreSQL + Redis locally
14:45 - FastAPI backend: endpoints, database, startup
24:00 - Streamlit frontend: upload, list, search
26:50 - End-to-end test: upload a file and see it in the DB
28:00 - Troubleshooting on issues

GitHub: https://github.com/learnsmartcoding/ai-200-cogni-docs
AI-200 Study Guide: https://learn.microsoft.com/en-us/credentials/certifications/azure-developer-associate/

Please post your questions in the comment section and I will be happy to answer your questions.

Subscribe for more useful videos just like this: https://www.youtube.com/channel/UCKUxSY2xp12QiP3c60sOc-g?sub_confirmation=1

Happy coding!

Видео How to build RAG Document Platform from Scratch | FastAPI + PostgreSQL + Streamlit | AI-200 канала Learn Smart Coding