SQL Server Essential Administration

TThis 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.

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 Optimization

An Introduction Monitoring SQL Server

Backup & Recovery

An Overview of Other Services

Dates


Collections

Programming courses

Sql courses

Database courses