NoSQL Course Database

🍃 NoSQL Course Database Tutorial: MongoDB Collections Design

🎯 What You'll Learn

By the end of this tutorial, you will:

• Understand why NoSQL beats SQL for course content storage
• Design 4 essential MongoDB collections for e-learning platforms
• Write practical MongoDB commands for inserts, queries, updates, and aggregations
• Handle rich media, nested modules, and flexible quiz structures
• Build activity tracking, notes, and discussion systems

🤔 Part 1: Why NoSQL for Course Content?

The Problem with SQL for Content

When to Use NoSQL vs SQL

┌─────────────────────────────────────────────────────────────┐
│  SQL (PostgreSQL)          │  NoSQL (MongoDB)               │
├─────────────────────────────────────────────────────────────┤
│  • User accounts             │  • Course lesson content       │
│  • Payments & enrollments    │  • Quiz questions & answers    │
│  • Progress tracking         │  • User notes & bookmarks      │
│  • Reviews & ratings         │  • Activity logs & analytics   │
│  • Categories & catalog      │  • Discussion threads          │
└─────────────────────────────────────────────────────────────┘

Best Practice: Use SQL for transactional data, MongoDB for content and logs.

📦 Part 2: Collection 1 — courses_content

Purpose

Stores the entire course curriculum in a single hierarchical document. One document = one course with all modules and lessons nested inside.

Schema Design

javascriptCopy
1{
2  "_id": "course_001",
3  "title": "Full-Stack Web Development",
4  "slug": "fullstack-web-dev",
5  "metadata": {
6    "level": "intermediate",
7    "category": "Programming",
8    "tags": ["javascript", "react", "node.js", "mongodb"],
9    "language": "en",
10    "last_updated": "2026-08-10T10:00:00Z"
11  },
12  "modules": [
13    {
14      "module_id": "mod_001",
15      "order": 1,
16      "title": "Module 1: JavaScript Fundamentals",
17      "description": "Master ES6+ syntax, async programming, and DOM manipulation.",
18      "estimated_mins": 180,
19      "lessons": [
20        {
21          "lesson_id": "les_001",
22          "order": 1,
23          "title": "Variables & Data Types",
24          "type": "video",
25          "duration_mins": 15,
26          "video_url": "https://cdn.example.com/videos/les_001.mp4",
27          "transcript": "In this lesson, we explore let, const, and var...",
28          "resources": [
29            { "name": "Cheat Sheet", "url": "https://cdn.example.com/sheets/js-basics.pdf" }
30          ],
31          "is_free_preview": true
32        },
33        {
34          "lesson_id": "les_002",
35          "order": 2,
36          "title": "Async/Await Deep Dive",
37          "type": "text",
38          "content": {
39            "body": "<h2>Understanding Promises</h2><p>Async/await is syntactic sugar...</p>",
40            "code_snippets": [
41              {
42                "language": "javascript",
43                "code": "async function fetchData() { ... }",
44                "output": "Data loaded successfully"
45              }
46            ]
47          }
48        },
49        {
50          "lesson_id": "les_003",
51          "order": 3,
52          "title": "Quiz: JavaScript Basics",
53          "type": "quiz",
54          "quiz_data": {
55            "time_limit_mins": 10,
56            "pass_score": 70,
57            "questions": [
58              {
59                "q_id": "q1",
60                "text": "What is the output of `typeof null`?",
61                "type": "mcq",
62                "options": ["'null'", "'object'", "'undefined'", "'number'"],
63                "correct": 1,
64                "explanation": "JavaScript bug: typeof null returns 'object'"
65              }
66            ]
67          }
68        }
69      ]
70    }
71  ],
72  "created_at": "2026-01-15T08:00:00Z",
73  "updated_at": "2026-08-10T10:00:00Z"
74}

MongoDB Commands

Insert a Complete Course

javascriptCopy
1db.courses_content.insertOne({
2  _id: "course_001",
3  title: "Full-Stack Web Development",
4  slug: "fullstack-web-dev",
5  metadata: {
6    level: "intermediate",
7    category: "Programming",
8    tags: ["javascript", "react", "node.js", "mongodb"],
9    language: "en",
10    last_updated: new Date("2026-08-10T10:00:00Z")
11  },
12  modules: [
13    {
14      module_id: "mod_001",
15      order: 1,
16      title: "Module 1: JavaScript Fundamentals",
17      description: "Master ES6+ syntax and async programming.",
18      estimated_mins: 180,
19      lessons: [
20        {
21          lesson_id: "les_001",
22          order: 1,
23          title: "Variables & Data Types",
24          type: "video",
25          duration_mins: 15,
26          video_url: "https://cdn.example.com/videos/les_001.mp4",
27          transcript: "In this lesson, we explore let, const, and var...",
28          resources: [
29            { name: "Cheat Sheet", url: "https://cdn.example.com/sheets/js-basics.pdf" }
30          ],
31          is_free_preview: true
32        }
33      ]
34    }
35  ],
36  created_at: new Date(),
37  updated_at: new Date()
38});

Find Course by Slug

javascriptCopy
1db.courses_content.findOne({ slug: "fullstack-web-dev" });

Find All Intermediate Programming Courses

javascriptCopy
1db.courses_content.find({
2  "metadata.level": "intermediate",
3  "metadata.category": "Programming"
4});

Add a New Module to Existing Course

javascriptCopy
1db.courses_content.updateOne(
2  { _id: "course_001" },
3  {
4    $push: {
5      modules: {
6        module_id: "mod_002",
7        order: 2,
8        title: "Module 2: React Framework",
9        description: "Components, hooks, and state management.",
10        estimated_mins: 240,
11        lessons: []
12      }
13    },
14    $set: { updated_at: new Date() }
15  }
16);

Add a Lesson to a Specific Module

javascriptCopy
1db.courses_content.updateOne(
2  { _id: "course_001", "modules.module_id": "mod_002" },
3  {
4    $push: {
5      "modules.$.lessons": {
6        lesson_id: "les_010",
7        order: 1,
8        title: "React Components 101",
9        type: "video",
10        duration_mins: 20,
11        video_url: "https://cdn.example.com/videos/react-101.mp4",
12        is_free_preview: false
13      }
14    },
15    $set: { updated_at: new Date() }
16  }
17);

Find All Free Preview Lessons

javascriptCopy
1db.courses_content.find(
2  { "modules.lessons.is_free_preview": true },
3  { title: 1, "modules.lessons.title": 1 }
4);

Update Course Metadata Tags

javascriptCopy
1db.courses_content.updateOne(
2  { _id: "course_001" },
3  {
4    $set: {
5      "metadata.tags": ["javascript", "react", "node.js", "mongodb", "typescript"],
6      "metadata.last_updated": new Date()
7    }
8  }
9);

Aggregate: Count Total Lessons Per Course

javascriptCopy
1db.courses_content.aggregate([
2  { $match: { _id: "course_001" } },
3  { $unwind: "$modules" },
4  { $unwind: "$modules.lessons" },
5  {
6    $group: {
7      _id: "$_id",
8      title: { $first: "$title" },
9      total_lessons: { $sum: 1 },
10      total_duration: { $sum: "$modules.lessons.duration_mins" }
11    }
12  }
13]);

📊 Part 3: Collection 2 — user_activity_logs

Purpose

Tracks every student interaction: video plays, pauses, quiz submissions, page scrolls. High-write, time-series data perfect for MongoDB.

Schema Design

javascriptCopy
1{
2  "_id": "log_001",
3  "user_id": "user_123",
4  "course_id": "course_001",
5  "events": [
6    {
7      "type": "video_play",
8      "lesson_id": "les_001",
9      "timestamp": "2026-08-13T11:30:00Z",
10      "metadata": { "play_position": 0, "device": "desktop", "browser": "chrome" }
11    },
12    {
13      "type": "video_pause",
14      "lesson_id": "les_001",
15      "timestamp": "2026-08-13T11:35:00Z",
16      "metadata": { "pause_position": 300, "device": "desktop" }
17    },
18    {
19      "type": "quiz_submit",
20      "lesson_id": "les_003",
21      "timestamp": "2026-08-13T12:00:00Z",
22      "metadata": { "score": 85, "time_taken_secs": 480, "attempt": 1 }
23    }
24  ]
25}

MongoDB Commands

Insert Activity Log

javascriptCopy
1db.user_activity_logs.insertOne({
2  _id: "log_001",
3  user_id: "user_123",
4  course_id: "course_001",
5  events: [
6    {
7      type: "video_play",
8      lesson_id: "les_001",
9      timestamp: new Date(),
10      metadata: { play_position: 0, device: "desktop" }
11    }
12  ]
13});

Append New Event (Atomic Push)

javascriptCopy
1db.user_activity_logs.updateOne(
2  { _id: "log_001" },
3  {
4    $push: {
5      events: {
6        type: "video_pause",
7        lesson_id: "les_001",
8        timestamp: new Date(),
9        metadata: { pause_position: 300, device: "desktop" }
10      }
11    }
12  }
13);

Find All Video Events for a User

javascriptCopy
1db.user_activity_logs.find(
2  { user_id: "user_123", "events.type": "video_play" },
3  { "events.$": 1 }
4);

Find Users Who Completed a Quiz in Last 24 Hours

javascriptCopy
1db.user_activity_logs.find({
2  "events.type": "quiz_submit",
3  "events.timestamp": { $gte: new Date(Date.now() - 24 * 60 * 60 * 1000) }
4});

Aggregate: Daily Active Users

javascriptCopy
1db.user_activity_logs.aggregate([
2  { $unwind: "$events" },
3  {
4    $group: {
5      _id: {
6        date: { $dateToString: { format: "%Y-%m-%d", date: "$events.timestamp" } },
7        user_id: "$user_id"
8      }
9    }
10  },
11  {
12    $group: {
13      _id: "$_id.date",
14      daily_active_users: { $sum: 1 }
15    }
16  },
17  { $sort: { _id: -1 } }
18]);

📝 Part 4: Collection 3 — user_notes

Purpose

Students highlight text and add personal notes while learning. Flexible, user-generated content that varies in structure.

Schema Design

javascriptCopy
1{
2  "_id": "note_001",
3  "user_id": "user_123",
4  "course_id": "course_001",
5  "lesson_id": "les_002",
6  "note_text": "Remember: async functions always return a Promise!",
7  "highlighted_text": "async function fetchData()",
8  "timestamp": "2026-08-13T11:45:00Z",
9  "color": "yellow",
10  "tags": ["important", "exam-prep"],
11  "is_public": false
12}

MongoDB Commands

Create a Note

javascriptCopy
1db.user_notes.insertOne({
2  user_id: "user_123",
3  course_id: "course_001",
4  lesson_id: "les_002",
5  note_text: "Remember: async functions always return a Promise!",
6  highlighted_text: "async function fetchData()",
7  timestamp: new Date(),
8  color: "yellow",
9  tags: ["important"],
10  is_public: false
11});

Get All Notes for a Lesson

javascriptCopy
1db.user_notes.find({
2  user_id: "user_123",
3  lesson_id: "les_002"
4}).sort({ timestamp: -1 });

Update Note Color

javascriptCopy
1db.user_notes.updateOne(
2  { _id: "note_001" },
3  { $set: { color: "green", tags: ["important", "reviewed"] } }
4);

Search Notes by Content

javascriptCopy
1db.user_notes.createIndex({ note_text: "text", highlighted_text: "text" });
2
3db.user_notes.find({
4  $text: { $search: "Promise async" },
5  user_id: "user_123"
6});

Aggregate: Most Noted Lessons

javascriptCopy
1db.user_notes.aggregate([
2  { $group: { _id: "$lesson_id", note_count: { $sum: 1 } } },
3  { $sort: { note_count: -1 } },
4  { $limit: 10 }
5]);

💬 Part 5: Collection 4 — course_discussions

Purpose

Q&A threads where students ask questions and instructors reply. Nested replies make this perfect for document storage.

Schema Design

javascriptCopy
1{
2  "_id": "thread_001",
3  "course_id": "course_001",
4  "lesson_id": "les_002",
5  "user_id": "user_123",
6  "title": "Confused about Promise.all()",
7  "body": "Can someone explain when to use Promise.all vs Promise.allSettled?",
8  "replies": [
9    {
10      "reply_id": "rep_001",
11      "user_id": "user_456",
12      "body": "Use Promise.all when all promises must succeed. If one fails, everything fails.",
13      "timestamp": "2026-08-13T12:00:00Z",
14      "is_instructor": true,
15      "likes": 5,
16      "liked_by": ["user_789", "user_101"]
17    },
18    {
19      "reply_id": "rep_002",
20      "user_id": "user_789",
21      "body": "Promise.allSettled is safer for independent operations.",
22      "timestamp": "2026-08-13T12:15:00Z",
23      "is_instructor": false,
24      "likes": 2,
25      "liked_by": ["user_123"]
26    }
27  ],
28  "tags": ["javascript", "promises"],
29  "is_resolved": false,
30  "views": 42,
31  "created_at": "2026-08-13T11:50:00Z"
32}

MongoDB Commands

Create Discussion Thread

javascriptCopy
1db.course_discussions.insertOne({
2  course_id: "course_001",
3  lesson_id: "les_002",
4  user_id: "user_123",
5  title: "Confused about Promise.all()",
6  body: "Can someone explain when to use Promise.all vs Promise.allSettled?",
7  replies: [],
8  tags: ["javascript", "promises"],
9  is_resolved: false,
10  views: 0,
11  created_at: new Date()
12});

Add Reply to Thread

javascriptCopy
1db.course_discussions.updateOne(
2  { _id: "thread_001" },
3  {
4    $push: {
5      replies: {
6        reply_id: "rep_001",
7        user_id: "user_456",
8        body: "Use Promise.all when all promises must succeed.",
9        timestamp: new Date(),
10        is_instructor: true,
11        likes: 0,
12        liked_by: []
13      }
14    },
15    $inc: { views: 1 }
16  }
17);

Like a Reply (Atomic)

javascriptCopy
1db.course_discussions.updateOne(
2  { _id: "thread_001", "replies.reply_id": "rep_001" },
3  {
4    $inc: { "replies.$.likes": 1 },
5    $push: { "replies.$.liked_by": "user_789" }
6  }
7);

Find Unresolved Questions

javascriptCopy
1db.course_discussions.find({
2  course_id: "course_001",
3  is_resolved: false
4}).sort({ created_at: -1 });

Find Threads by Tag

javascriptCopy
1db.course_discussions.find({ tags: "javascript" });

Mark Thread as Resolved

javascriptCopy
1db.course_discussions.updateOne(
2  { _id: "thread_001" },
3  { $set: { is_resolved: true } }
4);

Aggregate: Instructor Response Rate

javascriptCopy
1db.course_discussions.aggregate([
2  { $match: { course_id: "course_001" } },
3  {
4    $project: {
5      has_instructor_reply: {
6        $in: [true, "$replies.is_instructor"]
7      }
8    }
9  },
10  {
11    $group: {
12      _id: null,
13      total_threads: { $sum: 1 },
14      instructor_replied: {
15        $sum: { $cond: ["$has_instructor_reply", 1, 0] }
16      }
17    }
18  },
19  {
20    $project: {
21      response_rate: {
22        $multiply: [
23          { $divide: ["$instructor_replied", "$total_threads"] },
24          100
25        ]
26      }
27    }
28  }
29]);

⚡ Part 6: Indexes for Performance

javascriptCopy
1// courses_content indexes
2db.courses_content.createIndex({ slug: 1 }, { unique: true });
3db.courses_content.createIndex({ "metadata.tags": 1 });
4db.courses_content.createIndex({ "modules.lessons.lesson_id": 1 });
5db.courses_content.createIndex({ "metadata.category": 1, "metadata.level": 1 });
6
7// user_activity_logs indexes
8db.user_activity_logs.createIndex({ user_id: 1, course_id: 1 });
9db.user_activity_logs.createIndex({ "events.timestamp": -1 });
10db.user_activity_logs.createIndex({ "events.lesson_id": 1, "events.type": 1 });
11
12// user_notes indexes
13db.user_notes.createIndex({ user_id: 1, lesson_id: 1 });
14db.user_notes.createIndex({ timestamp: -1 });
15db.user_notes.createIndex({ note_text: "text" });
16
17// course_discussions indexes
18db.course_discussions.createIndex({ course_id: 1, lesson_id: 1 });
19db.course_discussions.createIndex({ tags: 1 });
20db.course_discussions.createIndex({ is_resolved: 1, created_at: -1 });
21db.course_discussions.createIndex({ "replies.user_id": 1 });

🏗️ Part 7: Best Practices

🧪 Part 8: Hands-On Exercises

Exercise 1: Build a Course Document

Create a MongoDB document for a "Python Basics" course with:

• 2 modules
• 2 lessons per module (1 video, 1 quiz)
• Free preview on first lesson

Exercise 2: Activity Tracking

Insert a log showing a user who:

• Played a video at 0:00
• Paused at 5:30
• Completed a quiz with score 90

Exercise 3: Discussion Analytics

Write an aggregation that finds the top 5 most active discussion threads by reply count.

📊 Quick Reference: Most Used Commands

javascriptCopy
1// Get full course curriculum
2db.courses_content.findOne({ slug: "fullstack-web-dev" });
3
4// Get student recent activity
5db.user_activity_logs.find(
6  { user_id: "user_123" },
7  { events: { $slice: -10 } }
8);
9
10// Get lesson notes
11db.user_notes.find({ user_id: "user_123", lesson_id: "les_002" });
12
13// Get unresolved questions for instructor
14db.course_discussions.find({
15  course_id: "course_001",
16  is_resolved: false,
17  "replies.is_instructor": { $ne: true }
18});

This NoSQL design gives you flexible, scalable content storage that adapts to any course structure while keeping queries fast and commands simple.