0845 470 1000 / enquiries@flane.co.uk
> > > 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,391.-
  • 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