Boost
Boost

Administering a SQL Database Infrastructure

IT-841

Course Code

5 Days

Duration

4

Upcoming Dates

Download Brochure
Sector Logo

Sector Name

Information Technology

Send by WhatsApp
02 Nov 2026 | 06 Nov 2026
Dubai, UAE
$4,250
Limited Seats
10 Jan 2027 | 14 Jan 2027
Riyadh, KSA
$4,250
Upcoming
24 May 2027 | 28 May 2027
Dubai, UAE
$4,250
Upcoming
19 Jul 2027 | 23 Jul 2027
Cape Town, South Africa
$4,950
Upcoming

Course Introduction

This training course is designed to provide participants with the knowledge and skills needed to administer and maintain Microsoft SQL Server 2016 databases.

This course will also enable them to develop applications that deliver content from SQL Server databases to administer a SQL Server database infrastructure. This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure.

Course Objectives

  • Authenticate and authorize users to access the resource
  • Assign server and database roles
  • Protect data with encryption and auditing
  • Recovery models and backup strategies
  • Backup and restore SQL Server databases
  • Configure security for the SQL Server agent
  • Manage alerts and notifications, and SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor and troubleshoot a SQL Server infrastructure
  • Automate database management
  • Import and export data
Course Preview
Share

Explore Courses

Certificate in Data Science (CDS)

01 Nov 2026 – 05 Nov 2026

Riyadh, KSA

Terraform: Up & Running

01 Nov 2026 – 05 Nov 2026

Riyadh, KSA

Adobe Photoshop

02 Nov 2026 – 06 Nov 2026

Dubai, UAE

Strategic Network Infrastructure Planning and Governance

02 Nov 2026 – 06 Nov 2026

Online, Virtual

Association and accredited bodies

CPD
PECB
IIBA
CMI
HR
Industry
ISO
CELMI
Download Brochure