SQL Server Advanced Administration (2008/2016)

Duration: 4 Days

Objectives

This course is at aimed at SQL Server 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. This course along with the SQL Server Essential Administration Course helps to prepare delegates for the 70-462 Microsoft MCTS exam: Administering Microsoft SQL Server 2012/2014 Databases. This exam credits towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2016.

Pre-requisites

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

Course includes

A comprehensive set of reference notes covering course topics and follow-up telephone support.

Course outline

DBA Maintenance Tasks

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 & Creating Index & 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 versus 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

Live Chat

Course Dates

Location: just outside London

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260

All prices are per person and are subject to VAT

15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Related Courses

"The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful."

VCCP

"Excellent. The right pace, the right style- great overall!"

Goldsmiths University of London

"An enjoyable and productive day. A flexible content and pace of work which suited our needs."

Guardian News & Media