Course Objectives

This course measures your ability to accomplish the technical tasks listed below.
-Installing and Configuring SQL Server 2005
-Implementing High Availability and Disaster Recovery
-Supporting Data Consumers
-Maintaining Databases
-Monitoring and Troubleshooting SQL Server Performance
-Creating and Implementing Database Objects

Prerequisites

None.

Course Benefits

Student will learn how to install and configure SQL Server 2005, create databases and database objects, SQL server security, creating views, partitions, and linked servers, transact-SQL programming, working with constraints, triggers, and stored procedures, backup and restore of SQL server with SQL agent jobs, data redundancy and availability, using the service broker,  XML data support, SQL server performance monitoring and tuning, troubleshooting server and database errors.

Course Duration

40 Hours