Managing and Maintaining SQL Server 2005 Databases

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

Overview

To manage and maintain SQL Server 2005 databases

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others

Prerequisites

This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

195 min.

Course Objectives

Managing and Maintaining SQL Server 2005 Databases

  • export bulk data in SQL Server 2005 in a given scenario.
  • import bulk data into SQL Server 2005 in a given scenario.
  • import and export bulk data in SQL Server 2005.
  • create and manage jobs using SQL Server Agent.
  • configure alerts using SQL Server Agent in a given scenario.
  • configure operators using SQL Server Agent in a given scenario.
  • perform management and monitoring tasks using the SQL Server Agent service.
  • perform database management tasks in SQL Server 2005, given a scenario.
  • perform the steps required to shrink a database in a given scenario.
  • check and maintain database integrity in SQL Server 2005.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?