MongoDB Laboratory BDS456B

2a. Develop a MongoDB query to select certain fields and ignore some fields of the documents from any collection.

2b. Develop a MongoDB query to display the first 5 documents from the results obtained in a. [use of limit and find]

3a. Execute query selectors (comparison selectors, logical selectors ) and list out the results on any collection.

3b. Execute query selectors (Geospatial selectors, Bitwise selectors ) and list out the results on any collection.

4. Create and demonstrate how projection operators ($, $elematch and $slice) would be used in the MondoDB.

5. Execute Aggregation operations ($avg, $min,$max, $push, $addToSet etc.). students encourage to execute several queries to demonstrate various aggregation operators)

6. Execute Aggregation Pipeline and its operations (pipeline must contain $match, $group, $sort, $project, $skip etc. students encourage to execute several queries to demonstrate various aggregation operators)

7a. Find all listings with listing_url, name, address, host_picture_url in the listings And Reviews collection that have a host with a picture url.

7b. Using E-commerce collection write a query to display reviews summary.

8a. Demonstrate creation of different types of indexes on collection (unique, sparse, compound and multikey indexes)

8b. Demonstrate optimization of queries using indexes.

9a. Develop a query to demonstrate Text search using catalog data collection for a given word.

9b. Develop queries to illustrate excluding documents with certain words and phrases.

10. Develop an aggregation pipeline to illustrate Text search on Catalog data collection.