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


Collections

Programming courses

Sql courses

Database courses