---
format:
    revealjs:
        theme: simple
        chalkboard: true
        auto-stretch: false
---

## DBMS Tools

Keith VanderLinden<br>
Calvin University

## Demos

- DBMS vs flat files (CSV, JSON, etc.)
- MongoDB Atlas
- MongoDB Queries
    - CRUD
    - Aggregation
    - Joins using `$lookup`

::: {.notes}
1. DBMS vs flat files (CSV, JSON, etc.)
    - The SLO dataset actually is de-normalized because it repeats tweet author self-descriptions in each tweet.
2. MongoDB Atlas
    - Show the load module.
3. MongoDB Queries
    - CRUD
    - Aggregation
    - Joins using $lookup
    - The goal here is not to make ourselves MongoDB gurus, but rather to give us a taste of noSQL and some confidence that we could pick it up as needed.
:::
4. Run the SLO queries on Codespaces.
    - Set the MongoDB connection values as GitHub secrets.
    - Whitelist the Codespaces IP address in MongoDB Atlas.
    - Run the read queries.

## Snapshot

*See the live demo.*

![](images/mongodb-demo.png)

::: {.notes}
Link a snapshot of the final state of the demo here.
:::
