Microsoft SQL Server Training UK::M2779 - Implementing a Microsoft SQL Server 2005 Database

This five-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing 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 implementing a database.

Course Prerequisites

Publicly scheduled dates, locations, and prices

Central London — £995 (+VAT)

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

Leeds — £995 (+VAT)

16–20 Jun 2008
14–18 Jul 2008
11–15 Aug 2008
8–12 Sep 2008
6–10 Oct 2008
20–24 Oct 2008
17–21 Nov 2008
15–19 Dec 2008
2–6 Feb 2009

Manchester — £995 (+VAT)

12–16 May 2008
9–13 Jun 2008
7–11 Jul 2008
1–5 Sep 2008
8–12 Sep 2008
27–31 Oct 2008
1–5 Dec 2008
2–6 Mar 2009

Birmingham — £995 (+VAT)

1–5 Sep 2008
3–7 Nov 2008
5–9 Jan 2009
2–6 Mar 2009
11–15 May 2009

Reading — £995 (+VAT)

12–16 May 2008
4–8 Aug 2008
6–10 Oct 2008
1–5 Dec 2008
2–6 Feb 2009
20–24 Apr 2009

Swindon — £995 (+VAT)

23–27 Jun 2008
8–12 Sep 2008
8–12 Dec 2008
2–6 Mar 2009

Glasgow — £995 (+VAT)

16–20 Jun 2008
1–5 Sep 2008
8–12 Dec 2008
9–13 Mar 2009

Milton Keynes — £995 (+VAT)

28 Jul–1 Aug 2008
24–28 Nov 2008
23–27 Mar 2009

Leicester — £995 (+VAT)

2–6 Jun 2008
14–18 Jul 2008
1–5 Sep 2008
13–17 Oct 2008
17–21 Nov 2008
1–5 Dec 2008

Sunderland — £995 (+VAT)

2–6 Jun 2008
14–18 Jul 2008
28 Jul–1 Aug 2008
8–12 Sep 2008
27–31 Oct 2008

Newcastle — £995 (+VAT)

7–11 Jul 2008

Aberdeen — £995 (+VAT)

21–25 Jul 2008
29 Sep–3 Oct 2008

Outline Course Contents

Creating Databases and Database Files

This module explains how to create databases, filegroups, schemas, and database snapshots.

Creating Data Types and Tables

This module explains how to create data types and tables. It also describes how to create partitioned tables.

Using XML

This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.

Creating and Tuning Indexes

This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.

Implementing Data Integrity by Using Constraints

This module explains how to implement constraints and provides an overview of data integrity.

Implementing Data Integrity by Using Triggers and XML Schemas

This module explains how to implement constraints and provides an overview of data integrity.

Implementing Views

Implementing Stored Procedures

This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.

Implementing Functions

This module explains how to create functions. It also describes how to control the execution context.

Implementing Managed Code in the Database

Managing Transactions and Locks

This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.

Using Service Broker

This module explains how to build a messaging-based solution with Service Broker.

Microsoft Course 2779 - Implementing a Microsoft SQL Server 2005 Database — A 5-Day Course

Course Synopsis