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.
Prerequisites
CIS-117 OR Permission of Instructor