Administering a SQL Database Training

55316A is the Community Courseware equivalent of retired MOC Course 20764A - Administering a SQL Database Infrastructure.

The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.
Course Details


5 days


  • Experience using applications on Windows Servers
  • Experience working with SQL Server or another RDMS

Target Audience

  • Individuals who administer and maintain SQL Server databases.
  • Individuals who develop applications that deliver content from SQL Server databases.

Skills Gained

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Use encryption and auditing features to protect data
  • Describe recovery models and backup strategies
  • Backup and 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
Course Outline
  • SQL Server Security
    • Authenticating Connections to SQL Server
    • Authorizing Logins to Connect to databases
    • Authorization Across Servers
    • Partially Contained Databases
  • Assigning Server and Database Roles
    • Working with Server Roles
    • Working with Fixed Database Roles
    • User-Defined Database Roles
  • Authorizing Users to Access Resources
    • Authorizing User Access to Objects
    • Authorizing Users to Execute Code
    • Configuring Permissions at the Schema Level
  • Protecting Data with Encryption and Auditing
    • Options for auditing data access in SQL Server
    • Implementing SQL Server Audit
    • Managing SQL Server Audit
    • Protecting Data with Encryption
  • Recovery Models and Backup Strategies
    • Understanding Backup Strategies
    • SQL Server Transaction Logs
    • Planning Backup Strategies
  • Backing Up SQL Server Databases
    • Backing Up Databases and Transaction Logs
    • Managing Database Backups
    • Advanced Database Options
  • Restoring SQL Server Databases
    • Understanding the Restore Process
    • Restoring Databases
    • Advanced Restore Scenarios
    • Point-in-Time Recovery
  • Automating SQL Server Management
    • Automating SQL Server management
    • Working with SQL Server Agent
    • Managing SQL Server Agent Jobs
    • Multi-server Management
  • Configuring Security for SQL Server Agent
    • Understanding SQL Server Agent Security
    • Configuring Credentials
    • Configuring Proxy Accounts
  • Monitoring SQL Server with Alerts and Notifications
    • Monitoring SQL Server Errors
    • Configuring Database Mail
    • Operators, Alerts, and Notifications
    • Alerts in Azure SQL Database
  • Introduction to Managing SQL Server by using PowerShell
    • Getting Started with Windows PowerShell
    • Configure SQL Server using PowerShell
    • Administer and Maintain SQL Server with PowerShell
    • Managing Azure SQL Databases using PowerShell
  • Tracing Access to SQL Server with Extended Events
    • Extended Events Core Concepts
    • Working with Extended Events
  • Monitoring SQL Server
    • Monitoring activity
    • Capturing and Managing Performance Data
    • Analyzing Collected Performance Data
  • Troubleshooting SQL Server
    • Applying a Troubleshooting Methodology
    • Resolving Service-Related Issues
    • Resolving Connectivity and Login issues
  • Importing and Exporting Data
    • Transferring Data to and from SQL Server
    • Importing and Exporting Table Data
    • Using bcp and BULK INSERT to Import Data
    • Deploying Data-Tier Applications