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.
Module 1: Creating Databases and Database Files
This module explains how to create databases, filegroups, schemas, and database snapshots.
Module 2: Creating Data Types and Tables
This module explains how to create data types and tables. It also describes how to create partitioned tables.
Module 3: Using XML
This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.
Module 4: Creating and Tuning Indexes
This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
Module 5: Implementing Data Integrity
This module explains how to implement constraints, triggers, and XML schemas.
Module 6: Implementing Views
This module explains how to create views.
Module 7: Implementing Stored Procedures and Functions
This module explains how to create stored procedures and functions.
Module 8: Implementing Managed Code in the Database
This module explains how to implement managed database objects.
Module 9: Using Service Broker
This module explains how to build a messaging-based solution with Service Broker.