Browse all IT training courses

Microsoft SQL Server Administration

Click here for a PDF version

Introduction

Microsoft SQL Server is an enterprise level relational database management system (RDBMS). It is suitable for databases where users are accessing the database simultaneously. 

Objectives

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server. 

Designed for

New database administrators. No previous knowledge of SQL Server is required, but an understanding of relational databases is an advantage. 

Duration

Five Days 

Topics

  • SQL Server Overview
  • What is SQL Server?
  • SQL Server Integration
  • SQL Server Databases
  • SQL Server Security
  • Working with SQL Server
  • Planning to Install SQL Server
  • Hardware Considerations
  • Software Considerations
  • Installing SQL Server
  • Verifying the Installation
  • Configuring SQL Server Enterprise Manager
  • Troubleshooting
  • Managing Database Files
  • Introduction to Data Structures
  • Creating Databases
  • Managing Databases
  • Placing Database Files and Logs
  • Optimising the Database Using Filegroups
  • Capacity Planning
  • Performance Considerations
  • Transferring Data
  • Tools for Importing and Exporting Data in SQL Server
  • Transforming Data with DTS
  • Access Projects
  • Creating an Access frontend
  • Forms
  • Reports
  • SQL Server and the Web
  • Creating XML documents
  • Interactive web-pages
  • Backing Up Databases
  • Setting and Changing a Database Recovery Model
  • When to Back Up Databases
  • Performing Backups
  • Types of Backup Methods
  • Planning a Backup Strategy
  • Restoring Databases
  • SQL Server Recovery Process
  • Preparing to Restore a Database
  • Restoring Backups
  • Restoring Databases from Different Backup Types
  • Restoring Damaged System Databases
  • Monitoring SQL Server for Performance
  • Why to Monitor SQL Server
  • Performance Monitoring and Tuning
  • Common Monitoring and Tuning Tasks
  • Managing Security
  • Implementing an Authentication Mode
  • Logins for to Users and Roles
  • Permissions for Users and Roles
  • Security Within SQL Server
  • Managing Application Security
  • Managing SQL Server Security in the Enterprise
  • Performing Administrative Tasks
  • Configuration Tasks
  • Routine Administrative Tasks.
  • Automating Maintenance Tasks

Follow-up

Individual consultancy and tuition as required 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses