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.

This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.

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.

Lab 2: Creating Data Types and Tables

Creating Partitioned Tables.

Module 3: Using XML

Retrieving XML by Using FOR XML.

Shredding XML by Using OPENXML.

Lab 3: Using XML

Using the xml Data Type.

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