Duration: 
4 Day(s)
Price: 
£1395-2000

Overview

This course is at aimed at SQL Server 2008 database administrators who wish to build on their basic administration skills and learn how to manage multiple SQL Server deployments and implement some of the more advanced administration and management services

Prerequisites

Delegates attending this course should have SQL Server 2008 administration knowledge up to the level provided by the "SQL Server 2008 Essential Administration Course"

Course Specifics

Course Outline

DBA Maintenance Tasks

  • Manage Services
  • Maintain Security
  • User Account Management
  • Linked Server Management
  • Impersonation
  • Index Maintenance
  • Index Types
  • Spatial
  • Clustered/Non-Clustered
  • XML
  • Filtered
  • Include
  • Updating and Creating Index and Column Statistics
  • Automatic v Manual Update
  • Enabling and Disabling Indexes
  • Rebuilding and Re-organizing Indexes
  • Database Engine Tuning Advisor
  • Manage Collations
  • Data File Maintenance
  • Shrinking Databases and Data Files
  • Automatic v Manual
  • Data Purging
  • Database Maintenance Plans
  • Maintain Database Integrity
  • CHECKDB
  • Suspect Pages
  • Performance and Tuning
  • Checking Log Files

Command Line Administration Tools

  • Using Powershell
  • Using sqlcmd

Advanced Database Design

  • Partitioning
  • Partitioned Tables
  • Partitioned Indexes
  • Sparse Columns
  • Row/Page Compression
  • Enabling Filestream Support
  • Implementing Full Text Indexing
  • Implementing Transparent Database Encryption(TDE)
  • Creating Database Snapshots

Transferring Data

  • Overview of Data Transfer
  • bcp utility
  • BULK INSERT
  • OPENROWSET
  • Import and Export Wizards
  • Introduction to SQL Server Integration Services

Implementing Replication

  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in Some Common Scenarios

Advanced Monitoring of SQL Server

  • Monitoring with DDL Triggers
  • Logon Triggers
  • Using Event Notifications

Performance Tuning Services

  • Profiler
  • Performance Monitor
  • Dynamic Management Views
  • Using Resource Governor
  • Performance Studio
  • Data Collector

Policy-Based Management

  • Using Policy-Based Management

Implementing Service Broker

  • A sample application

High Availability

  • Database Mirroring
  • Log Shipping
  • Clustering

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
Onsite
4 1395 £1395 2018-07-16
Cardiff
4 2000 £2000 2017-10-31
London
4 1395 £1395 2017-10-30
Manchester
4 2000 £2000 2017-10-12
Birmingham
4 2000 £2000 2017-09-25
Belfast
4 2000 £2000 2017-09-11
London
4 1395 £1395 2017-09-04
Leeds
4 2000 £2000 2017-08-10
London
4 2000 £2000 2017-08-07
Reading
4 2000 £2000 2017-07-26