Managing and Maintaining SQL Server 2005 Databases

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

---

Overview/Description
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 (hours)
3.2

Lesson 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.

Course Number:
234704_eng