How much does 55353 Administering a SQL Database Infrastructure cost?

$2,995 per seat. That covers courseware and lab access. Exam vouchers are quoted separately. Volume pricing is available for teams, and a private cohort is usually cheaper per seat past about four people.

How long is 55353 Administering a SQL Database Infrastructure?

5 days of instructor-led training, delivered live online. Classes run during business hours in the timezone shown on each date.

When is the next 55353 Administering a SQL Database Infrastructure class?

The next scheduled date is Dec 14-18. There is 1 upcoming date in total, 1 of which is guaranteed to run regardless of enrollment.

Is 55353 Administering a SQL Database Infrastructure delivered online?

Yes. It runs live online with an instructor, not as a recording, so you can ask questions as you go. It can also be delivered privately at your site.

What are the prerequisites for 55353 Administering a SQL Database Infrastructure?

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.

Can a government agency buy 55353 Administering a SQL Database Infrastructure?

Yes. Purchase orders and government purchase cards are both accepted at checkout, and quotes can be formatted for a solicitation response. Terms are net 30 on invoiced orders.

What happens if I need to cancel 55353 Administering a SQL Database Infrastructure?

Course fees are fully refundable with written notice at least ten business days before the class. Inside that window the fee is forfeited, though one free retake is available within six months of the class date.

55353 Administering a SQL Database Infrastructure | 5-day class

Upcoming dates

All times shown in the class's own timezone. 1 of 1 are guaranteed to run, meaning they go ahead regardless of enrollment.

Dates	Starts	Where	Status	Seat	Book
Dec 14-18	9:00 AM to 5:00 PM EST	Live virtual	GUARANTEED	$2,995

About this class

We have 1 scheduled date of 55353 Administering a SQL Database Infrastructure, starting Dec 14-18. It is guaranteed to run regardless of enrollment. Seats are $2,995 each over 5 days, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

Are your SQL Server systems secure, optimized, and ready for the demands of modern business? With over 70% of organizations relying on SQL databases to drive daily operations, the need for skilled database administrators is stronger than ever.

This instructor-led course on administering a SQL database infrastructure equips learners with practical skills to configure SQL Server security, implement backup strategies, manage access, monitor performance, and use PowerShell for automation. You’ll also learn to maintain SQL Server databases, troubleshoot performance issues, and import and export data across production environments, including Microsoft Azure SQL.

What you'll be able to do

This course prepares professionals to administer and maintain SQL Server infrastructure with a strong emphasis on security, availability, and automation.

Participants will learn to:

Authenticate users and assign database roles
Configure SQL Server auditing, agent security, and backup strategies
Manage SQL Server using PowerShell and automation techniques
Monitor SQL Server activity using Extended Events
Troubleshoot performance issues and import/export data

Course outline

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

Before you attend

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 this is for

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.