SQL Server 2008 R2 Administration

Identify, configure and support all major aspects of Microsoft SQL Server 2008 databases
Overview

SQL Server 2008 R2 aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server high availability technologies, to provide reduced downtime.  To benefit from such wonderful claims, you will need to identify, configure, and support all major aspects of Microsoft SQL Server 2008 R2 databases.

Course Code
SQ8K4ADM
Duration
4 Days
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info

Book your place

Purpose of this course

It takes delegates through all the essential topics in SQL Server Administration including installation, using policies, security, backup, recovery and monitoring. This course is based on SQL Server 2008 R2 but is equally suitable for the earlier SQL Server 2008 release. The course will include lectures, demonstrations and exercises to consolidate the topics covered.

Who is this course for

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

You will learn how to
  • Install an instance of SQL Server
  • Create and configure database
  • Backup and restore database
  • Maximise the availability of SQL Server
  • Create logins
  • Manage user and role permissions
  • Prevent transaction logs from using unlimited disk space
  • Monitor SQL Server databases
Benefits for your organisation

SQL Server is becoming an increasingly popular choice for enterprise wide applications. This course will give your organisation the confidence to manage and support this product both safely and securely. It will help ensure best practises are being followed with SQL server.

Benefits for you as an individual

Many roles now require knowledge of SQL Server. This course will equip you with the skills to manage and support SQL Server. You will have confidence in the major topics for SQL Server administration.

Overview of SQL Server Concepts and Features

SQL Server 2008 Features
Server Components
Architecture
Administering SQL Server 2008 R2

Installing SQL Server 2008

SQL Server 2008 R2 Editions
Installing Microsoft SQL Server 2008 R2
System Requirements
Performing SQL Server 2008 R2 Setup
Installing SQL Server 2008 R2
Upgrading From Previous Versions of SQL Server
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 Data
Database Options
Managing Databases

Securing SQL Server

SQL Server Security
SQL Server Security Terminology
Authentication Modes
Database Access Security
Permissions and Securable
Policy-based Management
Transparent Data Encryption
Auditing
Simple 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 Recovery 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
Performance Data Collection
SQL Server Utility
Using DBCC to Check Integrity
DDL Triggers

Maintenance and Optimisation

Managing Jobs
Database Maintenance Plans
Implementing Multi-server Jobs
Viewing the Execution Plan
Using the Database Tuning Advisor
Index Fragmentation
SQL Server Configuration

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.

About the Lead Trainer

Stephen has 20 years’ experience in the IT industry. A member of the Institute of IT Training and British Computer Society with a degree in business computing systems, Stephen has a solid foundation upon which his ITIL® Expert qualification sits.