Implementing a Microsoft SQL Server 2005 Database

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.

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

It is strongly recommended that attendees take the following course before taking this class (or have at least 6 months experience writing Transact-SQL statements):

• SQL200 Transact-SQL Programming

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

Topics covered:

• Creating Databases and Database Files
• Creating Data Types and Tables
• Using XML
• Creating and Tuning Indexes
• Implementing Data Integrity by Using Constraints
• Implementing Data Integrity by Using Triggers and XML Schemas
• Implementing Views
• Implementing Stored Procedures and Functions
• Managing Transactions and Locks
• Implementing Managed Code in the Database
• Using Service Broker

At course completion:
Students will be able to:

• create databases and database files
• create data types and tables
• Use XML in SQL Server 2005
• Plan create and tune indexes
• Implement data integrity in Microsoft SQL Server 2005 by using triggers.
• Implement views
• Implement stored procedures and functions
• Implement managed code in the database
• Manage transaction and locks
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.

Exams:
70-431:TS Microsoft SQL Server 2005 Implementation and Maintenance.