|
|
SQ5K3ADM
3 Days
|
|
COURSE TOPICS
OVERVIEW OF SQL SERVER 2005 CONCEPTS AND FEATURES
SQL Server 2005 Features
Server Components
Architecture
Administering SQL Server
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
Upgrading From Previous Versions
Upgrade Advisor
Post-installation Configuration
Dedicated Administrator Connection
DESIGNING AND IMPLEMENTING DATABASES
Organising Data
Post-Installation Databases
Database Files
Planning a Database
Creating Databases
Working with Filegroups
Database Options
Managing Databases
SECURITY
SQL Server Security
SQL Server Surface Area Configuration
SQL Server Security Terminology
Authentication Modes
Database Access Control
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 THE DATABASE SERVER
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 v2.1 |
|
THE COURSE
The course will allow the delegate to identify and configure all major aspects of a Microsoft SQL Server 2005 RDBMS. The course shows how to install and configure an SQL Server, create and manage databases and database devices, backup and restore, import and export data, implement automated tasks and optimise the SQL server.
WHO SHOULD ATTEND
System administrators and database administrators who implement and manage a Microsoft SQL Server 2005 RDBMS.
PRE-REQUISITES
Delegates must have a good working knowledge of relational databases and be competent in SQL. This can be obtained by attending our Microsoft SQL Server Essentials course or equivalent. Alternatively, delegates could be proficient in a previous version of SQL Server such as 6.5,7 or 2000. Delegates should have a good working knowledge of Windows 2000/2003 Server administration.
|