CIS 287SQL SERVER

Bishop State Community College · 3 credits

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 students 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 used 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.

Recent sections

Spring 2027 · 1 section

Jan 13 – May 12

SectionDays & timeLocationInstructor
1Class #20070Tu Th · 11:00 AM – 12:15 PMBusiness Technology Center 215Cecil Turk