Maintaining a SQL Server 2008 Database

Learn more about core maintenance skills using SQLServer 2008.

Info Support course code	MS6231	Price	€ 2.200,00
Supplier (code)	Microsoft (6231)	Length	5 days

Course date by location

Maand	Veenendaal (NL)	Utrecht (NL)	Mechelen (B)	Partner (NL)	Partner (B)
September	27-28-29-30-1
Oktober			18-19-20-21-22
November		15-16-17-18-19	29-30-1-2-3
December	13-14-15-16-17
Januari	10-11-12-13-14		31-1-2-3-4
Februari		14-15-16-17-18
Maart	28-29-30-31-1

Click on a date to enlist yourself for this course or click here if no suitable date can be found.

Prerequisites

This course requires that students have knowledge of, and practical experience with the Windows operating system, relational databases (SQL, normalization).

• Writing Queries using Microsoft SQL Server 2008 Transact SQL (MS2778)

Course outline

In this course you will learn how to install and configure SQL Server, create and maintain database backups, user accounts, permissions, tasks and bulk data operations. These skills are a core skill for anyone working with SQL Server databases.

Course content

• Installing and Configuring SQL Server 2008
• Manage databases and files
• Disaster Recovery (also using database snapshots)
• Manage security (server, database and schema scope)
• Introduction to SQL Server Integration Services
• Automate administrative tasks with SQL Server Agent
• Implementing Replication
• Maintaining High Availability technologies (e.g. Database Mirroring)
• Monitoring SQL Server
• Troubleshooting and Performance Tuning SQL Server 2008 Databases

Course material

Coursematerial with CD-ROM.

Related courses

• Implementing a SQL Server 2008 Database (MS6232)
• Updating your SQL Server 2005 Administration Skills to SQL 2008 (SQL2K8INF)

Follow up courses

• Implementing a SQL Server 2008 Database (MS6232)
• Designing, Optimizing, and Maintaining SQL Server 2008 Servers (MS6315)