Call us: 02045797300
Email us: info@trainingdeals.co.uk
For all your training needs.
Lines are open 24 Hours, Monday to Sunday

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

Sorry, we do not have any courses matching your criteria

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