CMSC 1216 - Database Modeling I

Institution:

St. Cloud Technical and Community College

Subject:

Description:

Databases are an integral part of computer systems. This course is the first of two database modeling courses. It covers RDBMS basics, introduction to SQL Server 2005, installation of SQL 2005, create databases through scripts, T-SQL statements, joins, creating and altering tables, add/modify/delete data in tables, constraints, queries, database normalization, indexes, views, writing scripts and batches, stored procedures and user defined functions. Prerequisite(s): CMSC1203 (3 C: 2 lect/pres, 1 lab, 0 other)

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lab

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.sctcc.edu

Phone Number:

(320) 308-5000

Regional Accreditation:

North Central 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.