IT Online Training and Placements in USA.

Microsoft Online Training

MS Exchange Server 2003, BizTalk Server, MS Office Sharepoint 2007

 

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