Learners who know basic SQL and Python and want to build and operate real web backends: students, junior developers and self-taught programmers moving from scripts to services.
Intermediate level
Databases and Backend Engineering
APIs, Transactions and Performance
Build a real backend API in Python with FastAPI and PostgreSQL: REST design, validation, authentication, transactions and concurrency, query performance, testing and containers, ending with a production-style service.
- 40hours of work
- 19parts
- Reviewedcapstone
- Lifetimeaccess
- REST API design
- FastAPI
- PostgreSQL
- Authentication and security
- Transactions and concurrency
- Query performance
At a glance
Basic SQL (SELECT, JOIN, GROUP BY) and Python (functions, classes, packages). Docker Desktop (or Docker Engine), Python 3.10+, Git and a code editor. If you have finished SQL and Databases: Design, Query and Build a Data-Backed App, you are ready.
Pass the quizzes and labs, then submit a capstone project. The NIBVEDA team reviews it and either accepts it or sends it back with comments you can act on.
What you will be able to do
- 01Design and build a validated, documented REST API with FastAPI on PostgreSQL
- 02Secure it with password hashing, tokens and ownership checks
- 03Keep data correct under concurrency with transactions, locks and constraints
- 04Find and fix slow queries with indexes, query plans and pagination
- 05Test, containerise and automate the build of a backend service
Curriculum 40 hours in 19 parts
Select a kind to highlight its parts.
Stage 1A REST API for bookmarks with PostgreSQL7 parts · 11 h
- 1How a web backend works: HTTP, REST and JSONLesson · Short, focused reading with questions to check yourself.1 hFree
- 2PostgreSQL essentials and migrationsLesson · Short, focused reading with questions to check yourself.1 h
- 3Postgres in Docker with migrationsWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 4Building REST APIs with FastAPILesson · Short, focused reading with questions to check yourself.1 h
- 5A CRUD API for projects and tasksWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 6Check yourself: HTTP, REST and FastAPIQuiz · Twelve questions, marked at once, with the reason behind each answer.1 h
- 7A REST API for bookmarks with PostgreSQLLab · Hands-on work. Many labs are checked automatically against what must exist.3 h
Stage 2An authenticated multi-user API with a concurrency-safe operation6 parts · 10 h
- 8Authentication, authorisation and security basicsLesson · Short, focused reading with questions to check yourself.1 h
- 9Users, login and protected endpointsWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 10Transactions, isolation and concurrencyLesson · Short, focused reading with questions to check yourself.1 h
- 11Reproducing and fixing a race conditionWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 12Check yourself: authentication, security and concurrencyQuiz · Twelve questions, marked at once, with the reason behind each answer.1 h
- 13An authenticated multi-user API with a concurrency-safe operationLab · Hands-on work. Many labs are checked automatically against what must exist.3 h
Stage 3Find and fix the slow parts of an API4 parts · 8 h
- 14Query performance, indexes and paginationWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 15Testing and deploying the APIWorkshop · Follow along and build, with the steps and the traps written out.2 h
- 16Check yourself: performance, testing and deploymentQuiz · Twelve questions, marked at once, with the reason behind each answer.1 h
- 17Find and fix the slow parts of an APILab · Hands-on work. Many labs are checked automatically against what must exist.3 h
Stage 4Containerise the service and automate the build1 part · 3 h
- 18Containerise the service and automate the buildLab · Hands-on work. Many labs are checked automatically against what must exist.3 h
FinishCapstone project1 part · 8 h
- 19A production-style backend serviceCapstone · A full project for your portfolio.8 h
What you take away
An internship certificate with your skills on it.
Made for you automatically when you finish the last part, it names the internship programme, the level and the 40 hours, lists what you showed, and carries a number and a QR code. Anyone can check it on the NIBVEDA verification page, and it shows as withdrawn there if it is ever revoked.
- Proof you completed all 40 hours of this internship programme
- An Internship badge for your profile, CV or portfolio
- Not a job, a stipend or an academic degree, and it says so
Keep building.
3 programmes in this track, from beginner to expert. Buy the learning path and save 15%.
Learn SQL from the first query to joins and transactions, design a clean database for a real scenario, and connect it to a Python program, finishing with a complete data-backed application.
- SQL
- Database design
- Joins and aggregation
Learn how production backends handle load and failure: caching with Redis, background work with queues, database scaling, rate limiting, retries and circuit breakers, observability and load testing, finishing with a measured, resilient service.
- Caching with Redis
- Message queues
- System design
See all 3 programmes in Databases and Backend Engineering Take the placement test
Quick answers.
The policies have the full detail.
Is this a real internship?
It is a virtual internship programme: a structured, self-paced course built around a real project, with checked assessments and a certificate. It is not employment, it does not carry a stipend and it is not an academic or AICTE-approved qualification. What it gives you is verified, project-based evidence of skills.
How does self-paced work?
You start when you like and move at your own speed. Each part unlocks when you finish the one before it. There are no live classes and no deadlines. Your access is shown on each programme page.
How is my work checked?
Quizzes are marked as soon as you submit them. Labs use a tick-list of tasks. Intermediate and Expert programmes finish with a capstone that the NIBVEDA team reviews and either accepts or sends back with comments.
Can I get a refund?
Please read the refund policy before you buy. It explains when a refund is possible.
Ready to start?
Rs. 765.82 including GST. Lifetime access. Read the first lesson free before you decide.