|
|
SQ8K4ADM
4 Days
|
|
COURSE TOPICS
OVERVIEW OF SQL SERVER 2008
SQL Server 2008 Features
Server Components
Architecture
Administering SQL Server
INSTALLING SQL SERVER 2008
SQL Server 2008 Editions
Installing SQL Server
System Requirements
Preparing for SQL Server Installation
Performing SQL Server 2008 Setup
Installation Sequence
Upgrading From Previous Versions
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
Filestream
Database Options
Managing Databases
SECURITY
SQL Server Security
Using Policies
SQL Server Security Terminology
Authentication Modes
Database Access Control
Permissions and Securable
Transparent Encryption
Auditing
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
Backup Compression
Recovering System Databases
ENHANCING DATABASE AVAILABILITY
SQL Server 2008 Database Availability
Clustering SQL Server
Database Snapshots
Database Mirroring
Replication
Configuration Replication
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
Performance Data Collection
MAINTENANCE AND OPTIMISATION
Managing Jobs
Database Maintenance Plans
Multi-server Administration
Central Management Server
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 v1.2 |
|
THE COURSE
The course will allow the delegate to identify, configure, and support all major aspects of Microsoft SQL Server 2008 databases. The topics covered will include installation, using policies, security, backup, recovery and monitoring. The course will include lectures, demonstrations and exercises to consolidate the topics covered. Each delegate will have their own Microsoft SQL Server 2008 server for the course.
WHO SHOULD ATTEND
Database administrators and support technicians who need to be able to implement and manage Microsoft SQL Server 2008 databases.
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. Delegates must have a basic knowledge of Microsoft Server administration.
|