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  
Subqueries, Nested Queries, and Derived Tables in Transact SQL - Video Category (all video categories)
Video Image Advanced SQL topics such as subqueries and derived tables deserve their own category and this is it. The videos in this category are not for the "faint of heart" - you should have a solid foundation in JOINs, UNIONs, Plan guides, Execution Plans and a solid understanding of SQL before tackling this section.

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
How to Decide Whether to Write a JOIN or Subquery   300 Download 9 mins.
Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them   300 Download 12 mins.
Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs   300 Download 14 mins.
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL...   300 Download 17 mins.
Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries ...   300 Download 23 mins.
Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets   300 Download 7 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system
Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+DELETE deletes all text in the query pane
Badly fragmented disks can decrease input/output (IO) throughput by more than 50%
Video search
Company News
Visual Basic 2005/2008 Tutorials
     
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.
7/26/2008 7:59:55 PM