CMSC 2201 - Database Modeling II

Institution:

St. Cloud Technical and Community College

Subject:

Description:

Database Modeling II is an extension of Database Modeling I. SQL server installation and configuration, configuring SQL Server instances, databases and security; configuring linked servers; database mirroring; log shipping; database snapshots as well as data customer support. Data retrieval, manipulation, management thru XML, exceptions are covered. Service Broker components are implemented as well as importing and exporting data to files. Replication management is introduced. Database maintenance, management, backup and restoration are covered. Monitoring and troubleshooting SQL Server performance and gathering performance and optimization data by using DMV's are the new pieces that are introduced in this course along with continuing database creation and maintaining databases from Database Modeling I. Prerequisite(s): CMSC1203, CMSC1216 (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.