M2779: Implementing a Microsoft SQL Server 2005 Database

5 Day Course
Hands On
Official Microsoft Curriculum
Code M2779

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite


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.

Target Audience

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

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Creating Databases and Database Files (4 topics)

  • Creating Databases
  • Creating Filegroups
  • Creating Schemas
  • Creating Database Snapshots

Creating Data Types and Tables (3 topics)

  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables

Using XML (3 topics)

  • Retrieving XML with FOR XML
  • Shredding XML with OPENXML
  • Using the xml Data Type

Creating and Tuning Indexes (4 topics)

  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes
  • Creating XML Indexes

Implementing Data Integrity (4 topics)

  • Data Integrity Overview
  • Implementing Constraints
  • Implementing Triggers
  • Implementing XML Schemas

Creating Views (3 topics)

  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance with Views

Creating Stored Procedures and Functions (5 topics)

  • Implementing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Creating Functions
  • Handling Errors
  • Controlling Execution Context

Implementing Managed Code in the Database (3 topics)

  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects

Using Service Broker (3 topics)

  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages


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

Relevant Certifications

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course