Managing Database Data in a SQL Server 2005 Environment
This course is included in our On-demand training solution.
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Managing Database Data in a SQL Server 2005 Environmentrecognize 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.