DEPARTMENT OF TECHNOLOGY

 SYLLABUS
 COMPUTER INFORMATION SYSTEMS 3183

CATALOG LISTING: 
3183 Structured Query Language, 3 hours credit
An in-depth study of the Structured Query Language (SQL), and relational database processing. Topics will include general application development using basic and advanced select statements.  Other topics include queries involving multiple tables. 
Prerequisite:  CIS 3083 and CIS 2023 or departmental permission.

EXPANDED COURSE DESCRIPTION:
An introductory study of Structured Query Language (SQL).  Study of the different SQL versions for SQL-compliant databases.  This course explains what SQL is and how it is used to manipulate databases.

Upon completion of the course students should: PROGRAM OBJ.
.... Know how to create and fill a database with data I2,I3
.... Know how to create tables and indexes in databases I2,I3
.... Know how to change and delete databases and objects in databases I2,I3
.... Know how to add, change, or remove data in tables in a database I2,I3
.... Know how to select data from tables in databases by creating queries  I2
.... Know how to sort data and discover duplicate records in tables I2,I3
.... Know how to group data and produce reports A3,I2,I3
.... Know how to join tables in databases for data analysis I2,I3
.... Know how to perform data security procedures, improve database performance, and maintain data integrity in the databases A2,I2,I3
....  Know how to solve a business problem with SQL I1

COURSE STRUCTURE:  This is a participatory class -- assignments will be given during EACH class, and students MUST be present to receive points for that day. 

LAB EQUIPMENT
All hands on work with SQL will be compiled and executed in the CIS Lab.

TEXT
Patrick, John J.