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

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

Certifications

Prerequisites

  • 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)
  • £ 2,395.-
  • SA Voucher: 5
    hardcoded default SA

Schedule

This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
English
Time zone BST
10/08/2020 ― 14/08/2020 Online Training Time zone: BST
24/08/2020 ― 28/08/2020 Online Training Time zone: BST guaranteed date!
12/10/2020 ― 16/10/2020 Online Training Time zone: BST
19/10/2020 ― 23/10/2020 Online Training Time zone: BST
16/11/2020 ― 20/11/2020 Online Training Time zone: GMT
14/12/2020 ― 18/12/2020 Online Training Time zone: GMT
11/01/2021 ― 15/01/2021 Online Training Time zone: GMT
08/02/2021 ― 12/02/2021 Online Training Time zone: GMT
08/03/2021 ― 12/03/2021 Online Training Time zone: GMT
2 hours difference
01/08/2021 ― 05/08/2021 Online Training This is an English language FLEX course.
Time zone: UTC+3
3 hours difference
24/01/2021 ― 28/01/2021 Online Training This is an English language FLEX course.
Time zone: UTC+3
01/08/2021 ― 05/08/2021 Online Training This is an English language FLEX course.
Time zone: UTC+4
4 hours difference
24/01/2021 ― 28/01/2021 Online Training This is an English language FLEX course.
Time zone: UTC+4
This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom
24/08/2020 ― 28/08/2020 guaranteed date! Virtual This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
07/09/2020 ― 11/09/2020 Birmingham Enroll
07/09/2020 ― 11/09/2020 Virtual Enroll
12/10/2020 ― 16/10/2020 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
19/10/2020 ― 23/10/2020 Manchester This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
07/12/2020 ― 11/12/2020 Birmingham Enroll
11/01/2021 ― 15/01/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
08/02/2021 ― 12/02/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training
08/03/2021 ― 12/03/2021 London (Int Hse) This is a FLEX course.   Time zone: Europe/London Enroll:
for online training
for classroom training