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
+1 (415)-873 0245