SQL Server 2005: Administering & Configuring

Outline Overview
 
Request Training Course Description
SQL Server 2005: Administering & Configuring
Course Duration
5 days
Audience
Systems Administrators
Prerequisites
General experience using administering database systems technologies
Objectives
Outlines
  1. Installing SQL Server 2005
  2. Configuring SQL Server 2005
  3. Creating Tables, Constraints, and User-Defined Types
  4. Creating Indexes
  5. Working with Transact-SQL
  6. Creating Partitions
  7. Implementing Views
  8. Introduction to XML
  9. Working with Flat Files (BCP and BULK INSERT)
  10. Backing Up, Restoring, and Moving a Database
  11. Using Transact-SQL to Manage Databases
  12. Creating Functions, Stored Procedures, and Triggers
  13. Working with SQL Server Agent Jobs
  14. Monitoring and Troubleshooting SQL Server Performance
  15. Managing Database Snapshots
  16. Implementing Database Mirroring
  17. Implementing Log Shipping
  18. Managing Replication
  19. Creating Full-Text Catalogs
  20. Working with Service Broker
 
s