Exploring Data with MongoDB Atlas

• Click on the View Data button on the dashboard
• Navigate to the collections tab from the Databases panel.
• You can search the collections from the Search Box provided in the interface.
• You can search a collection using a namespace. a namespace is a concatenation of database name and collection name.

For Lab Practice purposes, we will select the zips collection from sample_training database.

Querying through UI

The filter text box lets us specify the conditions for the query. {field : "value"} is the form in which the filter is specified. Suppose we want to access all the documents that has a state field set to NY and city set to ALBANY. The following will be written as the filter and click the apply button

{state: "NY", city: "ALBANY"}

Problem:

In the sample_training.trips collection a person with birth year 1961 took a trip that started at "Howard St & Centre St". What was the end station name for that trip?

Copy and paste your answer from the Atlas UI to the response text box. The station name should be in a single set double quotes, exactly as it is in the Data Explorer.

From the Shell

• Firstly, connect you mongo shell with the atlas cluster
• To connect to all the databases in the entire cluster mongodb+srv://username:password@<Atlas Cluster URI>.mongodb.net/admin
• Let's make sure that all the databases are here show dbs

db.<collection_name>.find(<query>);

• Let's try to reproduce the queries and results we did in the Atlas UI
  • use sample_training
  • show collections
  • db.zips.find({state : "NY"}) The query goes inside the parenthesis
  • At once, the shell will display 20 documents and if more are retrieved then it can be typed to iterate over the remaining documents. It iterates through a cursor. A cursor is a pointer to the result set of the query
  • To count the number of documents retrieved, we can use the count() directive after the query. For example, to retrieve the number of documents from New York, db.zips.find({state: "NY"}).count()
  • To view the result set in a more readable format, we use pretty() directive after the query