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.

Program Details
Duration 5 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact