Administering Microsoft SQL Server Databases

Learn via : Virtual Classroom / Online
Duration : 5 Days
  1. Home
  2. /
  3. Administering Microsoft SQL Server Databases


    In this course, you will learn the skills required to maintain a Microsoft SQL Server database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.


    Delegates will learn how to 

    • Core database administration tasks and tools
    • Install and configure SQL Server
    • Configure SQL Server databases and storage
    • Plan and implement a backup strategy
    • Restore databases from backups
    • Import and export data
    • Monitor SQL Server
    • Trace SQL Server activity
    • Manage SQL Server security
    • Audit data access and encrypt data
    • Perform ongoing database maintenance
    • Automate SQL Server maintenance with SQL Server Agent jobs
    • Configure database mail, alerts, and notifications


Introduction to SQL Server Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques

Installing and Configuring SQL Server

  • Plan SQL Server Installation
  • Install SQL Server and Post-Installation Configuration

Work with Databases and Storage

  • Introduction to Data Storage with SQL Server
  • Manage Storage for System Databases and User Databases
  • Move Database Files
  • Configure the Buffer Pool Extension

Plan and Implement a Backup Strategy

  • SQL Server Recovery Models
  • Plan a Backup Strategy
  • Backup Databases and Transaction Logs
  • Backup Options and Backup Reliability

Restore SQL Server Databases

  • Restore Process and Databases Restoration
  • Advanced Restore Scenarios
  • Point-in-Tim Recovery

Import and Export Data

  • Transferring Data
  • Import and Export Table Data
  • Copy or Move a Database
  • Monitor SQL Server
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor

Tracing SQL Server Activity

  • Trace SQL Server Workload Activity and Use Traces

Manage SQL Server Security

  • Introduction to SQL Server Security
  • Manage Server-Level Security and Database-Level Principals
  • Manage Database Permissions

Audit Data Access and Encrypt Data

  • Audit Data Access in SQL Server
  • Implement SQL Server Audit
  • Encrypt Databases

Perform Ongoing Database Maintenance

  • Ensure Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance

Automate SQL Server Management

  • Implement and Manage SQL Server Agent Jobs
  • Manage Job Step Security Contexts
  • Manage Job on Multiple Servers

Monitor SQL Server Using Alerts and Notifications

  • Monitor SQL Server Errors
  • Configure Database Mail
  • Configure Operators, Alerts, and Notifications


There are no prerequisites for this course.