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  
SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language - Video Category (all video categories)
Video Image An expanded category of videos featuring the tips and tricks for each of the DML statements.

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000
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
Series (2 videos) - Using the OUTPUT Clause With the INSERT, UPDATE, and DELETE ...   300 (Click for Videos) 17 mins.
Series (4 videos) - An Overview of the INSERT Statement   100 (Click for Videos) 40 mins.
Series (4 videos) - An Overview of the UPDATE Statement   200 (Click for Videos) 45 mins.
Series (5 videos) - An Overview of the DELETE Statement   300 (Click for Videos) 59 mins.
Series (7 videos) - A Lengthy Overview of the SELECT Statement   100 (Click for Videos) 76 mins.
Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)   100 Download 5 mins.
How to Add In a Row Number Column That Numbers the Rows of Your Result Set   200 Download 8 mins.
What Is Modulo? When Would I Use It?   300 Download 6 mins.
Over 4 hours of Transact SQL tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
User-defined data types are handy ways to create shortcuts to commonly used data type conventions. You could, for example, create the user-defined data type "Emails" to use as the data type for any column that stores email addresses
Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase
Performance Tip: The more hard drives you spread your database across the better performance you will experience. RAID 10 offers the ultimate in performance but, for small databases, is likely to be too costly. RAID 5 for your smaller database's data files and RAID 1 for their log files will help maximize your SQL Server's performance
Video search
Company News
Windows SharePoint 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.
7/26/2008 7:59:01 PM