Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
Runtime: 11:45 minutes
These videos are provided by JumpstartTV and End to End Training
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,811 reads
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
2009-03-17
4,840 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,401 reads
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,180 reads
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
2008-12-18
6,114 reads
