IT SQL Server Administration

Course Code: SQL4ADM



4 Day(s)

Course Type

Public or Private

Max Delegates


Delivery Style


Enabling you to administer, configure and support major aspects of Microsoft SQL Server databases.

Microsoft SQL Server is a powerful data platform that will help you quickly build solutions and insights across the organisation.  With the further development of SQL Server Always On technologies, it provides near zero downtime. To benefit from such a powerful product, you will need to be able to identify, configure, and support all major aspects of Microsoft SQL Server. This course is designed for the Microsoft Windows Server environments using any version of SQL Server.

Book Your Course

Start Date





WR1 - Worcester, WR1 3EE




WR1 - Worcester, WR1 3EE




WR1 - Worcester, WR1 3EE



Course confirmed - Guaranteed to run
Course Full/Limited availability
Price shown excluding VAT.

Book a Private Event

If you require the content of this event tailored or have around 7 or more people to train it maybe better for you to host a Private Event, please get in touch to discuss this.

Get in touch


Who is this course for

Database administrators and support technicians who need to be able to implement and manage Microsoft SQL Server databases.

Purpose of the course

The course covers essential topics in SQL Server Administration including installation, using policies, security, backup, recovery, availability management and monitoring. The course will include lectures, demonstrations and exercises to consolidate the topics covered.

You will learn how to

Install an instance of SQL Server
Create and Configure databases
Backup and restore databases
Maximise the availability of SQL Server
Create logins
Manage user and role permissions
Prevent transaction logs from using unlimited disk space
Monitor SQL Server databases


Delegates must have a good working knowledge of Microsoft SQL Server. This can be obtained by attending our SQL Server Essentials course. Delegates must also have a basic knowledge of Microsoft Windows.

Benefits for you as an individual

Many roles now require knowledge of SQL Server. This course will equip you with the skills to manage and support Microsoft SQL Server. You will have confidence in the major topics for SQL Server administration.

Benefits for your organisation

SQL Server has become a popular choice for enterprise wide applications. This course will give your organisation the confidence to exploit, manage and support this product both safely and securely. It will help ensure best practices are being followed with SQL Server.

Overview of SQL Server Concepts and Features

  • SQL Server Features
  • Server Components
  • Architecture
  • Administering SQL Server

Installing SQL Server

  • SQL Server Editions
  • Installing Microsoft SQL Server
  • System Requirements
  • Performing SQL Server Setup
  • Installing SQL Server
  • Exercise Installing a SQL Server Instance
  • Upgrading from Previous Versions of SQL Server
  • Exercise Using the SQL Server Data Migration Assistant
  • Post-Installation Configuration
  • Dedicated Administrator Connection
  • Exercise Post-Installation Configuration

Designing and Implementing Databases

  • Organising Data
  • Buffer Pool Extension
  • Post-Installation Databases
  • Database Files
  • Planning a Database
  • Creating Databases
  • Working with Filegroups
  • Unstructured Data – FILESTREAM and FileTables
  • Database Options
  • Managing Databases

Securing SQL Server

  • SQL Server Security
  • SQL Server Security Terminology
  • Authentication Modes
  • Database Access Security
  • Permissions and Securables
  • Managing Schemas
  • Contained Databases
  • Policy-Based Management
  • Transparent Data Encryption
  • Simple Auditing
  • Further Information

Importing, Exporting and Linking Databases

  • Overview of Data Transfer
  • Microsoft Data Migration Assistant
  • Copy Database Wizard
  • Detach and Attach
  • Import Export Wizard
  • Linked Servers
  • Other Data Transfer Methods

Disaster Recovery

  • Disaster Recovery Fundamentals
  • Basic Backup and Restore Operations
  • Further Backup and Restore Concepts
  • Backup Strategies
  • Crash Recovery
  • Recovering System Databases
  • SQL Server Managed Backup to Windows Azure

Enhancing Database Availability

  • SQL Server Data Availability
  • Clustering SQL Server
  • Database Snapshots
  • Exercise Creating Database Snapshots
  • Database Mirroring
  • AlwaysOn Availability Groups
  • Exercise AlwaysOn Availability Groups
  • Replication
  • Configuring Replication
  • Exercise Replication
  • Log Shipping

Monitoring the Database Server

  • Database Mail
  • Using Operators and Alerts
  • Monitoring with Extended Events Sessions
  • Monitoring with SQL Profiler
  • Using Windows Performance Monitor
  • SQL Server Logs
  • Activity Monitor
  • Performance Data Collection
  • SQL Server Utility
  • Using DBCC to Check Integrity

Maintenance and Optimisation

  • Managing Jobs
  • Maintenance Plans
  • Implementing Multiserver Jobs
  • Viewing the Execution Plan
  • Using the Database Engine Tuning Advisor
  • Index Fragmentation
  • Resource Governor
  • SQL Server Configuration

Get Started

Forget trawling through endless course catalogues – Find the training that’s right for you

Learn More

Latest from our blog

Kanban and Agile: Bridging the Gap

Kanban and Agile: Bridging the Gap Quanta’s Kanban University Certified Trainer Steve Church explores the way in which Agile and…
Read More

How a Ballerina could move into Cybersecurity

Jason Ford, Quanta Cybersecurity and IT Trainer talks about the limitations in Cybersecurity Training courses. Jason discusses a safe and…
Read More

Boost Team Performance and Productivity: Unlocking the Advantages of Emotionally Intelligent Leadership

Quanta People Development and Leadership Trainer, Giles Collins outlines the key elements of Emotionally Intelligent Leadership and how it impacts…
Read More