CIS 2161 - Structured Query Language

Institution:

Southern Crescent Technical College

Subject:

Description:

(Prerequisite: 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 vocabu lary, understanding object and relational database con cepts, 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, under stand how to execute and implement database triggers.

Credits:

7.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.sctech.edu

Phone Number:

(770) 228-7348

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.