Data and Office

55353 Administering a SQL Database Infrastructure

Strengthen the day-to-day practices needed to maintain a secure, recoverable SQL Server environment.

5 Days · Live instructor-led training

What you will work on

Manage access, roles and auditing
Plan backups and restore databases
Automate administration and alerts
Monitor performance and troubleshoot issues

What the course covers

Explore the curriculum to see how it fits the work you want to do.

Lesson 1 - SQL Server Security

Lesson 2 - Assigning Server and Database Roles

Lesson 3 - Authorizing Users to Access Resources

Lesson 4 - Protecting Data with Encryption and Auditing

Lesson 5 - Recovery Models and Backup Strategies

Lesson 6 - Backing Up SQL Server Databases

Lesson 7 - Restoring SQL Server Databases

Lesson 8 - Automating SQL Server Management

Lesson 9 - Configuring Security for SQL Server Agent

Lesson 10 - Monitoring SQL Server with Alerts and Notifications

Lesson 11 - Introduction to Managing SQL Server by using PowerShell

Lesson 12 - Tracing Access to SQL Server with Extended events

Lesson 13 - Monitoring SQL Server

Lesson 14 - Troubleshooting SQL Server

Lesson 15 - Importing and Exporting Data

Who this course is for

SQL Server database administrators and developers with database responsibilities.

Before you attend

Intended for professionals already working with SQL Server databases.

Included with this course

Live instructor-led class
A preparation checklist for prerequisites, class access and setup
Altvina support for questions, concerns and next-step guidance

Ongoing mentorship is a separate paid service.

Support from Altvina

Have a question about course fit, learner details or access? Our team is your contact for enrollment support.

Ask a Course Question

Payments, refunds and class changes

Clear payment dates

Pay a $50 deposit per learner or full tuition. With your explicit agreement, the remaining balance is charged seven days before class. You receive an advance reminder.

Flexible before the cutoff

Class payments are refundable until seven days before the start. After that they are non-refundable; contact Altvina if an issue arises.

If the scheduled class changes

If Altvina or the training provider cancels or materially changes your class, you can choose a refund or an alternative date. We will contact you to arrange your choice.

Training instruction is delivered by Logical Operations or the provider listed for the class. Altvina handles enrollment and customer support.