DEPARTMENT OF TECHNOLOGY
COMPUTER INFORMATION SYSTEMS 3183
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.
All hands on work with SQL will be compiled and executed in the CIS Lab.
Patrick, John J.