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 16 to Wednesday 18 October 2017

£1195

Book Now

London Greenwich

Monday 13 to Wednesday 15 November 2017

£1195

Book Now

London Greenwich

Monday 11 to Wednesday 13 December 2017

£1195

Book Now


Collections

Programming courses

Sql courses

Database courses