55353 Administering a SQL Database Infrastructure

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Course Details

Price:

$2,995.00

Days:

Location:

Course Overview

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

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.

SQL Server Security

Authenticate logins and authorize users to access databases
Configure SQL Server login options
Authorization across servers and partially contained databases

Assigning Server and Database Roles

Understand fixed and custom database roles
Assign and manage server roles

Authorizing Users to Access Resources

Use database roles and application roles
Implement role-based access to secure data

Protecting Data with Encryption and Auditing

Configure SQL Server Audit and manage audit logs
Encrypt sensitive data and enforce auditing policies

Recovery Models and Backup Strategies

Understand backup strategies for transactional integrity
Plan SQL Server recovery using appropriate models

Backing Up SQL Server Databases

Perform full and differential database backups
Manage backup files and automate backup jobs

Restoring SQL Server Databases

Use restore options and perform point-in-time recovery
Handle advanced restore scenarios

Automating SQL Server Management

Configure SQL Server Agent for scheduled jobs
Automate repetitive tasks using job steps and notifications

Configuring Security for SQL Server Agent

Set up credentials, proxies, and secure agent access

Monitoring with Alerts and Notifications

Create operators and configure alerting
Monitor Azure SQL Database events and performance

Managing SQL Server with PowerShell

Use PowerShell to configure SQL Server
Administer and maintain SQL Server infrastructure
Manage Azure SQL using PowerShell

Tracing Access with Extended Events

Capture login and query activity
Use Extended Events to analyze SQL Server performance

Monitoring SQL Server

Monitor usage metrics and server performance
Analyze collected data using SQL Server Utility

Troubleshooting SQL Server

Resolve service, login, and connectivity issues
Apply a troubleshooting methodology for performance

Importing and Exporting Data

Import and export data using BCP and BULK INSERT
Deploy and manage data-tier applications

Class Dates & Times


06/22/2026 - 06/26/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
09/21/2026 - 09/25/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
12/14/2026 - 12/18/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →