Overview
This five-day instructor-led course provides students with the knowledge and skills 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.

Duration
5 Days

Target Audience
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Topics

Creating Databases and Database Files

Creating Data Types and TablesUsing XML

Creating and Tuning Indexes

Implementing Data Integrity by Using Constraints

Implementing Data Integrity by Using Triggers and XML Schemas

Implementing Views

Implementing Stored Procedures

Implementing Functions

Implementing Managed Code in the Database

Managing Transactions and Locks

Using Service Broker

Using Notification Services

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.