Installing and Administering( SQL Server 2005) 070-431

Install SQL Server 2005.
Configure SQL Server 2005 instances and databases.
Configure SQL Server security.
Configure linked servers by using SQL Server Management Studio (SSMS).
Implement database mirroring.
Implement log shipping.
Manage database snapshots.
Retrieve data to support ad hoc and recurring queries.
Manipulate relational data.
Manage XML data.
Implement an HTTP endpoint.
Implement Service Broker components.
Import and export data from a file.
Manage replication.
Configure a publisher, a distributor, and a subscriber.
Implement and maintain SQL Server Agent jobs.
Manage databases by using Transact-SQL.
Back up a database.
Restore a database.
Move a database between servers.
Gather performance and optimization data by using the SQL Server Profiler.
Gather performance and optimization data by using the Database Engine Tuning Advisor.
Monitor and resolve blocks and deadlocks.
Diagnose and resolve database server errors.
Monitor SQL Server Agent job history.
Gather performance and optimization data by using DMVs.

Facilities: 1.24 Hrs Lab with Internet Facility 2.Students can do Lab till they pass Online Examination without any extra cost.

Batch Timings:7-9am/9-11am/11-1pm/2-4pm/4-6pm/ 6 - 8 pm / Sat & Sun Only / Sunday Only.