Microsoft SQL Server: System Administration

This five-day course will show students how to install, configure, administer, and troubleshoot Microsoft SQL Server in a Windows environment.

* Introduction to Microsoft SQL Server
* Installing SQL Server
* Designing and implementing databases
* Creating and managing tables
* Designing and configuring SQL Server security
* Importing and exporting data
* Monitoring SQL Server
* Backing up and Restoring SQL Server databases
* Automating SQL Server administration
* Designing and implementing and managing replication
* Publishing SQL Server data on a Web page

Microsoft SQL Server: System Administration

After this class students will be able to:

Understand the capabilities of Microsoft SQL Server. Identify the requirements for installing SQL Server. Install and troubleshoot SQL Server. Design, create, and manage databases. Create and manage tables. Use Access to connect to an SQL server. Identify the security features of SQL Server. Create and assign login IDs. Implement statement and object permissions. Design a security strategy. Learn about data transfer and bulk transfer. Design a strategy for monitoring SQL Server and use the monitoring tools. Plan and perform a backup; design your backup strategy. Identify methods to restore databases, then restore databases and transaction logs. Recover system databases. Configure SQL Server to send mail. Define SQL operators. Manage jobs and alerts. Design, implement, monitor, maintain, and troubleshoot replication. Create a Web page.

Targeted Student:

System Administration for Microsoft SQL Server.

Prerequisites:

Windows: System Architecture and Network Support, or equivalent knowledge.