InformIT Home About InformIT Oracle Workforce Development Program Cisco Networking Academy Program Microsoft IT Training & Certification Other Intensive Training International IT Certifications
  Windows Essentials  
  SQL Server Administrator  
  Windows Server 2003  
  Office Power User  
  Office Specialist  





















































Maintaining a Microsoft SQL Server 2005 Database
Course 2780: 3 days; Instructor-led

This course provides students with knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 features and tools related to maintaining a database.

To top of page

Course Objectives

After completing this course, students will be able to:

  • Install and configure SQL Server 2005
  • Manage database files
  • Manage security
  • Perform administrative tasks
  • Back up databases
  • Restore databases
  • Monitor SQL Server
  • Troubleshoot SQL Server
  • Transfer data
  • Maintain high availability
  • To top of page

    Microsoft Certified Technology Specialist Exams

    This course will help the student prepare for the following Microsoft Certified Technology Specialist exam:

    • Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

    To top of page


    Before attending this course, students must have:

    • Experience using a Microsoft Windows® operating system
    • Working knowledge of Transact-SQL and relational database
    • Experience in implementing a Microsoft SQL Server 2005 Database

    To top of page

    Course Outline

    Installing and Configuring SQL Server 2005
    • Preparing to install SQL Server
    • Installing SQL Server
    • Managing a SQL Server 2005 Installation

    Managing Databases and Files

    • Planning databases
    • Creating databases
    • Managing databases

    Disaster Recovery

    • Planning a Backup Strategy
    • Backing Up User Databases
    • Restoring User Databases
    • Recovering Data from Database Snapshots
    • System Database and Disaster Recovery

    Managing Security

    • Overview of SQL Server Security
    • Securing the Server Scope
    • Securing the Database Scope
    • Managing Keys and Certificates in SQL Server

    Monitoring SQL Server

    • Viewing Current Activity
    • Using System Monitor
    • Using SQL Server Profiler
    • Using DDL Triggers
    • Using Event Notifications

    Transferring Data

    • Overview of Data Transfer
    • Introduction to SQL Server Integration Services
    • Using SQL Server Integration Services

    Automating Administrative Tasks

    • Automating Administrative Tasks in SQL Server 2005
    • Configuring the SQL Server Agent
    • Creating Jobs and Operators
    • Creating Alerts
    • Managing Multiple Servers
    • Managing SQL Server Agent Security

    Maintaining High Availability

    • Introduction to High Availability
    • Implementing Server Clustering
    • Implementing Database Mirroring
    • Implementing Log Shipping

    Introduction to Replication

    • Overview of Replication
    • Replication Scenarios


    INFORMIT - Skill Development Center
    Jl. Purnawarman 9c, Bandung 40117- Phone (022) 4224 168 / 4223 168
    Fax. (022) 4231 168 - E-mail:

      Home | About Us | Oracle | Cisco | Microsoft | Other Training | Certification | Training Calendar  
    © 2006, InformIT Ganesa Pratama. All Right Reserved