CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2779 - Implementing a Microsoft SQL Server 2005 Database

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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.

Click here for a printer-friendly version of this page

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. In addition, it is recommended, but not required, that students have completed: Course 2780: Maintaining a Microsoft SQL Server 2005 Database.

Detailed Class Syllabus

Module 1: Creating Databases and Database Files

Creating Databases.

Creating Filegroups.

Creating Schemas.

Creating Database Snapshots.

Lab 1: Creating Databases and Database Files

Module 2: Creating Data Types and Tables

Creating Data Types.

Creating Tables.

Creating Partitioned Tables.

Lab 2: Creating Data Types and Tables

Module 3: Using XML

Retrieving XML by Using FOR XML.

Shredding XML by Using OPENXML.

Using the xml Data Type.

Lab 3: Using XML

Module 4: Creating and Tuning Indexes

Planning Indexes.

Creating Indexes.

Optimizing Indexes.

Creating XML Indexes.

Lab 4: Creating and Tuning Indexes

Module 5: Implementing Data Integrity

Data Integrity Overview.

Implementing Constraints.

Implementing Triggers.

Implementing XML Schemas.

Lab 5: Implementing Data Integrity by Using Constraints

Module 6: Implementing Views

Introduction to Views.

Creating and Managing Views.

Optimizing Performance by Using Views.

Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas

Module 7: Implementing Stored Procedures and Functions

Implementing Stored Procedures.

Creating Parameterized Stored Procedures.

Creating Functions.

Lab 7: Implementing Views

Module 8: Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime.

Importing and Configuring Assemblies.

Creating Managed Database Objects.

Lab 8: Implementing Stored Procedures

Module 9: Using Service Broker

Service Broker Overview.

Creating Service Broker Objects.

Sending and Receiving Messages.

Lab 9: Implementing Functions

Module 10: Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime

Importing and Configuring Assemblies

Creating Managed Database Objects

Lab 10: Implementing Managed Code in the Database

Module 11: Managing Transactions and Locks

Overview of Transactions and Locks

Managing Transactions

Managing Locks

Lab 11: Managing Transactions and Locks

Module 12: Using Service Broker

Service Broker Overview

Creating Service Broker Objects

Sending and Receiving Messages

Lab 12: Using Service Broker (Optional)

Module 13: Using Notification Services (Optional)

Introduction to Notification Services

Developing Notification Services Solutions