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

Duration: 5 Days

Creating Databases and Database Files
Creating Data Types and Tables
Using XML
Creating and Tuning Indexes
Implementing Data Integrity
Implementing Views
Implementing Stored Procedures and Functions
Implementing Managed Code in the Database
Using Service Broker

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