Work with an existing database to make specific changes to the existing data, and create formulas using queries.

Competency

Explain how enterprise architecture principles can be used in a small to medium-sized business.

NOTE - This course requires the creations of a single Bitnami server for several deliverables. If this has not been completed, please refer to the "Prerequisite for Deliverables 3-7" page earlier in the Course Project Section.

Scenario

You work as a developer for Solutions Inc. Your client, Universal Widgets, is planning to implement a cloud-based solution for their IoT (Internet of Things) connected devices. These devices are designed to monitor air quality in a home for the homeowner's heating and air system. These devices also are able to detect the carbon dioxide levels, presence of smoke, and notify homeowner's when to change the air filters.

As a new member of the development team for this project, it is important that you create the necessary queries to familiarize yourself with the AdventureWorks database, which has many similarities to the development and production databases of Universal Widgets. Before working directly with the Universal Widgets environments, the development team has tasked you with creating a few sample queries to become familiar with the process using a testing environment.

Queries are a fundamental aspect of any enterprise architected solution, as having the ability to retrieve, update, and modify data is critical for any sized organization. Small to medium sized businesses benefit from this capability as they do not need to have personnel on staff to make these manual changes and push this responsibility to the customer, making these solutions a self-service solution.

Instructions

Using the PHPMyAdmin tool and your cloud-based server, create a Microsoft Word Document using the following bullets for each query:

• Write the code using the PHPMyAdmin toolthat will create the query and display the results.
  • Paste a copy of the code in your Word document
  • Paste a screenshot of the result in your Word document

Queries to be Developed

• Create a query that will display the order information for OrderID 43692
• Update the data to double the quantity of ProductID 761
• Create a query that will provide a Sub-Total for OrderID 43962