Regular Price: £420 Batch Price: From £360 📅 View Dates & Prices Group Booking Discount: From £240 per person 🧮 Calculate & Book 1-to-1 Training: £420 📋 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) Australian Central Time (Adelaide) 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 23 Jun 2026 - 02 Jul 2026 2 Tuesdays & 2 Thursdays 02:00 PM - 05:00 PM BT 12-hour over 4-day £360 £420 Enrol Now Online Training using Zoom 28 Jun 2026 - 12 Jul 2026 3 Sundays 10:00 AM - 02:00 PM BT 12-hour over 3-day £360 £420 Enrol Now Online Training using Zoom 30 Jun 2026 - 09 Jul 2026 2 Tuesdays & 2 Thursdays 05:00 AM - 08:00 AM BT 12-hour over 4-day £420 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 Enrol Now Online Training using Zoom 23 Aug 2026 - 06 Sep 2026 3 Sundays 10:00 AM - 02:00 PM BT 12-hour over 3-day £360 £420 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: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information
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.
08 January 2026 Optimising Slow Queries: A Guide to SQL Indexing This article explains the mechanics of SQL indexing and provides actionable strategies for reducing query latency in large datasets. It identifies how to balance read and write performance to ensure databases remain scalable and responsive.
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.
02 January 2026 SQL vs. Excel: When Should You Make the Switch? This guide explores the specific technical limitations of spreadsheets and identifies the key indicators that your organisation needs to transition to SQL. It provides a clear framework for understanding when manual data management should evolve into automated, scalable database solutions.
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.