Skip to the content

DC160 SQL Server Basics


The SQL Server Basics course is designed to give you the knowledge required to administer the day to day running of your SQL Server. The SQL Server Basics Course covers Database Creation, File Locations, Maintenance Plans, Backups, Restores, Encryption (database and backup) and basic performance monitoring.

Course Overview

The following is a list of the subjects covered in the course.

  • Microsoft SQL Server Management Studio
  • SQL Server Versions (Including SQL Azure) and Licensing
  • Database Files and Locations
  • File Sizes and Auto-grow
  • Recovery Models and Backup Strategies
  • Maintenance Plans
  • High Availability Overview
  • Encryption
  • Restricting Access
  • Security
  • Activity and Performance Monitoring


This course is applicable to competent IT users.


Our scheduled training courses are £250.00 per person per day. If you are coming to our site, parking and refreshments will be provided.

Terms & Conditions

For details on what to expect, dress code and general terms and conditions, please see our standard training T&Cs.

Terms & Conditions

Book Now!

Please fill in the following form to book onto this course.

Book Now


What will we do with your data? See our Privacy Policy for more information.

I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our team

Lee Crowhurst, Technical Director

Partner with the Experts

With over 200 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licencing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.