SQL Server Essential Administration

This course is at aimed anyone charged with administering a SQL Server database system. It focuses on only the core administration responsibilities enabling new SQL Server database administrators to build the skills necessary to install, configure and support a simple SQL Server deployment. The objective is to provide the essential skills for managing a single instance system, enabling administrators to get up and running to a basic level fairly quickly, but also to provide an awareness of some of the more advanced services available. This course can be followed by a number of additional courses focussing on different specialisations and services available for SQL Server deployments. This course, along with the SQL Server Advanced Administration Course, helps to prepare delegates for the Microsoft 70-462 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.

SQL Server Architecture

New Features in 2012 and 2014

Installing SQL Server

Upgrading SQL Server Best Practices

Managing & Troubleshooting SQL Server Database Engine

Automating SQL Server

Securing The Database Instance

An Introduction To Performance Optimisation

An Introduction Monitoring SQL Server

Backup and Recovery

An Overview of Other Services


London Greenwich

Wednesday 06 to Friday 08 June 2018


Book Now


Programming courses

Sql courses

Database courses