MongoDB Installation, Queries Practice Set | Hire MongoDB Expert


Create a collection names "Contrib_data" using Contrib_data.csv file in canvas under a MongoDB database named assign.

1. What is the count of records where the transaction_amt is less than $10?

2. Add a new field named "donar_cat" to the collection "Contrib_data".

donar_cat field should have a value of "big_fish" if the transaction_amt is greater than or equal to $500 and "small fish" if transaction_amt is less than $500. Print out total amount for each donar_cat as final output.

3. Give the top 5 cmte_received by transaction amount.

4. Give the top 5 cmte_received by transaction amount that candidate 'BACHMANN, MICHELE' gave money to.


First go to the MongoDB official website:

Click Try free at right corner.

And after this choose server button. Choose OS, and package MIS and start down load.

Click on downloaded file and then Click next button

Accept term and condition, and then click on next button.

Select Choose type: complete

Click on next

Again Click next

And then after installation is started

After MongoDB installation successfully finish you click Finish button on next window.

Go to the Program files ->MongoDB->bin

Copy the path and goto the command prompt and paste the path as like and press enter

After this type mongod command and press Enter

Server installation started:

Some exception raise regarding path to create data->db inside C directory.

And after run mongod command to run server.

Open Another command promt.

And run again:

cd C:\Program Files\MongoDB\Server\4.0\bin 

press enter

run mongo command.

After this to show all database inside use :

>Show dbs 


Output: it exist default database inside

Admin 0.000GB
Config  0.000GB
Local 0.000GB

Create our database use command as:

>use naveen 

press enter

Switched to db Naveen

>Show dbs


Admin 0.000GB
Config  0.000GB
Local 0.000GB

Not show naveen database because not inserted data so insert data use this command.


( of collection.insert({“keyname”:”value”}))


>db.books.insert({“name”:”mongo book”})           

Press enter and create this collection:


WriteResult({“nInserted” : 1})

To show database use

>show dbs


Admin 0.000GB
Config 0.000GB
Local 0.000GB
Naveen 0.000GB

To list out all the collection use this command

>show collections;

Result: inside the naveen database


Show element inside books collection:



{“_id” : ObjectId(5cd….c1), “name” : “mongo book”}

Close command promt

Again open

Run mongod from anywhere show error internal and external command so need to set environment variable:

C:\users\naveen kumar\mongod 

press enter

Error External and Internal command

Set Environment Variable:

Choose path where django installed (C:\Program Files\MongoDB\Server\4.0\bin) and go to system start window choose system and click Advanced system setting. And then click on Environment Variable.

In system variable box find path double click on it.

Click on new and add the path

C:\Program Files\MongoDB\Server\4.0\bin

Now you can run anywhere by cmd like:

C:\users\naveen kumar\mongodb 

press enter

Import csv file into MangoDB

Step 1