This course is aimed at 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-764 exam: Administering Microsoft SQL Database Infrastructure. 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 2017. This course can be offered in a face to face classroom and virtual setting.
Delegates attending this course should have as a minimum a basic understanding of relational databases and the SQL language, up to the level provided by the PTR “SQL Server Database Querying Course”, but would benefit from having attended the “Transact SQL Programming Course” as well.