West Yorkshire Consortium of Colleges
Back

Advanced SQL: Calderdale College

Advanced SQL: Calderdale College - 1691

The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive SQL Server library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs.

Recent News

What West Yorkshire Colleges have been up to recently.

Read the News

6 January 2020

Have your say on skills and training in your business

As part of The Skills Service's ongoing research into skills and training opportunities and demand in the Leeds City Region, we would like to know…

Read More

10 December 2019

Reaching out to Construction Workers with Morgan Sindall

In November members of The Skills Service engagement team set up shop at Morgan Sindall’s exciting new construction project, Leeds Skelton Lake Services. Opening January…

Read More