SQL Server 2008 Database Management


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



Overview/Description
Database maintenance is an ongoing task for SQL Server 2008 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2008 Transact-SQL provides DBCC statements, which in turn provide statements to maintain the database and database files. An administrator can also use maintenance plans to run a series of tasks on specific databases using a schedule or on demand. This course demonstrates how to confirm the integrity of a database, manage database files, and how to create maintenance plans using a wizard or the designer. The course also addresses how to move data between SQL Server instances using detach and attach methods and the Copy Database Wizard, and how to move database files within the same SQL Server instance. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who don't work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.

Prerequisites
One to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server

Expected Duration (hours)
2.0

Lesson Objectives

SQL Server 2008 Database Management

  • recognize how to check database integrity
  • recognize how to shrink a database
  • recognize how to expand a database
  • recognize how to detach a database
  • recognize how to move a database between instances
  • recognize how to create database maintenance plans to automate administrative tasks
  • check database integrity
  • detach and reattach a database
  • use the maintenance plan design surface to create a database maintenance plan
  • recognize the purpose of SQL Server Agent
  • recognize how to use SQL Server Agent to create operators
  • recognize how to use a SQL Server Agent job to automate a task
  • recognize how to create an alert that responds to events that occur on a SQL Server computer
  • recognize how the Policy-Based Management feature works in SQL Server 2008
  • recognize how to use SQL Server 2008 Policy-Based Management to create a policy
  • configure SQL Server Agent
  • use Policy-Based Management to administer a database
  • Course Number:
    md_mcim_a04_it_enus