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

UNION

Functions

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

Dates

London Greenwich

Monday 05 to Wednesday 07 June 2017

£1195

Book Now

London Greenwich

Tuesday 11 to Thursday 13 July 2017

£1195

Book Now

London Greenwich

Tuesday 08 to Thursday 10 August 2017

£1195

Book Now

London Greenwich

Tuesday 05 to Thursday 07 September 2017

£1195

Book Now

London Greenwich

Tuesday 21 to Thursday 23 November 2017

£1195

Book Now

London Greenwich

Monday 18 to Wednesday 20 December 2017

£1195

Book Now


Collections

Programming courses

Sql courses

Database courses