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

8 October 2019

Wine School of Excellence: Certified training for the hospitality industry through The Skills Service

On a sunny Friday afternoon in York, we caught up with Gillian Tinney - Managing Director of the Wine School of Excellence (WSE). Newly contracted…

Read More

1 October 2019

Skills Cafe: Workshop announced for manufacturing businesses

The Skills Service is inviting SMEs working in manufacturing, advanced manufacturing and textiles to its next Skills Cafe on Friday 25 October. The event will…

Read More