Updating Your Database Administration Skills to Microsoft SQL Server 2005 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Updating Your Database Administration Skills to Microsoft SQL Server 2005  

 Email information about this seminar Updating Your Database Administration Skills to Microsoft SQL Server 2005 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Updating Your Database Administration Skills to Microsoft SQL Server 2005 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

Database administrators experienced in SQL Server 2000/7.0 and Analysis Services who need to upgrade their skills to SQL Server 2005

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

sql+server+microsoft+database+2005+db+admin training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Updating Your Database Administration Skills to Microsoft SQL Server 2005 seminar

 

 

Training Course Syllabus:


Description

This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.


 
Intended Audience

Before attending this course, students must have MCDBA certification or equivalent knowledge.

 
Required Prerequisites
  • 2072: Microsoft SQL Server 2000 System Administration

 
Course Outline
  1. Overview of SQL Server 2005 Architecture
    1. Overview of SQL Server 2005
    2. System Enhancements for Administrators
  2. Installing SQL Server 2005
    1. Preparing to Install SQL Server 2005
    2. Performing a SQL Server 2005 Installation
    3. Maintaining a SQL Server 2005 Installation
  3. SQL Server 2005 Administrative Tools
    1. Using SQL Server Management Studio
    2. Using SQL Server Computer Manager
    3. Using the sqlcmd Utility
    4. Using the SQL Management Objects
  4. Monitoring SQL Server 2005
    1. Using SQL Profiler
    2. Using DDL Triggers
    3. Using Event Notifications
    4. Using Metadata Views
  5. Maintaining Databases and Indexes
    1. Managing Indexes
    2. Using the Database Tuning Advisor
  6. Securing SQL Server 2005
    1. SQL Server 2005 Security Overview
    2. Managing SQL Server 2005 Security
    3. Managing Permissions
    4. Managing Certificates
  7. Disaster Recovery
    1. Disaster Recovery in SQL Server 2005
    2. Using Database Snapshots
    3. Backup and Restore Operations
  8. Data Availability in SQL Server 2005
    1. Introduction to Data Availability
    2. Introduction to Database Mirroring
    3. Configuring Database Mirroring
  9. SQL Server 2005 Replication
    1. Overview of Replication Enhancements
    2. New Types of Replication
    3. Configuring Replication

Seminar Summary:

This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. (see full course description)

print this agenda print agenda for the Updating Your Database Administration Skills to Microsoft SQL Server 2005 training seminar

 view dates and locations for this seminar

 

 

 

Custom Search