ITNW 2352 - Administering SQL Server

Institution:

McLennan Community College

Subject:

Description:

Develops skills in the installation, configuration, administration, and troubleshooting of SQL Servers client/server database management system version. Students will describe SQL Server architecture; plan for a SQL Server installation; install SQL Server and configure SQL Server; manage files and databases; choose a login security method; and configure login security. Course also includes the planning and implementation of database permissions; backing up databases and restoring databases; automating administrative tasks using SQL Server Agent; creating custom administrative tools; transferring and migrating data into databases; monitoring SQL Server performance; and replicating data from one SQL Server to another. Prerequisite: ITSC 1305 and a networking course or experience. Semester Hours 3 (2 lec/2 lab)

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.mclennan.edu

Phone Number:

(254) 299-8622

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.