SQL Advanced Queries

Book this course

Course description

If you need to extract data from a relational database management system (RDBMS) such as Oracle or Microsoft SQL Server, the Microsoft SQL developer tool – which this advanced course focuses on – will enable you to do that.

Using ANSI standard code, where possible, that can be applied to virtually all databases, we show you some of the advanced techniques that will enable you to better utilise this tool, from working with conditional statements to creating subqueries.

Is it right for me?

If you use Microsoft SQL Server, and you want to learn some of the more powerful queries this tool is capable of, this advanced SQL training course will take your SQL knowledge to the next level.

What will I get out of it?

By the end of the course you will be able to:


  • Create and use stored procedures
  • Use conditional statements in queries
  • Declare and use variables
  • Declare and use parameters
  • Create subqueries
  • Create looping routines
  • Create error handling routines
  • Use the debugging tools

Excellent. The trainer was relaxed, assured and extremely knowledgable. Probably the best external training I've had. Would thoroughly recommend this training to others, it was superb!

Business Performance Manager, Scotia Gas Networks

What does it cover?

  • Basic SELECT queries
  • Using IN
  • Using INNER/OUTER/FULL OUTER joins
  • Using grouping/aggregate functions
  • How to create a stored procedure
  • Running stored procedures
  • Renaming and deleting procedures
  • Using IF
  • Using CASE
  • Using EXISTS
  • Variable types
  • Declaring variables
  • Using table variables
  • Declaring parameters
  • Passing values in queries
  • Predicate subqueries
  • Table subqueries
  • Using UNION
  • Using UNION ALL
  • Complex subqueries
  • Using Try and CATCH
  • System error functions
  • Custom error messages
  • Using the DEBUG tool
  • Using breakpoints

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

Visio – Professional Flowcharting and So Much More

Visio is an extremely powerful and versatile design tool. It can be used for a variety of different functions in...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article