Topic - Data Analysis - Aggregation

We have not really looked at aggregation and aggregation function in detail yet. This week we will look at this and we will create some aggregate reports from these functions.

Reading

Aggregate Functions Reference - http://msdn.microsoft.com/en-us/library/ms173454%28v=sql.100%29.aspx 

Ranking Function Reference - http://msdn.microsoft.com/en-us/library/ms189798%28v=sql.100%29.aspx 

Lectures

Lecture - Database and Aggregations

Lecture - Advanced Query - WITH Clause

Lecture - Complex queries with aggregation

Assignments

COP4709 Spring 2013 Assignments - Week 9 assignment.