203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Course 2779: Implementing a Microsoft SQL Server 2005 Database

This 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.

Audience

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

At Course Completion

After completing the course, students will be able to:

  • Create databases and database files
  • Create data types and tables
  • Use XML-related features in Microsoft SQL Server 2005
  • Plan, create, and optimize indexes
  • Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas
  • Implement views
  • Implement stored procedures and functions
  • Implement managed code in the database
  • Use Service Broker to build a messaging-based solution

Prerequisites
  • 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

Course Contents
  • Module 1: Creating Databases and Database Files
    • Creating Databases
    • Creating Filegroups
    • Creating Schemas
    • Creating Database Snapshots
  • Module 2: Creating Data Types and Tables
    • Creating Data Types
    • Creating Tables
    • Creating Partitioned Tables
  • Module 3: Using XML
    • Retrieving XML by Using FOR XML
    • Shredding XML by Using OPENXML
    • Using the xml Data Type
  • Module 4: Creating and Tuning Indexes
    • Planning Indexes
    • Creating Indexes
    • Optimizing Indexes
    • Creating XML Indexes
  • Module 5: Implementing Data Integrity
    • Data Integrity Overview
    • Implementing Constraints
    • Implementing Triggers
    • Implementing XML Schemas
  • Module 6: Implementing Views
    • Introduction to Views
    • Creating and Managing Views
    • Optimizing Performance by Using Views
  • Module 7: Implementing Stored Procedures and Functions
    • Implementing Stored Procedures
    • Creating Parameterized Stored Procedures
    • Creating Functions
    • Handling Errors
    • Controlling Execution Context
  • Module 8: Implementing Managed Code in the Database
    • Introduction to the SQL Server Common Language Runtime
    • Importing and Configuring Assemblies
    • Creating Managed Database Objects
  • Module 9: Using Service Broker
    • Service Broker Overview
    • Creating Service Broker Objects
    • Sending and Receiving Messages

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule