PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   
Scheduled Classroom based Training Courses

Updating Your Database Administration Skills to Microsoft SQL Server 2005 Course

Course Description

This course is no longer scheduled to run. Please refer to schedule for current course titles.

This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server™ 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.

This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.

Delegates will learn how to:
  • Describe the architecture of SQL Server 2005
  • Install SQL Server 2005
  • Use SQL Server 2005 administrative tools and utilities
  • Maintain SQL Server 2005 servers and databases
  • Secure a SQL Server 2005 server and database
  • Monitor SQL Server 2005
  • Implement a Backup and Restore solution for SQL Server 2005
  • Implement a data availability solution with database mirroring or clustering
  • Use enhanced SQL Server 2005 replication features
    		•  £

    3 day course

    Scheduled Dates:

    Course pre-requisites:

    Before attending this course, students must have:

  • MCDBA certification or equivalent knowledge.
  • Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
  • Knowledge of SQL Server 2000/7.0
  • Database and server architecture.
  • Installation and configuration.
  • Database security.
  • Database recovery (backup and restore).
  • SQL Server technologies used for database availability such as log shipping and clustering.
  • Job automation.
  • Database and server monitoring.
  • Troubleshooting.
  • Replication.


    • In addition, it is recommended, but not required, that students have completed the Administering a Microsoft SQL Server 2000 Database course.


    Topics covered on the 3 day Updating Your Database Administration Skills to Microsoft SQL Server 2005 course

    Overview of SQL Server 2005 Architecture

  • Overview of SQL Server 2005
  • System Enhancements for Administrators


    • Installing SQL Server 2005

  • Preparing to Install SQL Server 2005
  • Performing a SQL Server 2005 Installation
  • Maintaining a SQL Server 2005 Installation


    • SQL Server 2005 Administrative Tools

  • Using SQL Server Management Studio
  • Using SQL Server Computer Manager
  • Using the sqlcmd Utility
  • Using the SQL Management Objects


    • Monitoring SQL Server 2005

  • Using SQL Profiler
  • Using DDL Triggers
  • Using Event Notifications
  • Using Metadata Views


    • Maintaining Databases and Indexes

  • Managing Indexes
  • Using the Database Tuning Advisor


    • Securing SQL Server 2005

  • SQL Server 2005 Security Overview
  • Managing SQL Server 2005 Security
  • Managing Permissions
  • Managing Certificates


    • Disaster Recovery

  • Disaster Recovery in SQL Server 2005
  • Using Database Snapshots
  • Backup and Restore Operations


    • Data Availability in SQL Server 2005

  • Introduction to Data Availability
  • Introduction to Database Mirroring
  • Configuring Database Mirroring


    • SQL Server 2005 Replication

  • Overview of Replication Enhancements
  • New Types of Replication
  • Configuring Replication

    • Course Classification: 

    Course Fee = £   (excl.VAT)



    Scheduled course dates



    Print / Download PDF Version of full course schedule

    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Training and bespoke SQL courses