Aggregations Made Easy in just 5 minutes
SQL Aggregations Made Easy with SQL Server Unlocked
Welcome to our first edition of our SQL Server unlocked Series. In this video our hosts Rick Morelan and Bally Kehal discuss how to make sql aggregations simple. Morelan has written over 15 book discussing database administration and SQL Server and prior to becoming the CTO and Tech expert at Social27, Kehal worked at Microsoft for a number of years.
Morelan begins with a country vs. state population analogy which leads into the topic of discussion, invoices. To refresh your memory, aggregate functions make an important impact in SQL as they perform a calculation on a set of values, and then return just one value. As an important sidenote, aggregate functions typically ignore null values and they are used often with the GROUP BY clause of the SELECT statement In the video, he shows you how to change the grain of a large collection of invoices per customer and the amount of transactions that customer has.
At the end of the day, aggregations are an essential part to SQL Server and sometimes something that may seem more difficult than necessary. Databases have different ways of implementing things and rules don’t always apply the same way. Watch the video to learn more.
If you enjoyed what you learned this week. Stay tuned for our next week’s blog “Easy Aggregation Tricks” and view our class Developer 2012 Volume 2 Video 4.1.
See more at: http://www.joes2pros.com/joes2pros/co...
Full Blog: http://joes2prosblog.social27.com/blo...