Cademy logoCademy Marketplace

Course Images

Supporting Microsoft SQL server

Supporting Microsoft SQL server

By Systems & Network Training

5.0(3)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • You travel to organiser or they travel to you

  • Redhill

  • 3 days

  • All levels

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.

About The Provider

Systems & Network Training

Tags

Reviews

+ Add Review