Advanced SQL Server Database Querying

This course is aimed at SQL Server database developers, administrators and analysts who need to take the basics of SQL Server SQL Data Manipulation Language (DML) statements to the next level. The course covers 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 meet the information extraction requirements of real world businesses. 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. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.

Review of SELECT Statement Basics

Nesting Functions

CASE Statement

Multiple Table Selects

Dates

London Greenwich

Thursday 03 to Friday 04 August 2017

£745

Book Now

London Greenwich

Thursday 28 to Friday 29 September 2017

£745

Book Now

London Greenwich

Monday 09 to Tuesday 10 October 2017

£745

Book Now

London Greenwich

Monday 27 to Tuesday 28 November 2017

£745

Book Now


Collections

Programming courses

Sql courses

Database courses