CIS 245 - Database Programming

Institution:

Harrisburg Area Community College-Harrisburg

Subject:

Computer Information Systems

Description:

Covers Structured Query Language (SQL) commands to manage a database. This course allows students to create, store, retrieve, and maintain database objects using Data Definition Language (DDL) and Data Manipulation Language (DML) and establish access and security to database objects using Data Control Language (DCL). In addition, students learn to retrieve data using Joins, Sub- queries, Scalar and Vector statements, and write SQL code to manage distributed data and transactions. Prerequisite: CIS 140 or WEB 143 with a grade of C or higher; or permission of the Instructor.

Credits:

3.00

Credit Hours:

Prerequisites:

CIS 140 or CIS 241 or WEB 143

Corequisites:

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.hacc.edu

Phone Number:

(717) 780-2300

Regional Accreditation:

Middle States 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.