Business Intelligence training -  Advanced SQL

SQL Training

Advanced SQL Training Course

£750 + VAT for most venues (£895 + VAT for London)

2 days

If you already know how to write SELECT statements in SQL, maybe it's time to find out how to program in SQL with our advanced course! Learn how to create stored procedures (including passing parameters to them), write your own user-defined functions, work with temporary tables and table variables and much more.

Course details

  • Locations for Advanced SQL coursesLocations:London, Manchester
  • Next Advanced SQL course locationNext course:Tue 24 September 2019
  • Advanced SQL course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Stored procedures

  • Training topicCreating stored procedures
  • Training topicExecuting stored procedures
  • Training topicSystem stored procedures

Variables

  • Training topicDeclaring variables
  • Training topicSET versus SELECT
  • Training topicTricks with variables
  • Training topicSo-called global variables

Parameters and return values

  • Training topicPassing parameters
  • Training topicDefault values / WHERE clauses
  • Training topicOutput parameters
  • Training topicUsing RETURN

Scalar functions

  • Training topicWhat they are
  • Training topicWriting user-defined functions
  • Training topicWorked examples
  • Training topicPros and cons of scalar functions

Testing conditions

  • Training topicIF / ELSE statement
  • Training topicUsing CASE where possible

Looping

  • Training topicSyntax of WHILE
  • Training topicBreaking out of a loop

Error-handling

  • Training topicUsing TRY / CATCH
  • Training topicSystem error functions
  • Training topicCustom error messages

Deleting using SQL

  • Training topicWays to drop tables
  • Training topicDELETE versus TRUNCATE

Updating data in SQL

  • Training topicThe UPDATE statement
  • Training topicUpdating using joins

Inserting data

  • Training topicMaking tables (SELECT INTO)
  • Training topicAppending data (INSERT INTO)
  • Training topicInserting individual rows

Creating tables

  • Training topicCreating tables in SQL
  • Training topicPrimary keys and indexes
  • Training topicAdding relationships

Transactions

  • Training topicBeginning a transaction
  • Training topicCommitting / rolling back

Temporary tables and table variables

  • Training topicScope (local versus global)
  • Training topicUsing temporary tables
  • Training topicCreating table variables
  • Training topicPros and cons of each approach

Table-valued functions

  • Training topicIn-line table-valued functions
  • Training topicMult-statement table-valued functions

Derived tables and CTEs

  • Training topicUsing derived tables
  • Training topicCommon Table Expressions (CTEs)
  • Training topicMultiple CTEs in a single query

Covered if time allows If time

Cursors

  • Training topicSyntax of fetching rows
  • Training topicWhy not to use cursors!

Debugging

  • Training topicDebugging queries and procedures
  • Training topicSetting breakpoints

Covered if time allows If time

Dynamic SQL

  • Training topicBuilding up dynamic SQL
  • Training topicExecuting dynamic SQL
  • Training topicDisadvantages of dynamic SQL

Covered if time allows If time

Pivots

  • Training topicAssembling data for pivoting
  • Training topicUsing PIVOT
  • Training topicDynamic column headers

Covered if time allows If time

Triggers

  • Training topicInsert, update and delete triggers
  • Training topicUsing the generated tables (eg INSERTED)
  • Training topicUsing INSTEAD OF

You should only attend this course if you have either attended our two-day introduction to SQL course or if you are comfortable creating queries using SQL.  The course shows how to write the dialect of SQL used by Microsoft (called T-SQL), using SQL Server Management Studio as a development environment.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Great course, brilliant to refresh what I knew but also learn some new helpful techniques. I chose the course due to excellent review from a colleague."

Joe Murphy (Emovis Operations Ltd)

"Excellent communication. Recommended by colleague."

Will Ridge (Leeds City Council)

"We had a great trainer, very patient and excellent at explaining the content of the course. The course venue and equipment provided was of a very high standard, especially the in-depth instruction manual and memory stick (meaning we could take the code we’d wrote home with us). We were also taken out for lunch each day which was a really nice touch. Would highly recommend. "

Claire Leonard (Barbican Insurance Group)

"Excellent content."

Suresh Patel (Gateway 6th Form College)

"Really enjoyed the course, great instructor who went above and beyond expectations."

Thomas Dickinson (Argos Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Advanced SQL training dates

Here are the Advanced SQL courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 24-25 September 2019 2 £895 Fully booked
Tue/Wed 05-06 November 2019 2 £895 Book places
Thu/Fri 21-22 November 2019 2 £750 Book places
Tue/Wed 10-11 December 2019 2 £895 Book places
Tue/Wed 07-08 January 2020 2 £750 Book places
Tue/Wed 21-22 January 2020 2 £895 Book places
Tue/Wed 11-12 February 2020 2 £750 Book places
Thu/Fri 05-06 March 2020 2 £895 Book places
Thu/Fri 12-13 March 2020 2 £750 Book places
Tue/Wed 31st Mar/1st April 2020 2 £895 Book places
Tue/Wed 21-22 April 2020 2 £750 Book places
Thu/Fri 21-22 May 2020 2 £895 Book places
Tue/Wed 02-03 June 2020 2 £750 Book places
Thu/Fri 02-03 July 2020 2 £895 Book places
Tue/Wed 14-15 July 2020 2 £750 Book places
Thu/Fri 06-07 August 2020 2 £895 Book places
Thu/Fri 03-04 September 2020 2 £750 Book places
Thu/Fri 10-11 September 2020 2 £895 Book places
Tue/Wed 13-14 October 2020 2 £750 Book places
Tue/Wed 20-21 October 2020 2 £895 Book places
Tue/Wed 24-25 November 2020 2 £750 Book places
Tue/Wed 08-09 December 2020 2 £895 Book places
Date(s) Venue
24/09
05/11
21/11
10/12
07/01
21/01
11/02
05/03
12/03
31/03
21/04
21/05
02/06
02/07
14/07
06/08
03/09
10/09
13/10
20/10
24/11
08/12

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SQL training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to SQL

Basic

2 day course

Reporting Services RECOMMENDED

Introduction

2 day course

Introduction to SSIS

Introduction

2 day course

Other SQL training resources

SQL exercises

SQL exercises

Our advanced SQL exercises are based on simple, easy-to-understand databases, as you can see for yourself!

View SQL exercises

SQL videos

SQL videos

Although we firmly believe people learn best from people, we've also published a range of SQL tutorial videos online.

View Selecting data in SQL, SQL Server 2016, Advanced SQL (programming) or SQL Server 2017 videos

SQL skills assessment

SQL skills assessment

You can see how well you know SQL relative to others by taking one of our skills assessment tests online.

View Test your SQL skills skills assessment tests

SQL blogs

SQL blogs

Take a few minutes to see what blogs we've published on SQL on our website.

View SQL blogs

This page has 0 threads Add post