Master SQL and learn how to confidently query and manipulate data in a relational database.

Learn SQL at your offices, one of our training centres or live online.

SQL Courses

 
MS SQL Server Integration Services (“SSIS”) Course

SQL

SSIS

4 days
 
MS SQL Server Reporting Services (“SSRS”) Course

SQL

SSRS

4 days

Choosing The Right Course

 

If you are unsure which course would be best for you please call us we will be very happy to advise you.

Our introduction training course is for total beginners. You do not need any previous experience with SQL to attend.

This course is designed for people who will be:

1. Working with advanced SQL queries and stored procedures that have been created by a database analyst.
2. Creating simple queries from scratch.
3. Going on to attend our advanced SQL course as they develop their database knowledge.

By the end you will be able to:

1. Write basic queries, using wildcard characters and comparison operators.
2. Perform calculations in SQL.
3. Group and Count data.
4. Understand the basics concepts of databases like joins, database tables and schema.

Our advanced course is for people who are basic SQL users and want to build their SQL skills further.

It is designed for people who will be creating complex queries and views, and managing databases.

By the end you will be confident using:

1. Advanced queries like IF, CASE and UNION.
2. Error trapping techniques and working with ROLLBACK and COMMIT.
3. Stored procedures and creating views.

The combined course is a combination of our Introduction to Power BI course and our Advanced course.

We offer a discount when these two courses are booked at the same time.

Our SQL courses can be run at your offices, at one of our training centres in London and Guildford or online.

Our online learning can be run using either Zoom or Microsoft Teams.

We also regularly provide private courses. Again these can be run in a classroom or virtual environment.

bp logo
clancy docwra logo
EA logo
legal & general logo
nhs direct logo
rentokil initial logo
shell logo
Logo For Three Mobile
Logo For UK Home Office
Mercedes Benz logo
bhpbilliton logo

FAQs

This SQL training course is carried out using MS SQL Server 2017.

You will be provided with a PC running a SQL database and MS SQL Server Management Studio (MS SQL SMS).

MS SQL Server Management Studio is a database management system used to access and manage a SQL database.

Yes, the basics of SQL are the same no matter the environment.

Database management and database design do not change between different SQL derivatives.

The differences in the programming language when using a derivative of SQL (for example, T-SQL) or when working in different environments are small.

Our trainers are more than happy to chat with you about these small differences as you go through the day.

SQL is short for structured query language.

It is the standard language used to manipulate data held in relational databases.

Oracle, Sybase, Microsoft SQL Server and Access are all relational databases that use SQL.

SQL is not difficult to learn if you have some experience with computers and information technology.

As with anything new, it is easiest if done with help from an instructor who has real-world experience of working with a SQL database.

For someone interested in big data, data science or data analysis a good knowledge of SQL is foundational.

It shouldn’t take you more than a couple of weeks to become competent using SQL.

If you don’t have access to a database, SQL and Microsoft SQL Server Management Studio are available as free downloads so you can set up a practice environment for free.

We do not offer formal professional certification.

We do provide everyone that completes one of our courses a course certificate.