Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

Course Length: 5 days.   

Overview

This course provides participants 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.

After course completion, participants will be able to create databases and database files, data types and tables. Participants will also be able to use XML in SQL Server 2005, create indexes, and implement data integrity. Additionally, participants will capable of implementing procedures and functions. Lastly, they will be skilled in using Service Broker for building a messaging-based solution and using Notification Services for generating and sending notifications.

Audience

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

Outline

1. Creating Databases and Database Files
2. Creating Data Types and Tables
3. Using XML
4. Creating and Tuning Indexes
5. Implementing Data Integrity using constraints
6. Implementing Data Integrity using Triggers and XML Schemas
7. Implementing Views
8. Implementing Stored Procedures
9. Implementing Functions
10. Implementing Managed Code in the Database
11. Managing Transactions and Locks
12. Using Service Broker
13. Using Notification Services (optional)

Prerequisites

Before attending this course, participants must have basic knowledge of the Microsoft Windows operating system and its core functionality. Additionally, participants should have working knowledge of Transact-SQL and relational database. Participants will also have some experience with database design. It is also recommended, but not required, that participants have completed (50027) Writing Queries Using Microsoft SQL Server Transact-SQL and (2780) Maintaining a Microsoft SQL Server 2005 Database.