+44 (0)1737 821590
Supporting Microsoft SQL server  |    A 3 day   hands on   training course

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

  • Dates & prices
  • Click here

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.

Learning path

Reviews

5.0

Based on overall ratings

P. C. - Medway NHS Foundation Trust

"The course was excellent and tailored to our specific needs."


S. A. - Arqiva

"Went above expectations great course I learnt a lot."

Training approach

This structured training course seeks to build upon workbook learning through the use of group exercises, dynamic discussion and individual tasks in order to deliver an engaging and interactive module that will ensure all candidates are able to transfer their new skills into the workplace.