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.