Duration: 35 hours
Description: 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.
Objective: Students
will become skilled on SQL Server 2005 product features and technologies for
implementing a database.
Course Content:
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
Implementing
Functions
Implementing Managed Code in the Database
Managing Transactions and Locks
Using Service Broker