• 0208 432 6218
  • WhatsApp
  • Register

SQL Intermediate to Advanced

An Advanced level 12-hour course delivered via Instructor-led Physical Classes or Virtual Classes.

View Dates
Regular Price: ÂŁ420 (Approximately $572.73 USD)
Batch Price: From ÂŁ360 (approx. $491 USD)  đź“…  View Dates & Prices
Group Booking Discount: From ÂŁ240 per person(approx. $327 USD)  đź§® Calculate & Book
1-to-1 Training: ÂŁ420(approx. $573 USD)  đź“‹ Booking Request Form

Course Overview

Presently, individuals with an understanding of advanced SQL techniques are in great demand by employers. Advanced SQL knowledge can help you to enhance your position if you are already in employment.

This course is designed to further your understanding of structured query language (SQL) and improve your skills and expand your knowledge. Our Intermediate to Advanced SQL course builds upon the skills learnt in our Introduction to SQL course. It covers windowing, CTEs, dynamic SQL, logical functions, control flow, creating user-defined functions, stored procedures and cursors. You'll also learn how to improve query performance, transaction processing and error handling.

Requirements

You should have a prior understanding of SQL to attend this course.

We highly recommend you complete the following course(s) before attending the SQL Intermediate to Advanced course:

Course Content

  1. Aggregate Queries with Multiple Tables
  2. Temporary Tables and Table Variables
    • Using temporary tables
    • Creating table variables
  3. Common Table Expressions (CTE)
    • Introduction to CTE
    • Using CTE
    • Multiple CTE in a single query
  4. Logical Functions
    • CASE Statement/Expression
    • Using CASE with aggregate functions
    • Using IIF Function
  5. Variables and Decision Making
    • Introduction to variables
    • Local variables
    • Using Global variables
    • Table Variables
    • Control Flow - IF…ELSE
  6. User-Defined Functions - UDFs
    • Introduction to UDFs
    • Creating a Scalar-Valued Function
  7. Stored Procedures
    • Introduction to Stored Procedures
    • Creating User Stored Procedures
    • Stored Procedure with Parameters
  8. Dynamic SQL
  9. Windowing

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Scroll right for more details
Delivery MethodDates & TimesHoursPriceEnrolment
Online Training using Zoom
17 Feb 2026 - 26 Feb 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
15 Mar 2026 - 29 Mar 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Classroom Training
16 Mar 2026 - 17 Mar 2026
Monday to Tuesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
17 Mar 2026 - 26 Mar 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
21 Apr 2026 - 30 Apr 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
10 May 2026 - 24 May 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
19 May 2026 - 28 May 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
23 Jun 2026 - 02 Jul 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
05 Jul 2026 - 19 Jul 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now
Online Training using Zoom
28 Jul 2026 - 06 Aug 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
ÂŁ360 ÂŁ420
(approx. $491 USD)
Enrol Now

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Participant Reviews

“An excellent course experience covering many different topics in detail and practising much of the learning with practical exercises. The tutor was very good at breaking down the specific aspects and challenges in each of the topics and worked through examples that enabled a better learning experience. Very happy and look forward to undertaking further courses with LAIT in the future!”

Mohammed, 9 July 2025

“I also attended the beginner course in the same week. Younus was a great teacher, explained concepts well and when I wasn't understanding new content would be patient and helpful.

My only negative was turning up on my first day and being the only person in my 'in-person' class with the others being online. Classroom (more of an office environment) is a little dated. If I had known this, I would have attended online myself. So not a huge gripe just more of an organisational one.

Overall, I am very happy with the course and feel it has solidified what I already knew as well as helping me take on harder challenges SQL wise in my current role.”

Priscilla 24 April 2025

“Shohel did a great job with the SQL Intermediate to Advanced training. The material was clearly explained and we worked through examples together. Shohel also took the time to answer any questions. The course helped me to feel more confident with writing SQL queries.”

Miko, 25 September 2024

Related Posts

×

Popular Courses

Useful Links

Share this page now!

What we do?

At London Academy of IT, we provide instructor-led online and in-person IT training in Data Analytics, SQL, Python, Power BI, and more. Our cutting-edge courses are designed to boost performance and enhance employability, providing the competitive edge employers look for.

Our Contacts

London Academy of IT
64 Broadway
Stratford
London E15 1NT
United Kingdom

Call us: +44 (0)208 432 6218
WhatsApp: +44 0749 461 6045

Chat with London Academy of IT on WhatsApp

Regional Training

USA | UAE | Ireland

2012 - 2026 © London Academy of IT Limited. All Rights Reserved.
UKPRN: 10045491. Registered in England & Wales with company no. 07923992.