M2779: Implementing a Microsoft SQL Server 2005 Database

5 Day Course
Hands On
Official Microsoft Curriculum
Code M2779

This course has been retired. Please view currently available Microsoft SQL Server Training Courses.

Modules

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

Prerequisites

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

Sections