55353 Administering a SQL Database Infrastructure

Introduction:

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.

Objectives:

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

Enroll in this course

£2,975.00£2,995.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

GBP Pound sterling
EUR Euro