← Course catalogue
DBS-210Intermediate

Databases

NoSQL & MongoDB Data Modelling

Design, query and maintain document databases using realistic learner and service data.

Part of these pathways

Course outline: enrolment opens after THNF content and assessment review.

What you will be able to do

Clear outcomes. Practical evidence.

  • Model document data
  • Choose embedding or references
  • Write queries and aggregations
  • Apply validation and indexes

Course structure

Modules and lessons

01

NoSQL foundations and MongoDB setup

Explain and apply documents, BSON, collections, ObjectId, flexible schema, access patterns to a tested, privacy-safe solution.

  1. NoSQL foundations and MongoDB setup60 min
02

Documents, collections and CRUD

Explain and apply insert/find/update/delete, projections, operators, upsert to a tested, privacy-safe solution.

  1. Documents, collections and CRUD60 min
03

Embedding, references and schema design

Explain and apply one-to-few, one-to-many, lifecycle, duplication, document growth to a tested, privacy-safe solution.

  1. Embedding, references and schema design60 min
04

Queries and atomic updates

Explain and apply comparison/logical/array operators, positional updates, $inc, findOneAndUpdate to a tested, privacy-safe solution.

  1. Queries and atomic updates60 min
05

Aggregation pipelines

Explain and apply $match, $project, $unwind, $group, $lookup, $sort, $facet to a tested, privacy-safe solution.

  1. Aggregation pipelines60 min
06

Indexes and query performance

Explain and apply single/compound/multikey/text indexes, explain, selectivity, ESR guideline to a tested, privacy-safe solution.

  1. Indexes and query performance60 min
07

Validation and consistency

Explain and apply $jsonSchema, required fields, enums, unique indexes, transactions to a tested, privacy-safe solution.

  1. Validation and consistency60 min
08

Security, backup and recovery

Explain and apply authentication, roles, network exposure, TLS, mongodump/restore, redaction to a tested, privacy-safe solution.

  1. Security, backup and recovery60 min
09

Application integration

Explain and apply driver lifecycle, connection pooling, timeouts, repository, pagination to a tested, privacy-safe solution.

  1. Application integration60 min
10

Capstone community data platform

Explain and apply access patterns, model, validation, indexes, pipelines, security, recovery to a tested, privacy-safe solution.

  1. Capstone community data platform60 min

Access and progression

Know what the course requires.

The required capability matters; the learner does not have to personally own every device.

Who it is for

Aspiring developers, technical learners, career changers and practitioners seeking applied computing skills.

Hardware access

Personal 64-bit computer with 4 GB RAM and 20 GB free, or use the required device and software at a readiness-approved THNF centre.

Software and practical access

Course software is available through the text-first pack, an approved offline installer or a readiness-approved THNF centre.

Possible progression

Junior development, data, web, application-support or technical-project progression appropriate to the completed portfolio.

Progression is not a guarantee of employment or external certification.

Sierra Leone context

Mobile-first, low-data solutions for Sierra Leonean schools, traders, transport, agriculture, NGOs and SMEs using synthetic local names, districts and NLe values.

Skills in context

Career directions and next steps

These are realistic directions that the skills can support—not promises of employment, job titles or external certification.

  • Junior data assistant
  • Database-support assistant
  • Reporting and information assistant
Possible progression pathways

Data and databases