Call us: 02036038880
Email us: info@trainingdeals.co.uk
For all your training needs.
Lines are open 24 Hours, 1

Advanced SQL

  • Our Advanced SQL training courses help you master this programming language
  • SQL developers are highly respected for their skills and knowledge and can command high salaries
  • Enrol today for expert SQL tuition from trusted SQL trainers in
  • Introduction level also available

Browse our list of upcoming courses below

Book Online or Call 0800 0353 257 to speak to a training advisor

Course Date Venue Duration Price Book Online
Advanced SQLHome Virtual deal - 20% off 23/09/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 23/09/2021 Newcastle 2 days £4995 Book OnlineEnquire
Advanced SQL 30/09/2021 Cardiff 2 days £4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 07/10/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 07/10/2021 Leeds 2 days £4995 Book OnlineEnquire
Advanced SQL 14/10/2021 Aberdeen 2 days £4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 21/10/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 21/10/2021 Brighton 2 days £4995 Book OnlineEnquire
Advanced SQL 28/10/2021 Dublin 2 days €4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 04/11/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 04/11/2021 London 2 days £3995 Book OnlineEnquire
Advanced SQL 11/11/2021 Bristol 2 days £4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 18/11/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 18/11/2021 Southampton 2 days £4995 Book OnlineEnquire
Advanced SQL 25/11/2021 Glasgow 2 days £4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 02/12/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 02/12/2021 Manchester 2 days £4495 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 09/12/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Advanced SQL 09/12/2021 Norwich 2 days £4995 Book OnlineEnquire
Advanced SQLHome Virtual deal - 20% off 16/12/2021 Home Virtual 2 days £1495£795 Book OnlineEnquire
Previous Page Page 1 of 6
Next Page

FAQs

  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am

  • What are the pre-requisites?

    Some previous programming or database experience would be useful

Overview

Course Content

Stored Procedure Basics

Pros and cons of stored procedures

Creating stored procedures

Three ways to execute

System stored procedures

Variables

Declaring variables

SET versus SELECT

Tricks with variables and rowsets

So-called global variables

Parameters and Return Values

Passing parameters

Default values and WHERE clauses

Output parameters

Using RETURN

Avoiding Scalar Functions

What are scalar functions?

Some examples

Disadvantages of scalar functions

Three alternatives

Testing Conditions

IF / ELSE statement

Using CASE where possible

Looping

Syntax of 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

Creating Tables

Creating tables in SQL

Inserting data

Inserting single rows

Inserting multiple rows

Temporary Tables and Table Variables

Using temporary tables

Creating table variables

Pros and cons of each approach

Table Valued Functions

In-line table-valued functions

Mult-statement table-valued functions

Limitations of user-defined functions

Derived Tables and CTEs

Using dervied tables

Common Table Expressions (CTEs)

Recursive CTEs

Subqueries

The concept of a subquery

Using ALL, ANY and IN

Correlated subqueries

Using EXISTS

Cursors

Syntax of fetching rows

When to use (and when not to)

Error-Handling

Using TRY / CATCH

System error functions

Custom error messages

The obsolete @@error function

Debugging

Version differences

The Visual Studio debugger

The SQL Server debugger

Debugging (breakpoints, etc.)

What's Included

  • Courseware Book
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments

Testimonials

There hasn't been any testimonials submitted to this course

Video

We do not currently have a video for this course

Special Bundle Offers

Choose a learning package and
start learning today!

View deals

Onsite offers

Send us your onsite requirements and we will provide a tailor made course for you!

Contact

T.  02036038880
E: info@trainingdeals.co.uk

1 Bell Street, Maidenhead, Berkshire, SL6 1BU