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 Days
Classroom & Live Online
Client Site Courses Available
20th Dec

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
Client Site Courses Available
12th, 13th Dec

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
Client Site Courses Available
20th, 23rd, 24th Dec

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

Go from complete beginner to SQL expert with 3 days of intensive classroom training led by a tutor with over 15 years of experience.

MS SQL Server Administration Fundamentals

SQL Administration - Fundamentals

3 Days
Live Online & Client Site
Client Site 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
Client Site 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
Client Site 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 about anything please don’t hesitate to get in touch and we’ll be delighted to help.

 

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.

 

Our advanced course is for basic SQL users who want to develop 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.

 

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.

 

Our teaching is very hands-on.

Each lesson starts with the tutor explaining a topic from the curriculum.

Once the tutor has clearly explained a topic the course moves on to practice exercises which let the class practice that topic.

The instructor is on-hand throughout to ensure everyone has a good understanding.

We also regularly provide private classes where our instructor runs private lessons for a group from one company.

These courses can be run as classroom courses or remote courses, and we can customise the curriculum if required.

Our teaching style remains the same with lots of practice at the end of each lesson to ensure you have fully understood the topics that you have been studying.

 

We’re Trusted By

London Training Centre

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

Directions

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 course manual A full-colour course manual
Your course exercises to practice at home Your course exercises to practice at home
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

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.

 

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

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

 

 

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 a tutor who has real-world experience of working with a SQL database which our tutors all do.

 

We do not offer formal professional SQL certification.

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