Beginner level Databases and Backend Engineering

Design, Query and Build a Data-Backed App

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.

  • 40hours of work
  • 19parts
  • Checkedcapstone
  • Lifetimeaccess
  • SQL
  • Database design
  • Joins and aggregation
  • Transactions
  • SQLite
  • Python and databases

At a glance

Who it is for

Beginners with no database experience, and learners who have used spreadsheets or seen a little SQL but never designed or built a database of their own.

Before you start

A computer with Python 3.10+ (SQLite comes with it) or the sqlite3 command-line tool, and a code editor. A free tool such as DB Browser for SQLite is helpful. Basic Python (variables, functions, loops) helps for the last third.

How you finish

Pass the quizzes, complete the labs and submit your capstone. Everything is checked as you go and your certificate is issued the moment you finish.

What you will be able to do

  1. 01Read, filter, sort, group and summarise data with SQL
  2. 02Combine tables with joins and subqueries
  3. 03Design tables with keys, constraints and relationships, and explain normalisation
  4. 04Change data safely with transactions and speed up queries with indexes
  5. 05Use a database from a Python program without SQL injection

Curriculum 40 hours in 19 parts

Select a kind to highlight its parts.

Stage 1Answer questions about a movie database7 parts · 11 h
  1. 1
    What a database is, and your first queriesLesson · Short, focused reading with questions to check yourself.
    1 hFree
  2. 2
    Selecting, filtering and sortingLesson · Short, focused reading with questions to check yourself.
    1 h
  3. 3
    Query a bookstore databaseWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  4. 4
    Summarising data: aggregates and GROUP BYLesson · Short, focused reading with questions to check yourself.
    1 h
  5. 5
    Sales analytics with GROUP BYWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  6. 6
    Check yourself: SELECT, filtering and aggregationQuiz · Twelve questions, marked at once, with the reason behind each answer.
    1 h
  7. 7
    Answer questions about a movie databaseLab · Hands-on work. Many labs are checked automatically against what must exist.
    3 h
Stage 2Design and build an online shop database6 parts · 10 h
  1. 8
    Designing tables: keys, types and relationshipsLesson · Short, focused reading with questions to check yourself.
    1 h
  2. 9
    Design a library databaseWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  3. 10
    Joins and subqueriesLesson · Short, focused reading with questions to check yourself.
    1 h
  4. 11
    Joins on the library databaseWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  5. 12
    Check yourself: database design and joinsQuiz · Twelve questions, marked at once, with the reason behind each answer.
    1 h
  6. 13
    Design and build an online shop databaseLab · Hands-on work. Many labs are checked automatically against what must exist.
    3 h
Stage 3A command-line inventory app backed by SQLite4 parts · 8 h
  1. 14
    Changing data, transactions and indexesWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  2. 15
    Using a database from Python safelyWorkshop · Follow along and build, with the steps and the traps written out.
    2 h
  3. 16
    Check yourself: transactions, indexes and databases from PythonQuiz · Twelve questions, marked at once, with the reason behind each answer.
    1 h
  4. 17
    A command-line inventory app backed by SQLiteLab · Hands-on work. Many labs are checked automatically against what must exist.
    3 h
Stage 4Import, clean and report on real data1 part · 3 h
  1. 18
    Import, clean and report on real dataLab · Hands-on work. Many labs are checked automatically against what must exist.
    3 h
FinishCapstone project1 part · 8 h
  1. 19
    A data-backed applicationCapstone · A full project for your portfolio.
    8 h
Free lessonWhat a database is, and your first queries
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

See how verification works

More in Databases and Backend Engineering

Keep building.

3 programmes in this track, from beginner to expert. Buy the learning path and save 15%.

IntermediateIntermediate40 h 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.

  • REST API design
  • FastAPI
  • PostgreSQL
Rs. 649 + GST
ExpertExpert40 h Caching, Queues and Reliability

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
Rs. 999 + GST

See all 3 programmes in Databases and Backend Engineering Take the placement test

Before you enrol

Quick answers.

The policies have the full detail.

Refund policy Terms of use

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. 352.82 including GST. Lifetime access. Read the first lesson free before you decide.

Compare programmes