Introduction

This five-day instructor-led course provides students with the knowledge and skills 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.

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 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2780: Maintaining a Microsoft SQL Server 2005 Database.

Course Outline

Module 1: Creating Databases and Database Files

This module explains how to create databases, filegroups, schemas, and database snapshots.

Lab 1: Creating Databases and Database Files

• Creating a Database
• Creating Schemas
• Creating a Database Snapshot

Module 2: Creating Data Types and Tables

This module explains how to create data types and tables. It also describes how to create partitioned tables.

Lab 2: Creating Data Types and Tables

• Creating Data Types
• Creating Tables
• Creating Partitioned Tables

Module 3: Using XML

This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.

Lab 3: Using XML

• Mapping Relational Data and XML
• Storing XML Natively in the Database
• Using XQuery with xml Methods

Module 4: Creating and Tuning Indexes

This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.

Lab 4: Creating and Tuning Indexes

• Creating Indexes
• Tuning Indexes
• Creating XML Indexes

Module 5: Implementing Data Integrity by Using Constraints

This module explains how to implement constraints and provides an overview of data integrity.

Lab 5: Implementing Data Integrity by Using Constraints

• Creating Constraints
• Disabling Constraints

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

This module explains how to implement triggers and XML schemas.

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

• Creating Triggers
• Implementing XML Schemas

Module 7: Implementing Views

This module explains how to create views.

Lab 7: Implementing Views

• Creating Views
• Creating Indexed Views
• Creating Partitioned Views

Module 8: Implementing Stored Procedures

This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.

Lab 8: Implementing Stored Procedures

• Creating Stored Procedures
• Working With Execution Plans

Module 9: Implementing Functions

This module explains how to create functions. It also describes how to control the execution context.

Lab 9: Implementing Functions

• Creating Functions
• Controlling Execution Context

Module 10: Implementing Managed Code in the Database

This module explains how to implement managed database objects.

Lab 10: Implementing Managed Code in the Database

• Importing an Assembly
• Creating Managed Database Objects

Module 11: Managing Transactions and Locks

This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.

Lab 11: Managing Transactions and Locks

• Using Transactions
• Managing Locks

Module 12: Using Service Broker

This module explains how to build a messaging-based solution with Service Broker.

Lab 12: Using Service Broker (Optional)

• Creating Service Broker Objects
• Implementing the Initiating Service
• Implementing the Target Service

Module 13: Using Notification Services (Optional)

This module explains how to develop applications that generate and send timely messages to subscribers.

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Microsoft Software Assurance

What is Software Assurance?

Software Assurance (SA) provides an easy way for Microsoft's Volume Licensing customers to stay current with the latest and most innovative Microsoft products. Under the SA program, customers acquire the right to install any new release of products covered in the agreement during the term of their coverage. Companies can acquire tomorrow's technology at today's prices and have the ability to spread payments annually instead of paying up front. Visit www.microsoft.com/licensing to learn more about Microsoft's licensing programs.

What is the SA Enhancement Offering?

The SA Enhancement Offering is designed to increase customer satisfaction by giving customers more value from Software Assurance and a better Microsoft product experience. The Enhancement Offering contains tools, training, and support as well as additional licensing benefits which meet different customer needs across product segments and across customer segments. The many benefits include:

• Training vouchers redeemable
• Employee Purchase Program
• Home Use Program
• Problem Resolution Support
• TechNet Subscription
• Technology & Tools

What is the Software Assurance (SA) Training Voucher Program?

Qualifying organizations that purchase Software Assurance receive training credits from Microsoft. Each training credit is worth the equivalent of one day of training at Networking Technologies™. Customers can redeem these credits for SA Training Vouchers for select Microsoft courses from «Networking Technologies»™.

How to Get Started?

Contact the individual in your organization responsible for software purchases to verify that you purchased volume licensing with Software Assurance. We can help you activate your benefits and administer the training vouchers. To register for a training contact Education Center «Networking Technologies»™ directly via e-mail edu@tex.kiev.ua