To speak to a training advisor please call

training@coursemonster.com

All Courses / Microsoft Courses / Microsoft SQL Server 2008: Administration

Share: Follow us:

Bookmark with:

twiter

Print Page:

Microsoft SQL Server 2008: Administration

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

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.

Not sure whether this is the right Microsoft training course for you? For a more advanced search, click on our course category page

Related Courses

Audience

Database administrators and support technicians who need to be able to implement and manage Microsoft SQL Server 2008 databases.

Prerequisites

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.

Course Outline

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

Related Online Training

If you would prefer the flexibility of online training, use the link(s) below:

More Online Training>>

Top Selling Brands

How to make a booking for the SQ8K4ADM course

Scheduled Dates

Request availability or enquire by clicking a date:

Sort by Location

West Midlands

Worcestershire

£

1,360

Sort by Date

West Midlands

£

1,360

No Suitable Dates?

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

CourseMonster books thousands of public training courses, classes and boot camps both in London, City of London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Aylesbury, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Newcastle, Norwich, Nottingham, Plymouth, Reading, Sheffield, Southampton, Surrey, Sussex, Midlands and Yorkshire. Topics range from software to administration, project management and development.