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
Scroll right for more details
| Delivery Method | Dates & Times | Hours | Price | Enrolment |
Online Training using Zoom
|
10 May 2026 - 24 May 2026
3 Sundays
10:00 AM - 02:00 PM
BT
| 12-hour over 3-day |
| Enrol Now |
Online Training using Zoom
|
19 May 2026 - 28 May 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM
BT
| 12-hour over 4-day |
| Enrol Now |
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 |
| 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 |
| 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 |
| 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 |
| 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:
Frequently Asked Questions
Do I need prior SQL knowledge for this course?
Yes, participants should already understand basic SQL concepts such as SELECT statements, filtering data, joins, grouping, and basic database querying before attending this course.
We highly recommend completing a beginner-level SQL course or having equivalent knowledge.
What will I learn in this course?
You will learn intermediate to advanced SQL concepts including Common Table Expressions (CTEs), window functions, dynamic SQL, stored procedures, user-defined functions (UDFs), variables, control flow, and query optimisation techniques.
Will I learn advanced SQL querying techniques?
Yes, the course covers advanced querying techniques including aggregate queries across multiple tables, logical functions, windowing functions, and advanced data manipulation methods.
What are Common Table Expressions (CTEs)?
Common Table Expressions (CTEs) are temporary result sets used to simplify complex SQL queries and improve readability. The course covers creating and using single and multiple CTEs in queries.
Will I learn stored procedures and user-defined functions (UDFs)?
Yes, participants will learn how to create and use stored procedures and scalar-valued user-defined functions (UDFs) to improve code reusability and automate database tasks.
Does this course cover dynamic SQL?
Yes, the course introduces dynamic SQL techniques and demonstrates how SQL queries can be generated and executed dynamically.
Will I learn window functions and windowing techniques?
Yes, the course covers SQL windowing concepts and advanced analytical querying techniques commonly used in reporting and data analysis.
Will I learn SQL variables and control flow?
Yes, participants will learn how to use variables, IF…ELSE statements, logical functions, and control flow techniques within SQL scripts.
Does the course cover query optimisation and performance?
Yes, the course introduces techniques for improving query performance, transaction handling, and writing more efficient SQL code.
Will there be practical exercises during the course?
Yes, the course is highly practical and includes hands-on exercises and real-world SQL scenarios to help participants apply advanced concepts confidently.
What software or database systems will I use?
Participants may work with database systems such as Microsoft SQL Server, MySQL, or PostgreSQL depending on the course setup.
You may also use our online SQL practice platform:
sql.lait.co.
Can this course help me in my career?
Yes, advanced SQL skills are highly valued in roles such as Data Analyst, Database Developer, Business Intelligence Analyst, Data Engineer, and Software Developer.
How is the course delivered?
The course is instructor-led and can be attended live online, in person at our London training centre, or delivered on-site at your organisation for corporate training.
Will I receive a certificate after completing the course?
Yes, participants will receive a certificate of completion after successfully finishing the course.
What can I learn after completing this course?
After completing this course, you can progress to advanced data analytics, database administration, data engineering, business intelligence, or data science and AI-related courses.