SQL Server Advanced Administration Training – Live Online or Classroom

Exceptional SQL Server Training

SQL Server Advanced Administration

Course Facts

4 day course
Our Trainers are Authorised Professionals
Live Online or Classroom-based
Certificate of completion
Maximum class size of 6 for scheduled courses
Unlimited support after your course
Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses

Course Outline

DBA Maintenance Tasks
Command Line Administration Tools
Advanced Database Design
Transferring Data
Implementing Replication

FULL OUTLINE

Related Courses

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Enquire Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Enquire Now

Team Training and Bespoke Sessions

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

Sessions can be run online or in person, on your site or at our London training centre.
We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
We offer a free consultation service to work out every detail of your course.

Prices for bespoke sessions with our expert trainers start at £525 + VAT.

Overview

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.

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

Related Courses

Our Clients

Our Recent Success Stories

Animate

Stuart's Story

Graphic Designer at S4C

Consultancy and Development

Carly's Story

Managing Director at FSL Aerospace

Sketch

Mark's Story

Graphic Designer at Just Eat

30 years working with Microsoft

600+ Reviews

Why Transmedia?

Unlimited Training Support

We offer unlimited training support after your course.

Bespoke Training Solutions

Customised training and software solutions based on your exact specification.

Worldwide Creative Skills Training

Join our authorised training courses live online from anywhere in the world.

Authorised Training Professionals

Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.

Courses Live Online

Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.

SEE COURSES

Classroom Training

Join us at one of our Authorised Training Centres for a traditional classroom-based experience.

We have everything ready for you to have the best training experience.

SEE COURSES

Private Courses

One-to-one tuition or a private group training with just you or your colleagues.

We can train you live online, at one of our centres or onsite, wherever you are located.

SEE COURSES

Useful Links

Wikipedia page for SQL Server – History and capabilities of SQL Server
SQL Server internals and architecture guides – Discusses general concepts and apply to all versions of SQL Server, unless stated
Tutorials from W3 Schools – SQL tutorials that will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres and other database systems
SQL Server download page – Microsoft-authored tutorials to help you learn new technologies and features

Latest Help Station Articles

Understanding Website Engagement and How to Improve It

Organic Search and Video: Navigating Google's Stance on AI-Created Content

Your Non-Linear Editing Choice: Premiere Pro vs Final Cut Pro vs DaVinci Resolve