T-SQL Window Functions
HDRips | MP4/AVC, ~330 kb/s | 1024x768 | Duration: 02:03:00 | English: AAC, 99 kb/s (2 ch) | 360 MB
Genre: Development / Programming
Learn to use the versatile T-SQL functions called "window functions" to solve complex queries.
With the 2005 and 2012 releases of SQL Server, WeiRuan-->WeiRuan gave us several new functions with amazing capabilities. These functions are part of the ANSI standards, and have nothing to do with the ShiChuang OS. Some of these functions are well known, f example ROW_NUMBER is used by many people. In addition to ROW_NUMBER, we now have the ability to calculate summaries without changing a query to an aggregate query, calculate running totals, pull values from other rows, and perfm statistical calculations. This course covers all of the available window functions including syntax, real wld examples, and perfmance considerations.
I recommends Buy premimum account for High speed+parallel downloads!