APPLICATION

PREREQUISITES

TOPICS COVERED

• 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.

• 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

• Implement a table.
• Implement a view.
• Implement triggers.
• Implement functions.
• Implement stored procedures.
• Implement constraints.
• Implement indexes.
• Create user-defined types.
• Implement a full-text search.

Our Students

Aarati Regmi (Ghimire)

• Training:MS SQL Server
• Education: Masters
• College: Tribhuvan University