We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

> > > 20764

Administering a SQL Database Infrastructure (20764)


Course Overview

This hands-on, 5-day instructor-led course teaches you the knowledge and skills to fully administer a SQL server database infrastructure.

Who should attend

  • IT professionals responsible for administering and maintaining SQL Server databases
  • Anyone pursuing their MCSA: SQL Server 2016 Database Administration
  • Application Developers that work with SQL Server databases



  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL and relational databases
  • Some experience with database design

Course Objectives

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data

Follow On Courses

Online Training

Duration 5 days

Price (excl. VAT)
  • United Kingdom: £ 2,395.-
  • SA Voucher: 5
    hardcoded default SA
E-Learning MOC on Demand

Duration 90 days

Price (excl. VAT)
  • United Kingdom: £ 449.-
  • SA Voucher: 2
    hardcoded default SA
Buy E-Learning
Click on the location to go directly to the booking page Schedule
This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This class will become guaranteed to run with one more student registration.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
United Kingdom

For more information please email enquiries@flane.co.uk to discuss training options available.

FLEX & Online Training

Please see below our alternative, English language, FLEX course options.

03/05/2020 ― 07/05/2020 Online Training Time zone: Africa/Cairo Course language: English Enroll
10/05/2020 ― 14/05/2020 Online Training Time zone: Asia/Qatar Course language: English Enroll