1. Installing and Configuring SQL Server 2008
Install SQL Server 2008 and related services
Configure SQL Server instances
Configure SQL Server services
Configure additional SQL Server components
Implement database mail
Configure full-text indexing
2. Maintaining SQL Server Instances
Manage SQL Server Agent jobs
Manage SQL Server Agent alerts
Manage SQL Server Agent operators
Implement the declarative management framework (DMF)
Back up a SQL Server environment
3. Managing SQL Server Security
Manage logins and server roles
Manage users and database roles
Manage SQL Server instance permissions
Manage database permissions
Manage schema permissions and object permissions
Audit SQL Server instances
Manage transparent data encryption
Configure surface area
4. Maintaining a SQL Server Database
Back up databases
Restore databases
Manage and configure databases
Manage database snapshots
Maintain database integrity
Maintain a database by using maintenance plans
5. Performing Data Management Tasks
Import and export data
Manage data partitions
Implement data compression
Maintain indexes
Manage collations
6. Monitoring and Troubleshooting SQL Server
Identify SQL Server service problems
Identify concurrency problems
Identify SQL Agent job execution problems
Locate error information
7. Optimizing SQL Server Performance
Implement Resource Governor
Use the Database Engine Tuning Advisor
Collect trace data by using SQL Server Profiler
Collect performance data by using Dynamic Management Views (DMVs)
Collect performance data by using System Monitor
Use Performance Studio
8. Implementing High Availability
Implement database mirroring
Implement a SQL Server clustered instance
Implement log shipping
Implement replication
