Updating SQL Server 2000 Administration Skills to SQL Server 2005

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

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.

Audience

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.

Prerequisites

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 Outline

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

Updating SQL Server 2000 Administration Skills to SQL Server 2005 / SQ5K2ADM