CIS287 — SQL SERVER 3 cr
hrs. 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 se - ries, students will be able to: identify the features of SQL Server and the responsibilities and challeng- es 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 imple - ment replication of data between two SQL Services; identify the types of backup and create backup de - vices; identify the factors effecting SQL Server per - formance and the need for monitoring and tuning; locate and troubleshoot problems that occur on the SQL Server. Prerequisite: None. Code C. Offered: ONL.