Managing Database Data in a SQL Server 2005 Environment

This course is included in our On-demand training solution.

Overview

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

195 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?