SQL SERVER 2005 ADMINISTRATION TRAINING IN CHENNAI

SQL Server 2005 Administration Course Content

A Tour of SQL Server 2005

SQL Server 2005 Editions, Components, and Tools

Using SQL Server Management Studio (SSMS)

Working with Tables and Queries

New Transact-SQL Features

Business Intelligence Services

Installing SQL Server 2005

Preparing for Installation

Upgrading an Earlier Version

Installation Steps

Configuring the Server

Designing and Creating a Database

Relational Database Design Principles

Implementing the Design

Data Selection Queries

Understanding Transact-SQL

The SELECT Statement

The WHERE Clause

Using ORDER BY to Sort Data

The GROUP BY Clause

Joining Tables

Modifying Data

Modifying Data

Inserting Data

Updating Data

Deleting Data

Understanding Transaction Isolation

Working with SQL Server Management Studio

Getting Started with SSMS

Exploring the Object Explorer

Working with the Query Editor

Using SQL Server Books Online

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