70-461 Session 5: Querying Microsoft SQL Server 2012

Building on Sessions 1-4, we’ll look at analytical functions, grouping sets, ranking functions and spatial aggregates.
This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012″.

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets.

We’ll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We’ll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We’ll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.