Managing Database Data in a SQL Server 2005 Environment

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database

Target Audience
Professionals pursuing a career as a Database Administrator

Prerequisites
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration (hours)
3.2

Lesson Objectives

Managing Database Data in a SQL Server 2005 Environment

recognize how to create an SSIS package in a given scenario.

recognize how to run, configure, and troubleshoot SSIS packages in a given scenario.

recognize how to deploy SSIS packages in a given scenario.

create and deploy an SSIS package in a given scenario.

recognize how to use DML and DDL triggers to enforce data quality in a SQL Server 2005 database.

recognize how to configure the page_verify option to enforce data quality in a given scenario.

configure database options to enforce data quality in a SQL Server 2005 database.

recognize how data types are used to enforce data integrity in SQL Server 2005.

recognize how to enforce data integrity using constraints, given a scenario.

enforce data integrity within a SQL Server 2005 database.

Course Number:
237888_eng