Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
     
Transact SQL Training Videos             * SQL Server DBA Tutorials
* Integration Services Training
* More Videobooks...
Email
Password
Register
LearnTransactSQL.com Subscriber Videos
Transact SQL Videos By Category Home  Subscriber Videos  
Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more - Video Category (all video categories)
Video Image People pay you a lot of money if you can write analytical queries - let's just be frank. The more you can "do" with data, the more valuable you are to an organization. This category of videos focuses on helping you get the full spectrum of analytical queries and aggregates including a main focus: Understanding the core concepts behind the aggregations so that you can go on to bigger and better things!

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
A Comparison of DISTINCT and GROUP BY: When to Use Each    Free Transact SQL Training Video 200 Download 9 mins.
The Basics of the HAVING Clause   300 Download 8 mins.
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Claus...   300 Download 11 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.
Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC
Security Tip: Run the Microsoft Baseline Security Analyzer (MBSA) on your SQL Server to ensure that you are well protected
Video search
Company News
Visual Studio 2005 C# Training
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
8/7/2008 6:35:38 PM