Day 03 NoSQL

NoSQL Data Models: Document, Key-Value, Graph

MongoDB document design, Redis data structures, Neo4j graph patterns — when to abandon relational models and the trade-offs that come with each alternative.

~1 hour Intermediate Hands-on Precision AI Academy

Today's Objective

MongoDB document design, Redis data structures, Neo4j graph patterns — when to abandon relational models and the trade-offs that come with each alternative.

01

What You'll Cover Today

Day 3 of Data Modeling in 5 Days is the midpoint — and often the most rewarding day. The pieces from Day 1 and Day 2 start connecting. Most students have an 'it clicks' moment on Day 3.

ℹ️
Topics today: star schema, facts, SCDs. Each section has code you can copy and run immediately.
02

star schema

Understanding star schema is the core goal of Day 3. The concept is straightforward once you see it in practice — most confusion comes from skipping the mental model and jumping straight to implementation. Start with the model, then write the code.

star schema
# star schema — Working Example
# Study this pattern carefully before writing your own version

class starschemaExample:
    """
    Demonstrates core star schema concepts.
    Replace placeholder values with your real implementation.
    """
    
    def __init__(self, config: dict):
        self.config = config
        self._validate()
    
    def _validate(self):
        required = ['name', 'type']
        for field in required:
            if field not in self.config:
                raise ValueError(f"Missing required field: {field}")
    
    def process(self) -> dict:
        # Core logic goes here
        result = {
            'status': 'success',
            'topic': 'star schema',
            'data': self.config
        }
        return result


# Usage
example = starschemaExample({
    'name': 'my-implementation',
    'type': 'star schema'
})
output = example.process()
print(output)
💡
Key insight: When working with star schema, always start with the simplest possible case that works end-to-end. Complexity is easier to add than simplicity is to recover.
03

facts

facts is the practical application of star schema in real projects. Once you understand the underlying model, facts becomes the natural next step.

💡
Pro tip: When working with facts, always read the official documentation for the exact version you're using. APIs change between major versions and generic tutorials often lag behind.
04

SCDs

SCDs rounds out today's lesson. It connects star schema and facts into a complete picture. You'll use all three concepts together in the exercise below.

05

Common Mistakes on Day 3

📝 Day 3 Exercise
Dimensional Modeling — Hands-On
  1. Set up your environment for today's topic: install required tools and verify the basics work before writing any logic.
  2. Implement a minimal working version of star schema using the code example in this lesson as your starting point.
  3. Extend your implementation to incorporate facts — this is where the two concepts connect.
  4. Test your implementation with both valid and invalid inputs. What happens at the boundaries?
  5. Review your code: is there anything you'd name differently? Any function doing more than one thing? Refactor one thing.

Day 3 Summary

Challenge

Extend today's exercise by adding one feature that wasn't in the instructions. Document what you built in a comment at the top of the file. This habit of going one step further is what separates engineers who grow fast from those who stay stuck.

What's Next

The foundations from today carry directly into Day 4. In the next session the focus shifts to dbt and the Modern Data Stack — building directly on everything covered here.

Day 3 Checkpoint

Before moving on, verify you can answer these without looking:

  • What is the core concept introduced in this lesson, and why does it matter?
  • What are the two or three most common mistakes practitioners make with this topic?
  • Can you explain the key code pattern from this lesson to a colleague in plain language?
  • What would break first if you skipped the safeguards or best practices described here?
  • How does today's topic connect to what comes in Day 4?

Live Bootcamp

Learn this in person — 2 days, 5 cities

Thu–Fri sessions in Denver, Los Angeles, New York, Chicago, and Dallas. $1,490 per seat. June–October 2026.

Reserve Your Seat →
Continue To Day 4
Day 4: NoSQL Patterns