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

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.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine