2779 Implementing a Microsoft SQL Server 2005 Database Training Class

Outline: 
Lesson 1: Creating Databases and Database Files

Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.

 
Lesson 2: Creating Data Types and Tables

Creating Data Types.
Creating Tables.
Creating Partitioned Tables.

 
Lesson 3: Using XML

Retrieving XML with FOR XML.
Shredding XML with OPENXML.
Using the xml Data Type.

 
Lesson 4: Creating and Tuning Indexes

Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.

 
Lesson 5: Implementing Data Integrity

Data Integrity Overview.
Implementing Constraints.
Implementing Triggers.
Implementing XML Schemas.

 
Lesson 6: Creating Views

Introduction to Views.
Creating and Managing Views.
Optimizing Performance with Views.

 
Lesson 7: Creating Stored Procedures and Functions

Implementing Stored Procedures.
Creating Parameterized Stored Procedures.
Creating Functions.
Handling Errors.
Controlling Execution Context.

 
Lesson 8: Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime.
Importing and Configuring Assemblies.
Creating Managed Database Objects.