SQL Server 2005/2008 Queries Training Video: Aggregates and Windo w Functions - Breakin' the Rulez

Aggregates and Window Functions - Breakin' the Rulez - view details
This video will break all the rules that were covered in the previous videos in this chapter. Scott will cover using aggregates and window functions in this video.
 
Highlights from this video:Mixing 1:1 and many:1 queries in the same query
Window Functions
Mixing row and group level values
OVER clause
and much more Source: http://www.learnitfirst.com/Course/160/Video/2380/Aggregates-and-Window-Functions.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 11:45 (30.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server, queries, aggregates, window function, over clause,

This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.