Microsoft SQL Server Training UK::M2780 - Maintaining a Microsoft SQL Server 2005 Database

This five-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Course Objectives

Intended Audience

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Course Prerequisites

Publicly scheduled dates, locations, and prices

Central London — £995 (+VAT)

12–16 May 2008
19–23 May 2008
2–6 Jun 2008
16–20 Jun 2008
30 Jun–4 Jul 2008
7–11 Jul 2008
21–25 Jul 2008
28 Jul–1 Aug 2008
11–15 Aug 2008
1–5 Sep 2008
8–12 Sep 2008
22–26 Sep 2008
6–10 Oct 2008
20–24 Oct 2008
3–7 Nov 2008
10–14 Nov 2008
17–21 Nov 2008
1–5 Dec 2008
8–12 Dec 2008
5–9 Jan 2009
19–23 Jan 2009
2–6 Feb 2009
16–20 Feb 2009
2–6 Mar 2009
23–27 Mar 2009
20–24 Apr 2009
27 Apr–1 May 2009
11–15 May 2009
18–22 May 2009

Leeds — £995 (+VAT)

2–6 Jun 2008
30 Jun–4 Jul 2008
7–11 Jul 2008
18–22 Aug 2008
22–26 Sep 2008
29 Sep–3 Oct 2008
20–24 Oct 2008
12–16 Jan 2009
20–24 Apr 2009

Manchester — £995 (+VAT)

19–23 May 2008
16–20 Jun 2008
23–27 Jun 2008
14–18 Jul 2008
11–15 Aug 2008
15–19 Sep 2008
13–17 Oct 2008
20–24 Oct 2008
17–21 Nov 2008
16–20 Feb 2009

Birmingham — £995 (+VAT)

16–20 Jun 2008
14–18 Jul 2008
22–26 Sep 2008
17–21 Nov 2008
26–30 Jan 2009
16–20 Mar 2009

Reading — £995 (+VAT)

16–20 Jun 2008
18–22 Aug 2008
20–24 Oct 2008
15–19 Dec 2008
23–27 Feb 2009
11–15 May 2009

Bristol — £995 (+VAT)

2–6 Jun 2008
4–8 Aug 2008
20–24 Oct 2008
1–5 Dec 2008
16–20 Feb 2009
11–15 May 2009

Edinburgh — £995 (+VAT)

23–27 Jun 2008
18–22 Aug 2008
20–24 Oct 2008
5–9 Jan 2009
2–6 Mar 2009
11–15 May 2009

Glasgow — £995 (+VAT)

12–16 May 2008
30 Jun–4 Jul 2008
11–15 Aug 2008
13–17 Oct 2008
15–19 Dec 2008
16–20 Feb 2009
20–24 Apr 2009

Milton Keynes — £995 (+VAT)

11–15 Aug 2008
1–5 Dec 2008
20–24 Apr 2009

Leicester — £995 (+VAT)

12–16 May 2008
21–25 Jul 2008
15–19 Sep 2008
24–28 Nov 2008

Sunderland — £995 (+VAT)

23–27 Jun 2008
28 Jul–1 Aug 2008
18–22 Aug 2008
8–12 Sep 2008
27–31 Oct 2008
1–5 Dec 2008

Exeter — £995 (+VAT)

7–11 Jul 2008
8–12 Sep 2008
17–21 Nov 2008
5–9 Jan 2009
2–6 Mar 2009

Newcastle — £995 (+VAT)

12–16 May 2008
11–15 Aug 2008

Swindon — £995 (+VAT)

12–16 May 2008

Aberdeen — £995 (+VAT)

28 Jul–1 Aug 2008
20–24 Oct 2008

Outline Course Contents

Installing and Configuring SQL Server 2005

This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

Managing Databases and Files

Disaster Recovery

Managing Security

This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Monitoring SQL Server

Transferring Data

Automating Administrative Tasks

This module explains how to use the SQL Server Agent to automate administrative tasks.

Implementing Replication

This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Maintaining High Availability

This module explains how to implement high availability technologies with SQL Server 2005

Microsoft Course 2780 - Maintaining a Microsoft SQL Server 2005 Database — A 5-Day Course

Course Synopsis