SQL Server 2008 Administration

Ø Overview of SQL 2008 features

Ø Installing SQL Server 2008

Ø Upgrading SQL Server 2005 to 2008

Ø Surface Area Configuration

Ø SQL Server Management Technologies

Ø Database Creation

Ø Database Maintenance

Ø Database Snapshots

Ø Data & Index Partitioning

Ø Working with flat files (Import/Export)

Ø Backup & Restore

Ø Security

Ø Automating tasks ( Jobs /Alerts )

Ø Replication

Ø Server Configuration

Ø DBCC commands

Ø Monitoring and Performance Tuning

Ø High Availability (Log Shipping & Database Mirroring)