In this activity, you are working as a Systems Administrator and have been tasked with querying a MongoDB database.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Connect and Create a New Database
Start the mongo shell from the Bash prompt:
mongo
Once in the interactive mongo shell, create a new database:
use demo;
- Insert Some Data
Insert the data into a new collection in our
demo
database:db.inventory.insertMany([ { id: 0, name: "David", department: "Engineering", expensecode: 200 }, { id: 1, name: "Clay", department: "HR", expensecode: 100 }, { id: 2, name: "Sue", department: "Sales", expensecode: 300 }, { id: 3, name: "Betty", department: "Marketing", expensecode: 400 }, ])
- Query the Data
Query the database for all documents:
db.inventory.find( {} )
Update the department to be HR for the document with a name of Betty, and confirm:
db.inventory.updateOne( { name: "Betty" }, { $set: { department: "HR" } } ) db.inventory.find( { name: "Betty" } )