Inhoud van de opleiding:

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

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

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

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

Performing Data Management Tasks

Import and export data
Manage data partitions
Implement data compression
Maintain indexes
Manage collations

Monitoring and Troubleshooting SQL Server

Identify SQL Server service problems
Identify concurrency problems
Identify SQL Agent job execution problems
Locate error information

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

Implementing High Availability

Implement database mirroring
Implement a SQL Server clustered instance
Implement log shipping
Implement replication