Regular Price: £420 (Approximately $566.99 USD) Batch Price: From £360 (approx. $486 USD) 📅 View Dates & Prices Group Booking Discount: From £240 per person(approx. $324 USD) 🧮 Calculate & Book 1-to-1 Training: £420(approx. $567 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 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 Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details Delivery MethodDates & TimesHoursPriceEnrolment Online Training using Zoom 20 Jan 2026 - 29 Jan 2026 2 Tuesdays & 2 Thursdays 02:00 PM - 05:00 PM BT 12-hour over 4-day £360 £420 (approx. $486 USD) Enrol Now Online Training using Zoom 01 Feb 2026 - 15 Feb 2026 3 Sundays 10:00 AM - 02:00 PM BT 12-hour over 3-day £360 £420 (approx. $486 USD) Enrol Now 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. $486 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. $486 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. $486 USD) Enrol Now Online Training using Zoom 07 Apr 2026 - 16 Apr 2026 2 Tuesdays & 2 Thursdays 02:00 PM - 05:00 PM BT 12-hour over 4-day £360 £420 (approx. $486 USD) Enrol Now Note: Online classes are usually delivered through Zoom video conferencing. 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
12 June 2014 Backup a database using SQL Server Management Studio This simple step-by-step guide, clearly illustrated with screenshots, will take you through the process of backing up an SQL database.
29 March 2020 Downloading and Restoring the AdventureWorks2017 sample database In this tutorial you will learn how to download and restore the AdventureWorks sample database in Microsoft SQL Server 2017.
20 August 2020 Guide about Creating Database Backup and Recovery Process Database backup and recovery are essential to the success of a company and ensure the business’s continuity.
19 April 2020 Installing Microsoft SQL Server on Mac OS using Docker You can install SQL Server on to a Mac using Docker. You will get not full feature of SQL Server Management studio though.
27 March 2020 Microsoft SQL Server 2017 Step by Step Installation Guide In this article, you will learn how to install the Microsoft SQL Server 2017 Developer Edition.
12 June 2014 Restore a database using SQL Server Management Studio This simple step-by-step guide, clearly illustrated with screenshots, will take you through the process of backing up an SQL database.
14 August 2024 SQL for Data Analysis: Unlocking Insights from Your Data In this blog post, we'll explore how SQL can be used for data analysis, focusing on key concepts, techniques and examples that will help you harness the power of SQL to extract meaningful insights from your data.
28 March 2020 SQL Server Management Studio (SSMS) Step by Step Installation Guide In this tutorial, you will learn how to install SQL Server Management Studio step by step.
10 August 2020 Top Reasons to Use Business Intelligence Tools In this article we will explore the benefits that come with the use of business intelligence tools.
17 September 2025 Why SQL is a Must-Have Skill for Every Modern Employee SQL is a critical business skill that empowers employees to access, analyse, and act on data directly, leading to faster, smarter decisions and a more agile, data-driven company culture. This article explains how SQL knowledge across an organisation, from marketing and sales to finance and operations, unlocks faster, deeper insights directly from source data.