SQL Training

SQL logo transparent

Professional SQL courses. You are taught by certified experts.

Small classes. You’ll have lots of time to ask questions.

Hands-on practice. You’ll leave a faster, more capable SQL user.

Multi award-winning. You can be sure things will go smoothly.

Convenient. Our centres are modern and easily accessible.

Speed up your day-to-day workflow and reporting and free up your time.

Got a question? Not sure about something? Call us: 0203 603 0150 / 01483 688 488.

Not sure if SQL Introduction or SQL Advanced is the right course for you?
We’ve created a quick video to walk you through what we cover in these courses.

To expand the video click the square in the bottom righthand corner.

Which course are you interested in?

SQL Training - Introduction

Master the basics of SQL. Learn how to select, sort, insert, delete and update a database using SQL.
NEXT COURSE: 30 May 2019

SQL Training - Advanced

Learn how to use views, access control, transaction control, advanced select queries and SQL scripts.
NEXT COURSE: 23 May 2019

MS SQL Server Integration Services ("SSIS") Course

Learn to use SSIS for data transfer and ETLing in a controlled and protected way.

MS SQL Server Administration Fundamentals

Master the basics of administering a MS SQL Server 2014 database.

Which Course Is Right For Me?

Introduction1 DayThis is an introductory course. It assumes no prior knowledge of relational databases.
Advanced2 DaysThis course assumes you already have a good understanding of SELECT queries.
It covers more advanced concepts like transaction processing, the use of UNION and JOIN and parameterised data.
SSRS4 DaysThis course assumes familiarity with MS SQL Server and SQL Server Management Studio as well as the SQL language and using the SELECT statement in particular.
It covers all aspects of SSRS including the design, creation and authoring of advanced reports.
SSIS4 DaysThis course assumes familiarity with MS SQL Server and SQL Server Management Studio as well as the SQL language.

It covers all aspects of using SSIS for data transfer and ETLing of data, including database security, logging and error handling.

Fundamentals of Server Administration3 DaysThis course assumes you already have a good understanding of the SQL language, the MS Server environment and the basics of relational database design.

It covers the basics of the installation, configuration and creation of databases. It also looks at task automation and database monitoring and troubleshooting.


Unsure which course is right for you? Please call us on 01483 688488. We’d be very happy to advise you.

In-House or On Site Training

We frequently deliver our training to teams at in-house. Please call us if you would like to discuss this.

Organising an in-house training session allows us to tailor the course content specifically to your requirements and run the course at a time and place of your choosing.


Course Approach

Everything in our course is aimed at making you a faster and more relaxed SQL user.

We believe that real querying skills and in-depth understanding can only be developed through practical application. This means that our courses are deliberately hands-on and include lots of practical examples.

This ensures that you spend plenty of time constructing and working with database queries and database tables. Our exercises are carefully chosen to emphasise the most important aspects of each lesson.

From a high-level SQL can appear deceptively simple. However, when you apply its concepts across large datasets it very quickly becomes complex, requiring a detailed understanding of how it works.

There are often multiple ways to approach something in when working with databases. Using the correct method to approach an operation can mean that it runs orders of magnitude more quickly, speeding up your day-to-day work hugely.

Uses Of Structured Query Language ("SQL")

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.

Widely used databases that run on SQL include Oracle, Sybase, Microsoft SQL Server and Access as well as newer systems like MariaDB, Microsoft Azure and MySQL.

Most of these systems also include some proprietary terms within their SQL. However, regardless of this, a capable SQL user can still work with these databases.

Microsoft has a very widely used database product SQL Server which is manipulated using SQL as you would expect. Access to SQL Server is also available over the cloud.

For more information on our courses relating specifically to Microsoft SQL Server click here.


Background & Overview

SQL was first developed by IBM during the early 1970’s and is fundamentally unchanged since that time. I’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.

Our classes will lead you through all of these concepts. We will ensure that you have both the theoretical underpinning and the practical knowledge to make the most of this powerful programming language.

Detailed Course Overviews

Introduction Class

This course will give delegates an introduction to the features and capabilities of Structured Query Language (SQL). It requires no previous knowledge of SQL.

It covers the basic elements of SQL using SQL Server as an example database.

Delegates will have a good understanding of the SELECT statement by the end of this one day course. This includes joining multiple tables, grouping, aggregate functions and sorting data.

Advanced Class

This course will further develop your ability manage a relational database and introduces data manipulation language and database definition language. It requires that you have a good understanding of the basics of SQL before you attend.

It uses Microsoft SQL Server as a training database.

After this course, delegates will have a good understanding of all DML statements (SELECT, INSERT, UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.

This 2 day course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.

Once you have completed this course you will be well placed to move to learning how to use SQL Server Reporting Services, (‘SSRS’) and other more advanced SQL courses.


A certificate of attendance will be provided to you upon completion of this course.

Similar Courses

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:    Why Use Databases?

See below for some of our articles on SQL

Using Union Queries in SQL and Access

Backup Types & Strategies for SQL Databases