Supporting Microsoft SQL server

Description

Supporting Microsoft SQL server course description

A concise hands on course enabling delegates to
manage and administer a Microsoft SQL server
database.

What will you learn

Install SQL server.

Backup SQL server databases.

Recover SQL server databases.

Secure SQL server databases.

Perform routine maintenance.

Automate tasks.

Supporting Microsoft SQL server course details

Who will benefit:

Anyone working with Microsoft SQL server

Prerequisites:

Supporting Windows server.

Duration

3 days

Supporting Microsoft SQL server course contents

SQL server introduction

Platform, Tools, services. Installation. Creating databases.

Backups

Back up types, transaction logging, restoring from a backup: Full database, individual files.

Security

Users, server roles, database roles. Permissions.

Monitoring

Routine database maintenance. Performance data.

Jobs and alerts

The SQL server agent, database mail, alerts, jobs.