SQL Intermediate to Advanced

Batch Price From £360 (approx. $474 USD) View Dates & Prices
Custom Price From £240 (approx. $316 USD) Price Calculator & Booking Short course on Microsoft SQL Server Database Designing

Short course on Microsoft SQL Server Database Designing

Total Duration: 12 Hours
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:

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	12 Nov 2024 - 28 Nov 2024 3 Tuesdays & 3 Thursdays 01:00 PM - 03:00 PM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Closed
Online Training using Zoom	20 Nov 2024 - 06 Dec 2024 3 Wednesdays & 3 Fridays 10:00 AM - 12:00 PM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Closed
Online Training using Zoom	02 Dec 2024 - 20 Dec 2024 3 Mondays & 3 Fridays 01:00 PM - 03:00 PM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Classroom Training	08 Jan 2025 - 10 Jan 2025 Wed, Thu & Fri 05:00 AM - 09:00 AM ET	12 hours over 3 days	£420 (approx. $553 USD)	Enrol Now
Online Training using Zoom	25 Jan 2025 - 02 Feb 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	28 Jan 2025 - 13 Feb 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Classroom Training	05 Feb 2025 - 07 Feb 2025 Wed, Thu & Fri 05:00 AM - 09:00 AM ET	12 hours over 3 days	£420 (approx. $553 USD)	Enrol Now
Online Training using Zoom	01 Mar 2025 - 09 Mar 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Classroom Training	12 Mar 2025 - 14 Mar 2025 Wed, Thu & Fri 06:00 AM - 10:00 AM ET	12 hours over 3 days	£420 (approx. $553 USD)	Enrol Now
Online Training using Zoom	18 Mar 2025 - 03 Apr 2025 3 Tuesdays & 3 Thursdays 10:30 AM - 12:30 PM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	05 Apr 2025 - 13 Apr 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	06 May 2025 - 22 May 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	10 May 2025 - 18 May 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	14 Jun 2025 - 22 Jun 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	24 Jun 2025 - 10 Jul 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	19 Jul 2025 - 27 Jul 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	12 Aug 2025 - 28 Aug 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	23 Aug 2025 - 31 Aug 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	27 Sep 2025 - 05 Oct 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	30 Sep 2025 - 16 Oct 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	01 Nov 2025 - 09 Nov 2025 2 Saturdays & 2 Sundays 11:00 AM - 02:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	18 Nov 2025 - 04 Dec 2025 3 Tuesdays & 3 Thursdays 09:30 AM - 11:30 AM ET	12 hours over 6 days	£360 £420 (approx. $474 USD)	Enrol Now
Online Training using Zoom	06 Dec 2025 - 14 Dec 2025 2 Saturdays & 2 Sundays 10:00 AM - 01:00 PM ET	12 hours over 4 days	£360 £420 (approx. $474 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

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