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

contact usEnquire about this course

Course Synopsis

Please note that this course has been retired and is no longer available. Please see the Microsoft SQL Server 2005 page for courses currently available in this subject area.

This five-day instructor-led M2779 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

On completion of this M2779 training course, delegates should be able to:

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

Before attending this course, students should have the following prerequisites:

Schedule

This course has been retired and is no longer available.


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

This module explains how to create 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

This module explains how to implement managed database objects.

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.