Courses » Microsoft Courses » Microsoft SQL Server 2005 Online Training

 

Microsoft SQL Server 2005 Online Training

 

MS SQL Server 2005 Course Content

Understanding and Implementing Security

• Security Overview
• Authentication
• Authorization
• Permissions
• Data Encryption
• Security Epilog

Analyzing and Tuning Performance

• Evaluating Performance
• Monitoring with SQL Server Profiler
• Tuning Queries
• Indexes and Partitions
• Using the Database Engine Tuning Advisor
• Understanding SQL Server Performance Problems

Automating Administrative Tasks

• SQL Server Agent
• Maintenance Plans
• SQL Management Objects (SMO)

Programming Replication

• Overview of SQL Server Replication
• Replication Programming Interfaces
• Configuring Replication
• Synchronizing Data

Disaster Recovery

• Planning a Backup Strategy
• Backing Up Databases
• Scheduling Your Backups
• Verifying Backup Media
• Restoring Databases
• Using Database Snapshots

Failover Clustering

• High Availability Overview
• SQL Server 2005 Failover Cluster
• Preparing a Server Cluster
• Creating a New Cluster
• Installing SQL Server 2005 Failover
• Adding Additional SQL Server Nodes

Database Mirroring

• Understanding Mirroring
• Setting Up Database Mirroring
• Monitoring Database Mirroring

Log Shipping

• Overview
• Configuring Log Shipping
• Monitoring Log Shipping Jobs
• Using Transact-SQL

Peer-to-Peer Replication

• Overview
• Configuring the Distributor
• Creating the Publisher
• Configuring Peer-to-Peer Subscribers
• Configuring Peer-to-Peer Topology

Monitoring & Troubleshooting

• Diagnosing and Resolving Database Server Errors
• Set Up Alerts Using SQL Server Agent
• Monitoring SQL Server Agent Job History
• Gathering Performance Data and Optimization using DMV

Implementing Service Brokers

• Understanding Service Brokers
• Designing Service Broker Applications
• Programming Service Broker Applications