SQL Server 2005 Administration

5 day course

SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you will learn about the administrative features that are available in SQL Server. This course also examines other SQL Server 2005 essential application, support, and maintenance topics – features you can use for high-availability, stability, reliability, and scalability of databases.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• A Tour of SQL Server 2005
• Installing SQL Server 2005
• Designing and Creating a Database
• Data Selection Queries
• Modifying Data
• SQL Server Management Studio
• Understanding and Implementing Security
• Analyzing and Tuning Performance
• Automating Administrative Tasks
• Programming Replication
• Failover Clustering
• Database Mirroring
• Log Shipping
• Peer-to-Peer Replication
• Monitoring and Troubleshooting
• Implementing Service Brokers