🔗 Link: https://awsrestart.instructure.com/courses/1632/modules/items/886879

Lab Overview

Scenario

Inventory management is one of the tasks that you have been asked to support with your database from your client, the Canal House Books store. You have been provided an inventory report that can be added to the SQL database. Using this report, identify items that need to be ordered or removed from stock.

Objectives

In this lab, you will:

• Import the inventory report table
• Find items that are out of stock to reorder them from the inventory table
• Locate items that are not selling to remove them from the inventory table

Exercise 1: Import Inventory CSV

The store has kept track of books sold over the past few years and wants to use this to inform inventory business decisions quickly. Import the csv file into a new table in your database, pub1.

TODO

Insert the inventory report from work/InventoryReport.csv into the database using the table name inventory.

Steps

1. Ensure that you are logged into the workspace and have MySQL Workbench open and are connected to the pub1 database.

   

2. Right click the Tables tab in pub1 and select Table Data Import Wizard.

   

3. Click Browse and browse to the path to select your work/InventoryReport.csv file to import. Click Open; then click Next.

   

4. Next to Create new table, ensure pub1 is selected. Type inventory into the name field and click Next.