CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 58

www.cis336study.com

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 EDUPEAPP 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;
Select unit_price as Retail_Price from items;