Updating SQL Server 2000 Administration Skills to SQL Server 2005

Quanta Training
In Worcester

£680
+ VAT
Want to speak to an Advisor about this course?

Important information

Typology Course
Start Worcester
Duration 2 Days
  • Course
  • Worcester
  • Duration:
    2 Days
Description

This INTENSIVE course is designed to take existing, erperienced SQL Server 2000 Administrators and give them the ability to perform current tasks in the new product, such as disaster recovery, as well as covering new areas that improve availability, security and other administrative areas.
Suitable for: Existing SQL Server System administrators and database administrators who are now looking at implementing and using SQL Server 2005. Delegates with good SQL 2000 skills, as outlined below should attend this course. Delegates with less experience may benefit from attending the SQL Server 2005 Intro and/or SQL Server 2005 Administration course in place of this course.

Important information
Venues

Where and when

Starts Location
On request
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map
Starts On request
Location
Worcester
8-10 The Moors, WR1 3EE, Worcestershire, England
See map

Course programme

THE COURSE
This INTENSIVE course is designed to take existing, erperienced SQL Server 2000 Administrators and give them the ability to perform current tasks in the new product, such as disaster recovery, as well as covering new areas that improve availability, security and other administrative areas.

The course takes a ‘How do I do what I know?' followed by a ‘What's new?' approach. The emphasis is on the new functionality while ensuring the delegate as a rounded appreciation of the whole product.

WHO SHOULD ATTEND
Existing SQL Server System administrators and database administrators who are now looking at implementing and using SQL Server 2005. Delegates with good SQL 2000 skills, as outlined below should attend this course. Delegates with less experience may benefit from attending the SQL Server 2005 Intro and/or SQL Server 2005 Administration course in place of this course.

PRE-REQUISITES
Delegates must have a good working knowledge of relational databases and be competent in administering SQL Server 2000. It is essential that delegates have a very good understanding of SQL 2000 as the course assumes this in order to cover the available material in the available time.

COURSE TOPICS

INSTALLING MICROSOFT SQL SERVER 2005

  • SQL Server 2005 Editions
  • Installing Microsoft SQL Server
  • Preparing for SQL Server Installation
  • Performing SQL Server 2005 Setup

Installation Sequence

  • Exercise Installing a SQL Server 2005 Instance
  • Upgrading From Previous Versions
  • exercise Using SQL Server 2005 Upgrade Advisor
  • Post-installation Configuration

SQL SERVER 2005 BASICS

  • Administration Tools
  • Configuration Tools
  • Managing Databases
  • Working with Tables
  • Database Diagrams

SECURITY

  • SQL Server Security
  • SQL Server Surface Area Configuration
  • SQL Server Security Terminology
  • Authentication Modes
  • Database Access Control
  • Database Roles
  • Permissions and Securable
  • Auditing
  • Security Checklists

IMPORTING, EXPORTING AND ACCESSING DATA

  • Importing and Exporting Data
  • Copying Databases with Management Studio
    Using the Import/Export Wizard
  • Introduction to Integration Services
  • Linked Servers
  • Other Data Transfer Methods

DISASTER RECOVERY

  • Disaster Recovery Fundamentals
  • Basic Backup and Restore Operations
  • Further Backup Concepts
  • Further Restore Concepts
  • Recovering System Databases

ENHANCING DATABASE AVAILABILITY

  • SQL Server 2005 Database Availability
  • Clustering SQL Server
  • Database Snapshots
  • Exercise Database Snapshots
  • Database Mirroring
  • Exercise Database Mirroring
  • Replication
  • Configuration Replication
  • Exercise Implementing Replication
  • Log Shipping
  • Exercise Performing Log Shipping

MONITORING

  • Monitoring Systems
  • Database Mail
  • Using Operators and Alerts
  • Monitoring with SQL Profiler
  • Using Windows Performance Monitor
  • SQL Server Logs
  • Activity Monitor
  • Using DBCC for Monitor Consistency
  • DDL Triggers

MAINTENANCE AND OPTIMISATION

  • Managing Jobs
  • Database Maintenance Plans
  • Implementing Multi-Server Jobs
  • Index Management
  • Using the Database Tuning Advisor
  • Optimising SQL Server
  • Optimising Hardware
  • Optimising Windows
  • SQL Server Configuration
  • Optimal Database Design
  • Client-Side Optimisation

Achievements for this centre


Students that were interested in this course also looked at...
See all