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:

5

Location:

Virtual

Course Overview

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.

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.

Module 1: Installing and Configuring Domain Controllers

  • Understand the role of AD DS
  • Explore AD DS domain controller functions
  • Deploy and configure a new domain controller

Module 2: Managing Objects in Active Directory Domain Services (AD DS)

  • Create and manage user accounts and groups
  • Work with computer objects in AD DS
  • Use Windows PowerShell for AD DS administration
  • Implement and manage organizational units (OUs)

Module 3: Advanced AD DS Infrastructure Management

  • Review advanced AD DS deployment options
  • Deploy a distributed AD DS environment
  • Configure and manage AD DS trusts

Module 4: Implementing and Administering AD DS Sites and Replication

  • Understand how AD DS replication works
  • Configure AD DS sites for efficiency
  • Monitor and troubleshoot AD DS replication

Module 5: Implementing Group Policy

  • Introduction to Group Policy concepts
  • Create and administer Group Policy Objects (GPOs)
  • Define Group Policy scope and processing
  • Troubleshoot Group Policy application issues

Module 6: Managing User Settings with Group Policy

  • Apply and manage administrative templates
  • Configure folder redirection, software installation, and scripts
  • Set up Group Policy preferences for users and computers

Module 7: Securing Active Directory Domain Services

  • Strengthen security for domain controllers
  • Implement account and authentication policies
  • Audit and monitor logon activity
  • Configure managed service accounts

Module 8: Deploying and Managing Active Directory Certificate Services (AD CS)

  • Deploy certificate authorities (CAs)
  • Administer and maintain CAs
  • Troubleshoot common CA issues

Module 9: Deploying and Managing Certificates

  • Create and manage certificate templates
  • Oversee certificate deployment, revocation, and recovery
  • Use certificates in business environments
  • Implement and manage smart cards

Module 10: Implementing and Administering Active Directory Federation Services (AD FS)

  • Introduction to AD FS
  • Review AD FS requirements and plan a deployment
  • Deploy and configure AD FS
  • Understand the role of Web Application Proxy

Module 11: Implementing and Administering Active Directory Rights Management Services (AD RMS)

  • Overview of AD RMS functionality
  • Deploy and manage an AD RMS infrastructure
  • Configure content protection with AD RMS

Module 12: Synchronizing AD DS with Microsoft Azure AD

  • Plan and prepare for directory synchronization
  • Configure synchronization with Azure AD Connect
  • Manage identities in hybrid environments

Module 13: Monitoring, Managing, and Recovering AD DS

  • Monitor the health and performance of AD DS
  • Manage the Active Directory database
  • Perform backup and recovery for AD DS and related identity services
Class Dates & Times
Filters Sort results
Reset Apply
03/23/2026 - 03/27/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$2,995.00
06/22/2026 - 06/26/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$2,995.00
12/15/2025 - 12/19/2025
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.