Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Administering a SQL Database Infrastructure (M20764)

Learn to administer and maintain Microsoft SQL Server 2016 databases.

GK# 4396

Course Overview

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.


    $3095 CAD

    5 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2995 CAD

    5 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Authenticate and authorize users.
  • Assign server and database roles.
  • Authorize users to access resources.
  • Protect data with encryption and auditing.
  • Recovery models and backup strategies.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Automate database management.
  • Configure security for the SQL Server agent.
  • Manage alerts and notifications.
  • Manage 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


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

Who Needs To Attend

  • Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job.
  • Individuals who develop applications that deliver content from SQL Server databases.

Course Outline

Download Course Outline

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more