Work with an existing database to retrieve, update, and delete data.

Competency

Relate enterprise architecture to software development.

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 software application require input for processing, then can generate through additional software development appropriate output based on the need of the organization.

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 in the PHPMyAdmin tool that 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 all product names from the product table.
• Create an insert query that will add three new products to the product table.
• Create a delete query to remove one the of the products that you previously added from the product table
• Create a query the will display a concatenated results using the ProductNumber, Name, and ListPrice from the product table
• Create a query that will display the all customer names and each customer's associated address information.
• Create an insert query that will add three new customers and their full addresses to the customer and address tables.
• Create a delete query to remove one of the new customers that you previously added.