• Register
  • FAQs
  • Contact
  • Time Zone
  • Chat on WhatsApp

SQL Intermediate to Advanced

Batch Price From £210 (approx. $285 USD) View Dates & Prices
Custom Price From £240 (approx. $326 USD) Price Calculator & Booking Short course on Microsoft SQL Server Database Designing
Total Duration: 12-Hour
Course level: Advanced
Delivery Method: Instructor-led Physical Classes or Virtual Classes
Certification: Certificate of Completion will be provided after completing the course

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 Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
Training MethodDates and TimesPrice 
Online Training using Zoom 30 Jun 2025 - 04 Jul 2025
Mon - Fri
01:00 PM - 03:30 PM ET 		£210 £420
(approx. $285 USD) 		Enrol Now
Online Training using Zoom 08 Jul 2025 - 24 Jul 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 14 Jul 2025 - 16 Jul 2025
Mon, Tue & Wed
05:00 AM - 09:00 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Classroom Training 14 Jul 2025 - 16 Jul 2025
Mon, Tue & Wed
05:00 AM - 09:00 AM ET 		£420
(approx. $570 USD) 		Enrol Now
Online Training using Zoom 19 Jul 2025 - 27 Jul 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 21 Jul 2025 - 01 Aug 2025
Mon, Wed & Fri (2 wks)
01:00 PM - 03:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 12 Aug 2025 - 28 Aug 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 18 Aug 2025 - 20 Aug 2025
Mon, Tue & Wed
05:00 AM - 09:00 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Classroom Training 18 Aug 2025 - 20 Aug 2025
Mon, Tue & Wed
05:00 AM - 09:00 AM ET 		£420
(approx. $570 USD) 		Enrol Now
Online Training using Zoom 23 Aug 2025 - 31 Aug 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 27 Sep 2025 - 05 Oct 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 30 Sep 2025 - 16 Oct 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 01 Nov 2025 - 09 Nov 2025
2 Saturdays & 2 Sundays
11:00 AM - 02:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 18 Nov 2025 - 04 Dec 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET 		£360 £420
(approx. $488 USD) 		Enrol Now
Online Training using Zoom 06 Dec 2025 - 14 Dec 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET 		£360 £420
(approx. $488 USD) 		Enrol Now

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
×

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:


Share This Course

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
Find out more & book now

Newsletter Sign-up

Have a Question?

Please read our frequently asked questions or contact us.

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
Chat with London Academy of IT on WhatsApp

Share this page now!

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