Our SQL training courses are led by certified, highly experienced database administrators.

They are very hands-on and practical. We include a number of real-life examples and scenarios in the courses to maximise the impact that these courses will have on your day-to-day work after the course.

We offer scheduled SQL training at our centres in Guildford and London.

We also frequently provide custom training at our customers' offices and our centre in Manchester. This allows us to customise the course content to your exact requirements and to run the course on a date to suit you.

Not sure about anything? Please call us we're very happy to help.

What’s New In SQL Server 2016 (2 Days)

What’s New In SQL Server 2016

2 days

This is designed for experienced DBAs working on MSSQLS 2014 or earlier.

Understand the new features in SQL Server 2016 and how to make best use of the.

Learn to confidently:

  1. Work with Query Store and Statistics, and temporal tables.
  2. Use “Always Encrypted”, dynamic data masking and row-level security to improve security.
  3. Implement SQL Server hybrid cloud, Azure SQL database and enhanced backup and BI features.

Performance Tuning And Optimizing SQL Databases (3 Days)

Performance Tuning And Optimizing SQL Databases

3 days

This course is designed for DBAs working with databases day-to-day.

Understand how to get the best performance from your databases.

Learn to confidently:

  1. Implement best practice relating to Concurrency, Transactions and Isolation Levels.
  2. Work with Optimiser to fix query plan.
  3. Identify and diagnose performance bottlenecks.

SQL Training – Introduction

Introduction To SQL

1 day

This course is designed for people new to SQL.

Master the basics of SQL and work independently with databases.

Learn to confidently:

  1. Work with relationship databases by understanding the basics of how they are set up and structured.
  2. Select, sort, insert, delete and update a database using SQL.
  3. Run mathematical calculations and also use aggregate functions.

SQL Training – Advanced

Advanced SQL

2 days

This is an intermediate course for people comfortable working with SQL.

Master SQL’s more advanced functions and become an expert user.

Learn to confidently:

  1. Create a database, specify data types and create primary keys and other relationships.
  2. Use SQL scripts, advanced select queries and sub-queries.
  3. Work with views, access control and transaction control.

MS SQL Server Administration – Fundamentals

MS SQL Server Administration - Fundamentals

3 days

This course is for experienced SQL users.

Master the basics of administering a MS SQL Server database.

Learn to confidently:

  1. Install and configure an instance of SQL Server, and configure and manage a database on it.
  2. Set up database security and back ups, and automate repetitive tasks.
  3. Monitor and troubleshoot a database and manage transactions and locking.

SQL Server Training – Advanced Administration

MS SQL Server Administration - Advanced

2 days

A course for advanced SQL users with experience of working with databases.

Become an advanced database administrator able to use SQL Server’s most advanced features.

Learn to confidently:

  1. Optimise the performance of your database.
  2. Maintain high availability with clustering, and to use replication for redundancy.
  3. Use DTS (Data Transformation Services) to transfer data.

MS SQL Server Reporting Services (“SSRS”) Course

MS SQL Server Reporting Services (“SSRS”)

4 days

A course for experienced SQL users.

Master SSRS and make full use of the power of SSRS.

Learn to confidently:

  1. Author reports and enhance them with maps and drill down reports.
  2. Work with parameters and visualise data using maps, spark lines, gauges and charts.
  3. Manage your report server, distribute reports and control access to reporting server content.

MS SQL Server Integration Services (“SSIS”) Course

MS SQL Server Integration Services (“SSIS”)

4 days

This course is design for experienced SQL users.

Master SSIS and discover how simple and controlled data transfer and ETL can be.

Learn to confidently:

  1. Work in SSDT and create an SSIS connect in SSDT.
  2. Design and implement a control and data flow, and control packages.
  3. Work with containers, data warehousing and advanced ETL.

Implementing A SQL 2016 Data Warehouse (4 Days)

Implementing A SQL 2016 Data Warehouse

4 days

This course is for experienced database administrators looking to move into a Business Intelligence role.

Become a highly capable BI developer.

Learn to confidently:

  1. Create a data warehouse using SQL Server 2016.
  2. Use SQL Servers ETL tools.
  3. Validate and cleanse data with Data Quality Services and Master Data Services.

SQL Report Builder 3.0 Training

Report Builder 3.0 Training

2 days

For advanced Excel users with a knowledge of SQL or advanced Access users wanting to work with Microsoft Report Services.

Become a fast, capable Report Services user.

Learn to confidently:

  1. Create a report using Report Builder.
  2. Manipulate group and summarise data including using data regions.
  3. Edit and manager reports using Parameters, Filers and Sub-reports.

Course Approach

Our courses are deliberately very hands-on and interactive.

We believe that real practical skills are only developed through practice and so we make sure that you spend plenty of time using the techniques that we teach you during your course. That way you leave the course confident and ready to put them to use.

We use carefully chosen exercises which reinforce the key learning points of each lesson. Our instructors are on hand through out to answer any questions that you might have.

Course Locations

Our scheduled courses run in Guildford and London.

Our London training centre is in the heart of the City of London. It is only a short walk from Fenchurch Street, Liverpool Street and Cannon Street overland stations. It is also very close to Bank, Tower Hill and Cannon Street tube stations.

Our Guildford centre is in the Surrey Technology Centre, which is next door to the Royal Surrey Hospital.

We are also very happy to come to you and provide training at your offices, or we can run courses at our Manchester centre.

Our Manchester centre is in the heart of Manchester. It is only a very short walk from Oxford Street and Piccadilly stations.


Please don’t hesitate to call us if you have a question, we are very happy to help.

We train use a Microsoft SQL Server set up for all of these courses.


Our courses run on Microsoft SQL Server and so are run teaching T-SQL.

There are different variants of SQL used by other database providers like MariaDB, Oracle and MySQL.

Most of these systems include some proprietary terms within their SQL. However they are minor and regardless of this these courses will give you a very strong foundation. A capable SQL user can work very comfortably with any of these databases.

If you are a user of another type of database our trainers will be very happy to mention the few differences as they work their way through the course.


We provide everything that you will need for a full day of training.

You will have your own laptop to work on and be given a USB to take your exercises home with you.

You will also receive your own A4 full-colour manual.

Most importantly we provide plenty of refreshments and biscuits through the day and a delicious lunch.

Please wear whatever you are most comfortable in.

Most people attending our courses wearing casual clothing.

No problem.

For the 6 months after your course, if you have a question or issue simply email us the question and your trainer will either call or email you to help you out.

We will provide you with an individual certificate of attendance to demonstrate that you have completed the course.

No problem.

Please give us as much notice as possible and we will let our caterers know.

SQL is the international standard language for querying and manipulating relational databases. It allows users to very quickly interrogate, edit and amend database tables.

It is the ANSI (American National Standards Institute) and the ISO (International Organisation for Standardisation) standard language for communicating with relational databases.

SQL was first developed by IBM during the early 1970’s and is fundamentally unchanged since then. It’s structure of using Clauses, Expressions, Predicates, Queries and Statements is still used.

Clauses are the underlying discrete parts of a statement or query.

Expressions are formulas which produce values or tables.

Predicates are conditions that limit the application of a query.

Queries select a subset of the data in the database according to the various user input criteria. and Statements being used to make changes to the

Statements are used to make changes to the databases’ design or set up.

Similar Courses & Further References

Delegates interested in SQL training courses are often also interested in:

Microsoft Access Training

SQL Server Training

R Training

Further References

Further information on SQL can be found at the following websites:

W3 Website: SQL Section

Database Journal: What Is SQL Server?

See below for some of our articles on SQL

Using Union Queries in SQL and Access

Backup Types & Strategies for SQL Databases


Hear what previous attendees have had to say about this course

Have a question?

We're here to answer them

01483 688488

Contact us

We’re trusted by