CIS 205 - Database Management Systems

Institution:

Community College of Philadelphia

Subject:

Computer Info Sys

Description:

As an introduction to relational database management systems and database programming for computers using modern enterprise database servers, this course covers fundamental concepts in database design, database modeling techniques, and Structured Query Language (SQL) programming techniques wile providing hands-on exercises in which students apply these concepts and techniques to real-world problems. The course introduces the SQL, Data Manipulation Langauge (DML), Data Definition Language (DDL), Data Control Language (DCL), and store procedure programming. It also includes concepts for building frameworks for high performance web applications in multi-tier environments. Students will implement a relational database from initial requirements and conceptual design (ER Diagram) to the physical database in a modern enterprise relational database management system (RDMS).

Credits:

4.00

Credit Hours:

Prerequisites:

CIS 103, CSCI 112 (Prerequisite or Corequisite), or CSCI 118

Corequisites:

CSCI 112 (Prerequisite or Corequisite)

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

3-2-4

Additional Information:

Historical Version(s):

Institution Website:

www.ccp.edu

Phone Number:

(215) 751-8000

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.