Overview of SQL Server 2008

SQL Server 2008 Features

Understanding Server Components

SQL Server Architecture

 

Installing SQL Server 2008

SQL Server 2008 Editions

Installing SQL Server

System Requirements

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

 

SQL Server Security

Understanding SQL Server security

Using policies

Authentication modes

Configuring database access control

Permissions

Auditing

 

Importing, Exporting and Accessing Data

Importing and exporting data

Copying databases with the Management Studio

Using the Import/Export wizard

Understanding Integration

Services

Linked servers

Other data transfer methods

Disaster Recovery

Understanding disaster recovery

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

Understanding Monitoring systems

Configuring 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