2779 - Implementing a Microsoft SQL Server 2005 Database

CLASS DATE(s):
11/8/2010 - 11/12/2010

COURSE LENGTH: 5 Days

COURSE COST: $2495*

COURSE TIMES: 8:30am - 4:00pm


print
register

COURSE OVERVIEW

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

*Course Cost does not include books. Please contact a VTEC Account Manager for details.

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

Those interested in becoming a Microsoft Certified Technology Specialist are also encouraged to enroll in this course. A MCTS is defined as a technology specialist interested in learning about, assessing skills, using reference products, or taking exams to prove his or her knowledge/skills/experience related to Microsoft's SQL Server 2005.

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.

COURSE TOPICS:

Creating Databases.

Creating Filegroups.

Creating Schemas.

Creating Database Snapshots.

Creating Data Types.

Creating Tables.

Creating Partitioned Tables.

Retrieving XML by Using FOR XML.

Shredding XML by Using OPENXML.

Using the xml Data Type.

Introducing XQuery

Planning Indexes.

Creating Indexes.

Optimizing Indexes.

Creating XML Indexes.

Data Integrity Overview.

Implementing Constraints.

Implementing Triggers

Implementing XML Schemas

Introduction to Views

Creating and Managing Views

Optimizing Performance by Using Views

Implementing Stored Procedures

Creating Parameterized Stored Procedures

Working With Execution Plans

Handling Errors

Creating and Using Functions

Working with Functions

Controlling Execution Context

Introduction to the SQL Server Common Language Runtime

Importing and Configuring Assemblies

Creating Managed Database Objects

Overview of Transactions and Locks

Managing Transactions

Understanding SQL Server Locking Architecture

Managing Locks

Service Broker Overview

Creating Service Broker Objects

Sending and Receiving Messages

Introduction to Notification Services

Developing Notification Services Solutions