Table of Contents

1. Challenge

   Log into the MySQL Server as `root` and Change to the `corporate` Database

   Login to the MySQL server:

   # mysql -u root -p

   Change to the corporate database:

   mysql> USE corporate;

2. Challenge

   Create a Table Named `products` in the `corporate` Database with the Characteristics Provided in the Instructions

   Create the products table with the following command:

   mysql> CREATE TABLE products (productID INT PRIMARY KEY, productType VARCHAR(50), operatingSystem VARCHAR(50));

3. Challenge

   Create a Table Named `orders** in the `corporate` Database with the Characteristics Provided in the Instructions

   Create the orders table with the following command:

   mysql> CREATE TABLE orders (orderID INT PRIMARY KEY, userName VARCHAR(50) UNIQUE, orderType VARCHAR(255), purchaseDate DATE);

4. Challenge

   Insert Data into the `products` Table According to the Information Provided in the Instructions

   Insert data into the products table with the following command:

   mysql> INSERT INTO products (productID,productType,operatingSystem) VALUES (1,'laptop','ubuntu'),(2,'desktop','windows'),(3,'server','rhel');

5. Challenge

   Insert Data into the `orders` Table According to the Information Provided in the Instructions

   Insert data into the orders table with the following command:

   mysql> INSERT INTO orders (orderID,userName,orderType,purchaseDate) VALUES (1,'aaron','laptop','2018-02-23'),(2,'stosh','desktop','2018-01-25'),(3,'kenny','server','2019-12-10');