This three-day instructor-led course provides students with product knowledge & skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features & tools related to implementing a database.

Duration: 3 Days

Creating Databases & Database Files
Creating Data Types & Tables
Using XML
Creating & Tuning Indexes
Implementing Data Integrity
Implementing Views
Implementing Stored Procedures & 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 & its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design