CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 58

Examples:
DESCRIBE STUDENT;
SHOW CREATE TABLE STUDENT;
This is the end of Lab 3_____
---------------------------------------------------------------------------------------

CIS 336 iLab 4 Introduction to Select, Insert, Update, and
Delete Statements (only SQL Command, No output)

FOR MORE CLASSES VISIT
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: