Administering a SQL Database Infrastructure Training (55353)

Course Overview

Duration: 5 days

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.

Course Objectives

Duration: 5 days

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

Who Should Attend?

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.

Course 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.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor-Led (the best training format we offer)
  • Live Online Classroom – Online Instructor-Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
11/30/202612/4/2026
12/21/202612/25/2026
1/11/20271/15/2027
2/1/20272/5/2027
2/22/20272/26/2027
3/15/20273/19/2027
4/5/20274/9/2027
4/26/20274/30/2027
5/17/20275/21/2027
6/7/20276/11/2027
6/28/20277/2/2027
7/19/20277/23/2027
8/9/20278/13/2027
8/30/20279/3/2027
9/20/20279/24/2027

Agenda

 

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

Administering a SQL Database Infrastructure Training (55353) at a glance

Course length5 days, live instructor-led
Price$2,995 public class / $3,894 private class
Next classesNov 30 - Dec 4, 2026; Dec 21 - Dec 25, 2026; Jan 11 - Jan 15, 2027
How to attendIn the classroom at our Miami campus (3721 NW 7th ST Suite 3721-1, Miami, FL 33126) or our Fort Lauderdale campus (800 W. Cypress Creek Road Suite 200, Fort Lauderdale, FL 33309), or live online from home or office
InstructorsIndustry-certified experts with real-world experience in the subjects they teach. Most have been with us for more than 10 years.
Free re-takeRe-take the same course (same version) free within one year

Frequently asked questions

How much does this course cost?

The Administering a SQL Database Infrastructure Training (55353) course is $2,995 for a public class, or $3,894 for a private class.

How long is the course?

5 days of live, instructor-led training.

Can I take it online or in person?

Both. Attend in the classroom at our Miami campus (3721 NW 7th ST Suite 3721-1, Miami, FL 33126) or our Fort Lauderdale campus (800 W. Cypress Creek Road Suite 200, Fort Lauderdale, FL 33309), or join the same live class online from your home or office.

When is the next class?

Upcoming classes start November 30, 2026, December 21, 2026 and January 11, 2027. See the Schedule tab for every date, or call 305-648-2000.

Can I take the course again?

You can re-take the same course (same version) free within one year.

Who teaches this course?

Industry-certified experts with real-world experience in the subjects they teach. Most have been with us for more than 10 years.