CIS 2161 - Structured Query Language

Institution:

Central Georgia Technical College

Subject:

Description:

Prerequisite: SCT 100, CIS 106, CIS 105, and an operating systems course A course designed to allow the student to solve common database retrieval problems through the use of the SQL Language that supports common databases such as SQL/Server, ORACLE, DB2, ACCESS and other database systems. Topics include: Understanding database vocabulary, understanding object and relational database concept understanding and implementing SQL statements that retrieve, insert, update and delete data in a database, ability to implement aggregate and group SQL functions, create, edit and drop database tables, query data from multiple databases, design queries and sub queries, develop an understanding of union, and join operations, understand how to execute and implement database triggers.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.centralgatech.edu

Phone Number:

(478) 757-3400

Regional Accreditation:

Southern Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.