|
|
SQ5K2ADM
2 Days
|
|
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
Course Outline v3.0 |
|
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. |