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  
JOINs and UNIONs - Working with Multiple Tables - Video Category (all video categories)
Video Image If you had to guess, what percentage of the queries you write/maintain are JOINs? If you are working in a Transactional system, the answer is probably 50%, 60%, 70%, or higher. Those of you working with Data Warehouses might have a smaller number such as 10-40%. The point is that you need to know the inner working of JOINs and UNIONs to be successful!

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
EXCEPT and INTERSECT - An Introduction to Syntax and Concepts   300 Download 12 mins.
JOIN Syntaxes - Should You Use ANSI-89 or ANSI-92 Join Syntax?   300 Download 21 mins.
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)   200 Download 24 mins.
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?   300 Download 7 mins.
UNION Queries - What They Are and How to Use Them (SQL Server 2000)   200 Download 8 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "CTRL" + "SHIFT" highlights a block of text when used with the arrow keys
After SQL Server 2000 you should not be using @@IDENTITY in your code. Microsoft replaced @@IDENTITY with SCOPE_IDENTITY() in SQL Server 2000
Security Tip: Protect your "sa" account by using a very strong password. Hackers can issue dictionary attacks against your SQL Server and attempt to guess your "sa" password with brute force. By providing a password that (a) cannot be found in any dictionary, and (b) contains letters, numbers, and special characters, you give yourself maximum password protection
Video search
Company News
SQL Server 2005 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:25:08 PM