HLD · LLD · System Design with Real Projects
About 6.5 guided hours per project, plus 4–6 hours of exercises and capstone work. Roughly 45–55 hours in total.
Launch price
₹499₹1,499 regular
HAVE A COUPON?
Apply coupon above, then buy — Razorpay opens after that
- DURATION
- 5 projects
- LEVEL
- Backend projects
- COMMITMENT
- 45–55 hours
What you will learn
Text-to-SQL chatbot
Multi-layer SQL guardrails and measured accuracy on a gold question set.
URL shortener with analytics
Redis caching and sliding-window rate limiting, with a measured redirect rate.
Real-time chat
WebSocket rooms, JWT auth, and message history persisted in PostgreSQL.
Document Q&A
Source citations and retrieval evaluation, measured as hit rate at k.
Payment ledger
Idempotent double-entry transactions, verified under concurrent load.
Course chapters
- Text-to-SQL Chatbot with GuardrailsProject 1
- RequirementsProject 1
- ConceptsProject 1
- High-level designProject 1
- Low-level designProject 1
- System design notesProject 1
- Build overviewProject 1
- Build 1 · Project setup, config, and sample databaseProject 1
- Build 2 · API models and guardrailsProject 1
- Build 3 · Read-only database layerProject 1
- Build 4 · LLM client and prompt designProject 1
- Build 5 · FastAPI routesProject 1
- Build 6 · Chat UI in HTML and JavaScriptProject 1
- Demo and evaluationProject 1
- README, GitHub, and resumeProject 1
- Practicals indexProject 1
Timeline
PROJECT 1
Text-to-SQL Chatbot
The design method and trust boundaries, on a small system. FastAPI, SQLite, an LLM, and SQL guardrails.
PROJECT 2
URL Shortener with Analytics
Persistence, caching, and scale. PostgreSQL, Redis, base62, and sliding-window rate limiting.
PROJECT 3
Real-Time Chat
Long-lived connections and state. WebSockets, JWT, rooms, presence, and message history.
PROJECT 4
Document Q&A
Retrieval, evaluation, and citations. Builds on the evaluation habit from Project 1.
PROJECT 5
Payment Ledger
Correctness under concurrency. Idempotency keys, retries, and double-entry bookkeeping.
Launch price
₹499₹1,499
Have a coupon? Enter it here before buying