MongoDB Shell Commands Workbook for Bookstore Inventory & Customer Sales Management
MongoDB Shell Commands Workbook for Bookstore Inventory & Customer Sales Management
Learning Outcomes:
This Training workbook for MONGO DB focuses on MONGO DB SHell commands to create a database and add,remove, delete and modify data records, using the theme of a book store: tracking inventory and customer sales
Introduction
Welcome to the MongoDB Shell Commands Workbook for Bookstore Inventory & Customer Sales Management. This workbook is designed to guide you through the process of creating a MongoDB database, adding, removing, deleting, and modifying data records using MongoDB shell commands. Our theme for this workbook is a bookstore. We will be tracking inventory and customer sales.
Prerequisites
Before we begin, make sure you have the following installed on your system:
Table of Contents
To start the MongoDB server, open a command prompt or terminal and run the following command:
Copy codemongod
Open another command prompt or terminal and run the following command to start the MongoDB shell:
Copy codemongo
To create a database for the bookstore, run the following command in the MongoDB shell:
perlCopy code bookstore
First, let's create a collection called 'inventory'. To insert a new book into the inventory, use the following command:
phpCopy code({,,, price: 9.99, stock: 10});
To query all books in the inventory, use the following command:
luaCopy code();
To find a specific book by ISBN, use the following command (replace '9780316769174' with the ISBN you want to search for):
cssCopy code});
To update the stock of a book in the inventory, use the following command (replace '9780316769174' with the ISBN of the book you want to update, and '5' with the new stock value):
cssCopy code}, {$set: {stock: 5}});
To remove a book from the inventory, use the following command (replace '9780316769174' with the ISBN of the book you want to remove):
cssCopy code});
First, create a collection called 'sales'. To insert a new customer sale, use the following command:
yamlCopy codedb.sales.insertOne({,Date(), items: [ {, quantity: 1 }, totalPrice: 9.99});
To query all customer sales, use the following command:
();
To find sales by a specific customer, use the following command (replace '1' with the customer ID you want to search for):
cssCopy codedb.sales.find({customerId: 1});
To update a customer's sale record, first, find the sale by its _id. For example, if the _id is ObjectId("1234567890abcdef12345678"), use the following command to update the totalPrice to a new value (replace '20.99' with the new total price value):
)}, {$set: {totalPrice: 20.99}});
To update the quantity of a book in a customer's sale record, use the following command (replace '9780316769174' with the ISBN of the book you want to update, and '2' with the new quantity value):
(},: 2}});
To remove a customer's sale record, first, find the sale by its _id. For example, if the _id is ObjectId("1234567890abcdef12345678"), use the following command to remove the sale:
)});
Conclusion
Congratulations! You have successfully completed the MongoDB Shell Commands Workbook for Bookstore Inventory & Customer Sales Management. You now have a solid understanding of how to create a MongoDB database, add, remove, delete, and modify data records using MongoDB shell commands. You can now use these skills to manage inventory and customer sales data in a real-world bookstore application.
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.