SQL Server Database Querying Course

This course is aimed at those who need to extract information from a relational database system. Although it provides an overview of relational database design principals it does not cover the teaching of formal database design processes and database/table creation. The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014

Relational Database Overview

The SELECT statement

Comparison Conditions

Multiple Conditions

The Top Option



Aggregate Functions

Mathematical Functions

Conversion Functions

String Functions

Date Functions

Substitution Functions

Cross Joins

Inner Joins

Outer Joins

Table Aliases

Self Join

Advanced Joins

Working with Aggregate Data

Sub Queries


London Greenwich

Monday 04 to Wednesday 06 June 2018


Book Now

London Greenwich

Monday 02 to Wednesday 04 July 2018


Book Now


Programming courses

Sql courses

Database courses