Searching Lessons for intellishell
Running MongoDB Queries on the mongo Shell
IntelliShell is a command-line tool built into Studio 3T that allows writing commands directly against a MongoDB database. It offers the simplicity of the mongo shell, which is what the tool is based on, while adding a number of important features that make it easier to query a database. For example, you can run commands individually, run multiple […]
Building MongoDB find() Queries
A MongoDB database stores data in collections. Each collection contains a set of related documents that are used by one or more applications to carry out their operations. The applications—as well as individuals managing the collections—must be able to query the data as efficiently as possible to ensure that the appropriate information is available whenever […]
Connecting to MongoDB
This section walks you through the process of connecting to your existing MongoDB database, or the MongoDB Atlas cluster you created in Setting Up MongoDB Atlas, via Studio 3T. Studio 3T is available in three editions: Basic, Pro, and Ultimate. Basic has the essential features for working with MongoDB. Pro extends the features to include […]
Querying Arrays Using MongoDB $elemMatch
Documents in a MongoDB database commonly include fields defined with the Array data type. A field configured with this type can contain zero or more elements that together form a list—or array—of values. The values might all be the same data type, or they might be different types. For example, an Array field might contain […]
Querying MongoDB with SQL SELECT Statements
Developers and administrators often come to MongoDB with a background in relational database management systems such as SQL Server or Oracle Database. These systems rely on the Structured Query Language (SQL) for accessing and manipulating data. If you’re one of these people, you’ll be happy to know that Studio 3T includes the SQL Query tool, which […]
Adding Lookup Data to the Aggregation Pipeline
The first two sections of this course walked you through the process of building an aggregate statement that retrieves data from the customers collection in the sales database. In the first section, you used IntelliShell to create the statement and save it to the states_transactions.js file. In the second section, you imported the file into […]
Introducing the Aggregation Editor
In the first section of this course, you were introduced to the mongo shell aggregate method, which enables you to aggregate document data within a specific collection. The section’s exercises demonstrated how to build a basic aggregate statement in IntelliShell, using data from the customers collection in the sales database. In that statement, you filtered […]
Querying Embedded Documents in MongoDB Arrays
In the previous tutorial in this course, you learned how to query MongoDB documents that contain fields defined with the Array data type. An Array field can contain zero or more values (an array) of any supported type, including the Object type, which is used for embedded documents. However, the examples in the last section […]
Building a Basic Aggregation
The first two MongoDB courses—101 and 201—introduced you to the basics of how to aggregate document data in Studio 3T. As you’ll recall, aggregations make it possible to better understand the data and mine valuable information, which can help stakeholders make strategic business decisions. This course expands on those discussions to provide a more complete picture […]
Working With Collections – 2
Counting Collections There’s lots of ways to complete common tasks in the Collections Tab too. Want to know how many documents matched your query? Look just below the results table and you’ll see a Count Documents box. Click that to get a total. Or if you want the count as a result itself, head up […]