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.

From
$3095 CAD

5 day

View Dates/Location
Virtual Classroom Live

Virtual Classroom Live

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

From
$2995 CAD

5 day

View Dates
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 session

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

Prerequisites

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.

Querying Data with Transact-SQL (M20761)

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.

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

Cart () Loading...

Subtotal