Private Bookings:

As a result:

This course is only available as a private booking for an individual or group.

  1. We are able to run courses on dates to suit you,
  2. We can customise the course content for you,
  3. We can offer discounts for larger group bookings.

Our private courses can run online, in-person at your offices or at one of our training centres.

Please contact us for full details.

Award Winning
9 years in a row
Expert Trainers
Average experience: 12 years
Small Classes
Average 4 people per class
Moneyback Guarantee
100% money-back guarantee

SQL Courses

SQL Training – Introduction

SQL Introduction

1 Day
Classroom & Live Online
Onsite Courses Available
26th Mar

This course leads beginners through the basics of SQL step-by-step.

  • Introduction to SQL
  • Relational database essentials
  • SELECT & WHERE statements
  • Mathematical calculations
  • Grouping & Counting data
SQL Training – Advanced

SQL Advanced

2 Days
Classroom & Live Online
Onsite Courses Available
27th, 28th Mar

Build on your SQL skills and learn to use more advanced functions.

  • Advanced SELECT statements
  • Transactions & rollback
  • Using sub-queries
  • Views & Window functions
  • Building stored procedures
SQL Training: Combined Course (SAVE £130)

SQL Combined (save £130)

3 Days
Classroom & Live Online
Onsite Courses Available
26th, 27th, 28th Mar

The fastest way to go from complete beginner to SQL expert.

Save £130 when you book our Introduction and Advanced SQL courses at the same time.

MS SQL Server Administration Fundamentals

SQL Administration - Fundamentals

3 Days
Live Online & Client Site
Onsite Courses Available

Learn how to administer and troubleshoot MS SQL Server.

  • Installing & configuring SSMS
  • Database & server security
  • Backing up and restoring data
  • Automating day-to-day tasks
  • Optimising performance
MS SQL Server Integration Services (“SSIS”) Course

SQL SSIS

4 Days
Live Online & Client Site
Onsite Courses Available

Learn how to implement SSIS for data transfer and ETL operations.

  • Creating a new SSIS project
  • Designing control & data flow
  • Using containers
  • Deploying & managing projects
  • Data warehousing
MS SQL Server Reporting Services (“SSRS”) Course

SQL SSRS

4 Days
Live Online & Client Site
Onsite Courses Available

Use SSRS to design and manage reports in MS SQL Server.

  • Creating & authoring reports
  • Using tables, matrices & charts
  • Designing professional reports
  • Working with Report Server
  • Controlling access to reports

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 and answer your questions.

Our SQL basics course is for total beginners. You do not need any previous experience with SQL to attend, there are no prerequisites for this course.

This course is designed for people who are learning SQL so that they can:

1. Working with advanced SQL queries and stored procedures that have been created by a database analyst / SQL developer.
2. Creating simple SQL queries and SQL statements 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 a basic SQL query, using wildcard characters and comparison operators.
2. Perform calculations in SQL and create SQL statements
3. Use aggregate functions like GROUP and COUNT to summarise data.
4. Understand the basic concepts of databases like SQL joins, database tables and schema.
5. Use a relational database management system like MS SQL Server Management Studio.

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, working with multiple tables and subqueries 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. Creating a stored procedure and creating views.

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

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

This is the fastest way to learn SQL and go from a complete beginner to someone confident programming using structured query language for data analysis.

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

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

We also regularly provide private courses. Again, these can be run as classroom courses or remote courses, so you have the flexibility to choose the type of course that suits you best.

We’re Trusted By

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) when you attend one of our classes.

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 derivatives of SQL server databases.

The differences in the programming language when using a derivative of SQL (for example, T-SQL, transact SQL, mysql or oracle sql) or when working in different environments (like MySQL, MariaDB, PostgreSQL and Oracle) are small.

Our trainers are more than happy to chat with you and answer questions about these 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 real world relational databases that use SQL.

Learning SQL is not difficult 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 and ideally a background in big data or data science.

Each of our SQL courses contains in-depth lessons to help our delegates become professional SQL users with our teachers adapting courses so that we don’t go faster than your pace.

We offer courses from beginner through to advanced level and include topics like manipulating data, data analytics, scripting and temporary tables.

You’ll soon be using data types, queries, commands, syntax and sub-queries.

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 SQL certification.

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

These courses are relevant for anyone thinking about a career in big data, business intelligence, data science or data analysis.

In all of these careers, a good knowledge of SQL fundamentals is foundational.

For people more focused on a career in IT, like database administrator or database analyst, understanding how to work with SQL Server databases to a high level is critical.

SQL combines we’ll with other programming languages like JavaScript, PHP, CSS and Python. By learning SQL, you will up-skill and broaden your programming abilities.

The Training Day

Course Times

9.15 - 9.30
Arrival
9.30 - 11.00
Training Session 1
11.00 - 11.15
Break
11.15 - 12.30
Training Session 2
12.30 - 13.30
Lunch
13.30 - 14.45
Training Session 3
14.45 - 15.00
Break
15.00 - 16.30
Training Session 4

What's Included?

Everything you need for a great day's training.

A full-colour manual to take home with you A full-colour manual to take home with you
A USB stock to keep your exercises on A USB stock to keep your exercises on
Pens & pads to take notes Pens & pads to take notes
Plenty of tea, coffee and biscuits Plenty of tea, coffee and biscuits
6 months of post course support 6 months of post course support
A comfortable, modern air-conditioned training room A comfortable, modern air-conditioned training room

Locations

London Training Venue & Course Details
St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150

Directions


Guildford Training Venue & Course Details
Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

Directions