Databases & SQL

Mongo DB

MongoDB stores data in flexible documents instead of rigid tables, and it's a core skill for modern web and app development. This course covers documents and collections, CRUD operations, queries, indexing and data modelling the NoSQL way. It pairs perfectly with Node.js and the MERN stack.

Duration1.5 mths
FormatLive 1-on-1
LevelProfessional
CertificateOsian
Overview

What this course is about

Mongo DB is taught here as a hands-on, live one-on-one course rather than a stack of videos. Almost every application stores its data in a database, so being fluent in querying and designing one is a foundational skill across tech.

By working through real exercises you’ll use indexes to speed things up, design normalised schemas, and build the judgement that only comes from practice.

You finish with practical work you can show an employer, not just a certificate.

By the end

What you’ll be able to do

  • Write queries from simple SELECTs to multi-table joins
  • Design normalised schemas
  • Use indexes to speed things up
  • Work with stored procedures and transactions
Syllabus

How the course flows

  1. 1

    Data & Tables

    Week 1

    How relational data is organised, and creating your first tables and records.

  2. 2

    Querying Data

    Week 2

    SELECT, WHERE, ORDER BY and filtering — pulling exactly the rows you need.

  3. 3

    Joins & Relationships

    Week 3

    Combining data across tables with inner, outer and self joins.

  4. 4

    Aggregation & Grouping

    Week 4

    GROUP BY, HAVING and aggregate functions for real reporting queries.

  5. 5

    Design & Optimisation

    Weeks 5–6

    Normalisation, indexes and writing queries that stay fast on big tables.

Toolkit

Tools you’ll use

MySQLPostgreSQLSQL ServerMongoDBDBeaver
Fit

Who it’s for

  • Students looking to add a job-ready skill alongside their degree
  • Beginners who want a structured, guided way into databases & sql
  • Freelancers who want to offer Mongo DB as a paid service
  • People preparing for interviews and placements in this field
Where it leads

Roles this opens up

SQL Developer

₹4–10 LPA

Write and optimise the queries that power reports and apps.

Data Analyst

₹4–12 LPA

Turn raw database data into decisions for the business.

Backend Developer

₹5–16 LPA

Build application data layers and APIs on top of databases.

Questions

Before you enroll

Yes. Because it’s one-on-one, sessions are booked around your availability, including evenings and weekends.

No prior database experience needed. The first sessions make sure everyone is on solid ground before moving faster.

Yes — resume help, mock interviews and referrals through our hiring-partner network are included with the course.

You’ll finish with practical work — write queries from simple SELECTs to multi-table joins — plus an Osian Academy certificate you can share with employers.