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

Instructor-led Online Training:   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
2 hours difference
Online Training This is an English language FLEX course.
Time zone: UTC+3
3 hours difference
Online Training This is an English language FLEX course.
Time zone: Arabia Standard Time (AST)
Online Training This is an English language FLEX course.
Time zone: Gulf Standard Time (GST)
4 hours difference
Online Training This is an English language FLEX course.
Time zone: Gulf Standard Time (GST)
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.
United Kingdom

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