Technical Training - Implementing a Microsoft SQL Server 2005 Database

Course No: M2779 Course Lengh: 5 Days

Who Should Attend: This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Pre-Requisites: Before attending this course, students must have:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.

In addition, it is recommended, but not required, that students have completed:

Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL.

Creating Databases and Database Files
This module explains how to create databases, file groups, 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
This module explains how to implement constraints, triggers, and XML schemas.

Creating Views
This module explains how to create views. Creating Stored Procedures and Functions
This module explains how to create stored procedures and functions.

Implementing Managed Code in the Database

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

Site by Notcon