Week 9 Topic – Data Analysis – Aggregation

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

Go to Assignments