Searching Topics for intellishell
Exercise 4: Running an aggregate statement against the target collection
In this exercise, you’ll use IntelliShell to run a simple aggregate statement against the customers_merged collection that you created in the previous exercise. To run the aggregate statement In the Connection Tree, expand the sales database node and Collections node, if necessary. Right-click the customers_merged collection node, and then click Open IntelliShell. Studio 3T adds […]
Lesson 3, Exercise: Connecting to MongoDB via Studio 3T
In this exercise, you’ll learn how to connect to your local MongoDB instance or to the MongoDB Atlas cluster you set up in Configuring MongoDB Atlas. You’ll then test the connection by creating and querying a simple collection. To connect to MongoDB 1. Launch Studio 3T if it’s not running. 2. On the Studio 3T […]
Exercise 2: Exporting a collection as a .csv file for use by a third-party tool
In this exercise, you’ll use IntelliShell to run an aggregate statement that will output the results to a new collection. You’ll then export the collection to a .csv file, open the file in Microsoft Excel, and save it as an .xlsx file, which ensures that all visualization features are preserved when saving the file. To […]
Lesson 2: The MongoDB find method
The MongoDB find method provides the foundation for performing basic queries against a MongoDB database. The following syntax shows the elements you must include when calling the find method, along with several optional elements, which are enclosed in brackets: db.collection.find([{query}] [,{projection}])[.method]; To invoke the find method, you start by specifying the db object, which points […]
Exercise 4: Adding processing options to the aggregation
In this exercise, you’ll add two processing options to the aggregate statement after the pipeline. Processing options make it possible to control how the aggregation is executed. To add processing options to the aggregation On the IntelliShell tab, ensure that the aggregate statement you updated in the previous exercise is still entered at the command […]
Lesson 7, Exercise 2: Querying a MongoDB view
In this exercise, you’ll use several Studio 3T tools to query the package_totals view you created in the previous exercise. Each query will return the same rows, although not necessarily the same fields. This will give you a sense of the different methods you can use to access data through a view, while demonstrating how […]
Exercise 3: Visualizing collection data in MongoDB Charts
In this exercise, you’ll use IntelliShell to run an aggregate statement that will output the results to a new collection. The statement will remove some of the customers’ personal information, such as their names, email addresses, and dates of birth. You’ll then use this collection in MongoDB Charts to create a column chart based on […]
Lesson 5, Exercise 3: Using Visual Query Builder to query embedded documents
In this exercise, you’ll use Visual Query Builder to build and run a query that retrieves documents from the customers collection. The query will return the documents for customers who have traveled to Poland. To build the query in Visual Query Builder 1. In the Studio 3T Connection Tree, expand the sales database node and double-click […]
Exercise 3: Sorting the documents in the aggregation pipeline
In this exercise, you’ll add the third and final stage to the pipeline. The stage is based on the $sort aggregate operator, which lets you sort the documents in the pipeline, based on one or more fields. To sort the documents in the aggregation pipeline On the IntelliShell tab, ensure that the aggregate statement you […]
Exercise 2: Grouping the documents in the aggregation pipeline
In this exercise, you’ll add the second stage to the pipeline. This stage is based on the $group aggregate operator, which lets you group the documents in the pipeline based on a specific field. To group the documents in the aggregation pipeline On the IntelliShell tab, ensure that the aggregate statement you created in the […]