In This Course........

You will learn about basic aggregation as well as aggregation with windowing using the over clause. You will gain a good understanding of how the group by works in a standard query and how partitioning works in the windowing functions. Learn how null impacts the aggregate functions, and how to better handle null cases. Learn how the over windowing functions work and how to group by different columns in the same query. This course is part of the Querying SQL Server series.

When you complete all the course material, you will receive an email with a certificate showing you completed the course. You can print that out and put it on your office wall, or post it to your social media to show your accomplishment.