
MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led
Fri 20 Nov · 11:00
London Trafalgar Square
Venue events →
Ask AI: is it for me?
Similar events
View allNot quite it? Try these
See all
Tue, 15 Dec 202615-16 Dec 2026 Barco Encore3 Certified Operator
£834
Thu, 17 Dec 202617-18 Dec 2026 Barco Encore3 Certified Operator
£834
Sun, 22 Nov 2026Sunday Night Life Drawing: Draw a Live Model in MK
£13
Sun, 29 Nov 2026SIP & PAINT- Party Milton Keynes
From £22
Wed, 2 Dec 2026Wreath Making
£55
About This Event
An advanced MS SQL course will be held online on 20 November 2026, focusing on advanced SQL topics. This instructor-led workshop aims to provide participants with valuable skills in SQL. The course fee ranges from £647.39 to £1294.19.
This SQL for advanced SQL topics is online instrcutor-led, Have a fun and very useful day with us.
MS SQL Server Advanced Course
Course summary
SQL Sub-queries
·Sub-queries in the WHERE, SELECT, From or Having clauses ·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries ·Correlated sub-queries ·Sub-queries with the EXISTS predicate
Derived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics ·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures
Variables ·Declaring variables ·SET versus SELECT
Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN
Testing Conditions ·The IF/ELSE statement ·CASE ·CHOOSE
Looping ·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·Dropping objects
User defined Functions Table Valued Functions ·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions
Scalar Functions ·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages
Cursors ·Syntax of fetching rows ·When to use (and when not to)
Triggers Create or replace triggers
Creating Tables in SQL ·Create, alter and drop Tables ·Inserting values, single rows and multiple rows using queries
Constraints: Not Null Unique Default Check Primary Key Foreign Key Identity / Auto-increments Sequencing Indexes
SQL Temporary Tables and Table Variables ·Create and use SQL temporary tables ·Create and use SQL table variables ·SQL Tables vs. Table Variables
Error-Handling ·SQL TRY/CATCH ·SQL System error functions ·Customizing SQL error messages ·@@ error function
Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.)
Description supplied by the event organiser.
Similar Events in Milton Keynes
View all →
Tue, 15 Dec 2026
15-16 Dec 2026 Barco Encore3 Certified Operator
Lang UK
£834

Thu, 17 Dec 2026
17-18 Dec 2026 Barco Encore3 Certified Operator
Lang UK
£834

Sun, 22 Nov 2026
Sunday Night Life Drawing: Draw a Live Model in MK
Woolstone Community Centre
£13

Sun, 29 Nov 2026
SIP & PAINT- Party Milton Keynes
Blossom Room
From £22

Wed, 2 Dec 2026
Wreath Making
The Bedford Arms
£55

Fri, 4 Dec 2026
Wreath Making Workshop
Barton Rovers Football Club
£23
Frequently asked questions
MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led takes place on Friday, 20 November 2026 at 11:00.
MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led is held at London Trafalgar Square in Milton Keynes (Golden Cross House, London, WC2N 4JF).
Tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led range from £647.39 to £1294.19. Live prices and availability are shown on Eventbrite.
Tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led can be booked via Eventbrite using the "Check Tickets & Live Prices" button on this page, which opens the official booking site in a new tab.
Editorial summaryAbout this event
An advanced MS SQL course will be held online on 20 November 2026, focusing on advanced SQL topics. This instructor-led workshop aims to provide participants with valuable skills in SQL. The course fee ranges from £647.39 to £1294.19.
This summary was automatically generated from event data sourced from official ticketing providers.
This SQL for advanced SQL topics is online instrcutor-led, Have a fun and very useful day with us.
MS SQL Server Advanced Course
Course summary
SQL Sub-queries
·Sub-queries in the WHERE, SELECT, From or Having clauses ·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries ·Correlated sub-queries ·Sub-queries with the EXISTS predicate
Derived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics ·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures
Variables ·Declaring variables ·SET versus SELECT
Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN
Testing Conditions ·The IF/ELSE statement ·CASE ·CHOOSE
Looping ·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·Dropping objects
User defined Functions Table Valued Functions ·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions
Scalar Functions ·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages
Cursors ·Syntax of fetching rows ·When to use (and when not to)
Triggers Create or replace triggers
Creating Tables in SQL ·Create, alter and drop Tables ·Inserting values, single rows and multiple rows using queries
Constraints: Not Null Unique Default Check Primary Key Foreign Key Identity / Auto-increments Sequencing Indexes
SQL Temporary Tables and Table Variables ·Create and use SQL temporary tables ·Create and use SQL table variables ·SQL Tables vs. Table Variables
Error-Handling ·SQL TRY/CATCH ·SQL System error functions ·Customizing SQL error messages ·@@ error function
Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.)
Description supplied by the event organiser.
WhereLondon Trafalgar Square
Before you goFrequently asked questions
When is MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led?
MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led takes place on Friday, 20 November 2026 at 11:00.
Where is MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led taking place?
MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led is held at London Trafalgar Square in Milton Keynes (Golden Cross House, London, WC2N 4JF).
How much are tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led?
Tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led range from £647.39 to £1294.19. Live prices and availability are shown on Eventbrite.
How do I get tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led?
Tickets for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led can be booked via Eventbrite using the "Check Tickets & Live Prices" button on this page, which opens the official booking site in a new tab.
Availability
Sold out
Eventbrite shows no tickets left · last seen £647.39 - £1294.19
Date
Time
Venue
Golden Cross House, London, WC2N 4JF
Tickets are sold out
Checked today. Returns and extra releases do happen — the seller's page is the place they show up.
Secure checkout on Eventbrite — opens in a new tab
Ask AI: is it for me?
Keep looking
More in Milton Keynes
EventsList lists 212,000+ events across the UK. Tickets are sold by the venue or its authorised sellers, never by us.
Not this one?Similar events in Milton Keynes
View allMore things to do in Milton Keynes
- Stony Stratford Lantern Project 2026Sunday, 25 October 2026
- 2026 Holly Wreath WorkshopsFriday, 27 November 2026
- Mosaic Workshops in Milton KeynesSaturday, 5 December 2026
- Wreath Making in Stony StratfordSunday, 29 November 2026
- 🎄 Bottomless Christmas 🎄Friday, 4 December 2026
- Wreath Making Fundraiser for York HouseSaturday, 21 November 2026
- Friends of the Caribbean Sip and PaintSunday, 22 November 2026
- Wex Sessions: Lumix In-store Filmmaker & Creator DayThursday, 26 November 2026
- Summer Sit and Sew - One Day WorkshopSunday, 6 June 2027
- GirlytopiaSaturday, 21 November 2026
- Xmas Wreath Making WorkshopSaturday, 21 November 2026
- Bedford Park Outdoor Boot Camp | Group Fitness with Michael James FitnessSunday, 22 November 2026
- First Aid at Work (FAW) Course - Milton KeynesWednesday, 18 November 2026
- Sunday Night Life Drawing in Milton Keynes · £13 on the doorSunday, 22 November 2026






