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

Other recommended courses

Show more courses +

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

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

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