As data professionals, we often field questions from business analysts around category or yearly totals for a particular product line.  But what if you’re asked to create more complex reports around things like market share?  

In this webinar, Rick Morelan shows you how to combine aggregate functions with individual records, so you can satisfy more complex reporting requirements without ever using GROUP BY or nesting your queries.

Register for the webinar to learn how to:
  • Use aggregation queries that combine totals in the same recordset as your row data
  • Write aggregation queries that don’t use the GROUP BY keywords
  • Aggregate table data by groups or partitions using all types of aggregate keywords

About Rick Morelan

Rick Morelan has been working with Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008).

Rick has provided training for Northwest University, Volt Technical Education, and Microsoft. He currently works as a Software Design Engineer in Test for the Windows Mobile group, Bellevue College, and Moretechnology.com. As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.

Watch the webinar on-demand
Complex Reports Made Easy with SQL Aggregation Queries