SQL Intermediate to Advanced

Total Duration: 12-Hour
Course level: Advanced
Delivery Method: Instructor-led Physical Classes or Virtual Classes

Regular Price: £420 (Approximately $551.83 USD)
Batch Price: From £360 (approx. $473 USD)  📅 View Dates & Prices
Group Booking Discount: From £240 per person(approx. $315 USD)  🧮 Calculate & Book
1-to-1 Training: £420(approx. $552 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:

SQL for Beginners

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Time Zone:

Training Method	Dates and Times	Total Hours & Days	Price
Online Training using Zoom	18 Nov 2025 - 21 Nov 2025 Tue, Wed, Thu & Fri 09:00 AM - 12:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now
Online Training using Zoom	30 Nov 2025 - 14 Dec 2025 3 Sundays 05:00 AM - 09:00 AM ET	12-hour over 3-day	£360 £420 (approx. $473 USD)	Enrol Now
Online Training using Zoom	01 Dec 2025 - 03 Dec 2025 Mon, Tue & Wed 05:00 AM - 09:00 AM ET	12-hour over 3-day	£360 £420 (approx. $473 USD)	Enrol Now
Classroom Training	01 Dec 2025 - 03 Dec 2025 Mon, Tue & Wed 05:00 AM - 09:00 AM ET	12-hour over 3-day	£420 (approx. $552 USD)	Enrol Now
Online Training using Zoom	16 Dec 2025 - 19 Dec 2025 Tue, Wed, Thu & Fri 09:00 AM - 12:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now
Classroom Training	19 Jan 2026 - 20 Jan 2026 Monday to Tuesday 05:00 AM - 11:00 AM ET	12-hour over 2-day	£420 (approx. $552 USD)	Enrol Now
Online Training using Zoom	20 Jan 2026 - 29 Jan 2026 2 Tuesdays & 2 Thursdays 09:00 AM - 12:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now
Online Training using Zoom	01 Feb 2026 - 15 Feb 2026 3 Sundays 05:00 AM - 09:00 AM ET	12-hour over 3-day	£360 £420 (approx. $473 USD)	Enrol Now
Classroom Training	16 Feb 2026 - 17 Feb 2026 Monday to Tuesday 05:00 AM - 11:00 AM ET	12-hour over 2-day	£420 (approx. $552 USD)	Enrol Now
Online Training using Zoom	17 Feb 2026 - 26 Feb 2026 2 Tuesdays & 2 Thursdays 09:00 AM - 12:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now
Online Training using Zoom	15 Mar 2026 - 29 Mar 2026 3 Sundays 06:00 AM - 10:00 AM ET	12-hour over 3-day	£360 £420 (approx. $473 USD)	Enrol Now
Classroom Training	16 Mar 2026 - 17 Mar 2026 Monday to Tuesday 06:00 AM - 12:00 PM ET	12-hour over 2-day	£420 (approx. $552 USD)	Enrol Now
Online Training using Zoom	17 Mar 2026 - 26 Mar 2026 2 Tuesdays & 2 Thursdays 10:00 AM - 01:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now
Online Training using Zoom	07 Apr 2026 - 16 Apr 2026 2 Tuesdays & 2 Thursdays 09:00 AM - 12:00 PM ET	12-hour over 4-day	£360 £420 (approx. $473 USD)	Enrol Now

Course Content

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

Certification

Certificate of Completion will be provided after completing the course

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:

How many hours?

How many people?

Total Cost

Price per person

Preferred Dates and Times

Any other information

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

Share This Course

Related Courses

Save Money with Packages

SAVE up to 20% by booking this course with other related courses as shown below:

SQL Beginner to Advanced

£672 (save £168)

This package combines

SQL for Beginners - 12 hours
SQL Intermediate to Advanced - 12 hours

Find out more & book now

Newsletter Sign-up

First Name

Last Name

Email address

Have a Question?

Please read our frequently asked questions or contact us.

Backup a database using SQL Server Management Studio

Downloading and Restoring the AdventureWorks2017 sample database

Guide about Creating Database Backup and Recovery Process

Installing Microsoft SQL Server on Mac OS using Docker

Microsoft SQL Server 2017 Step by Step Installation Guide

Restore a database using SQL Server Management Studio

SQL for Data Analysis: Unlocking Insights from Your Data

SQL Server Management Studio (SSMS) Step by Step Installation Guide

Top Reasons to Use Business Intelligence Tools

Why SQL is a Must-Have Skill for Every Modern Employee

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

☎️ +44 (0)208 432 6218

WhatsApp: +44 0749 461 6045