CIS 287SQL Server

Catalog

This course will provide students with the technical skill required to install, configure, administer, and troubleshoot SQL Server client/server database management system. At the completion of this series, student will be able to: identify the features of SQL Server and the responsibilities and challenges in system administration; identify the benefits of integrating SQL Server and setup clients for SQL Server, install and configure SQL Server, manage data storage using database devices and partition data using segments manage the user accounts; manage user permissions; identify the various task scheduling and alerting abilities of SQL Executive; identify the concepts uses in replication and implement replication of data between two SQL Services; identify the types of backup and create backup devices; identify the factors effecting SQL Server performance and the need for monitoring and tuning; locate and troubleshoot problems that occur on the SQL Server. Prerequisite: CIS 117 Database Management Software. Code: C - Potential Area V transfer courses that are subject to approval by respective receiving institutions.