demonstrating advanced query operations – 20210627f

For this assignment, we will be demonstrating advanced query operations. Advanced queries will allow you to analyze data in a more programmatic fashion at the database layer. Since the key-value structure of a NoSQL database closely resembles the object-oriented data structures of many programming languages, this will enhance the ease and portability of MongoDB queries. The aggregation pipeline facility of MongoDB equips us with a set of operators to enable limited set theory operations (grouping, intersections, and so on) for documents within the same collection. After completing the textbook reading and reviewing the module resources, complete the following tasks using the MongoDB shell. Requirements: Guidelines for Submission Your assignment must be submitted as a Microsoft Word document (or equivalent) with the appropriate screenshots. | _____________________Order any type of Service We Provide We are the best assignment service that can satisfy student’s demands in different scientific fields. We perform tasks of any kind. Our specialists provide diverse custom assignment writing services to students from all over the world every day. You can contact us for assistance with: • Essays of any type (application, scholarship, argumentative, personal, informative, persuasive, compare and contrast, narrative, analytical, cause and effect, critical, process, descriptive, expository essays); • Homework, • Assignments, • Reviews of all types (for a book, an article, or a film), • Reports, • Annotated bibliography, • Projects, • Thesis, • Term papers, • Presentations, • Lab works, • Research papers, • Speeches, • Critical thinking, • Capstone projects; • plan; • Coursework’s; • Dissertations. The list is far from complete! Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Using the mongoimport tool, create the database “companies” by loading the documents found in the “companies.json” file into the “research” collection. This file is located in the “/usr/local/datasets/” directory in Apporto. Verify your load by issuing the following queries:
db.research.find({“name” : “AdventNet”})
db.research.find({“founded_year” : 1996},{“name” : 1}).limit(10)

Provide screenshots of your statements and the results as evidence. db.research.find({“name” : “AdventNet”}) db.research.find({“founded_year” : 1996},{“name” : 1}).limit(10) Perform the following tasks using MongoDB queries:
List only the first 20 names of companies founded after the year 2010, ordered alphabetically.
List only the first 20 names of companies with offices in either California or Texas, ordered by the number of employees and sorted largest to smallest.

Provide screenshots of your statements and the results as evidence. List only the first 20 names of companies founded after the year 2010, ordered alphabetically. List only the first 20 names of companies with offices in either California or Texas, ordered by the number of employees and sorted largest to smallest. Design and implement a MongoDB aggregation pipeline to show the total number of employees by state for all companies that have offices in the United States.

Provide screenshots of your statements and the results as evidence Using the mongoimport tool, create the database “companies” by loading the documents found in the “companies.json” file into the “research” collection. This file is located in the “/usr/local/datasets/” directory in Apporto. Verify your load by issuing the following queries:
db.research.find({“name” : “AdventNet”})
db.research.find({“founded_year” : 1996},{“name” : 1}).limit(10)

Provide screenshots of your statements and the results as evidence. db.research.find({“name” : “AdventNet”})
db.research.find({“founded_year” : 1996},{“name” : 1}).limit(10) Perform the following tasks using MongoDB queries:
List only the first 20 names of companies founded after the year 2010, ordered alphabetically.
List only the first 20 names of companies with offices in either California or Texas, ordered by the number of employees and sorted largest to smallest.

Provide screenshots of your statements and the results as evidence. List only the first 20 names of companies founded after the year 2010, ordered alphabetically.
List only the first 20 names of companies with offices in either California or Texas, ordered by the number of employees and sorted largest to smallest. Design and implement a MongoDB aggregation pipeline to show the total number of employees by state for all companies that have offices in the United States.

Provide screenshots of your statements and the results as evidence