CIS 336 iLab 4 Introduction to Select, Insert, Update, and Delete Sta CIS 336 iLab 4 Introduction to Select, Insert, Upd

CIS 336 iLab 4 Introduction to Select, Insert, Update,
and Delete Statements (only SQL Command, No output)
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-ilab-4-introduction-to-select,-
insert,-update,-and-delete-statements-(only-sql-command,-no-
output)
CIS336: Lab 4: Introduction to Select, Insert, Update, and Delete Statements
LAB OVERVIEW
Lab 4 will introduce the various aspects of the SQL select statement and the methods of
retrieving data from the database tables. This lab will also introduce the fundamentals of
updating and deleting records. This lab may be completed using either DeVry’sOmnymbus
EDUPE-APP lab environment, or a local copy of the MySQL database running on your own
computer using the OM database tables. The lab will utilize a set of tables that are represented
by the ERD (OM_ERD.docx) and are created and populated by the script file
(create_OM_db.sql). Follow the instructions in the file CreateOMTables.docx to create your
database, tables, and data.
A few IMPORTANT things to note if using EDUPE MySQL:
**There can be NO SPACES in alias names given to a column. For example:
Select unit_price as “Retail Price “ from items; –this does NOT work in EDUPE MySQL.
Any of the following WILL WORK:
Select unit_price as “RetailPrice” from items;
Select unit_price as “Retail_Price” from items;