Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
     
SQL Server 2000 Training Videos             * SQL DTS Training Videos
* SQL Programming Videos
* More Videobooks...
Email
Password
Register
LearnSqlServer2000.com Subscriber Videos
SQL Server 2000 Videos By Category Home  Subscriber Videos  
T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more - Video Category (all video categories)
Video Image This SQL Server training video category covers many internal storage and retrieval techniques including collations, how datatypes are stored and compared, and working with the internal datatypes

Versions/Editions Covered: SQL Server 2000 , SQL Server 2005 , 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
Series (4 videos) - Views in SQL Server - What They Are and When to Use Them   100 (Click for Videos) 49 mins.
Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)   100 Download 5 mins.
Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work   200 Download 8 mins.
Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works ...   300 Download 10 mins.
Creating and Altering Views in the Enterprise Manager (SQL Server 2000)   200 Download 9 mins.
Creating Linked Servers to Microsoft Access (SQL Server 2000)   400 Download 13 mins.
Customizing SQL Server with International Error Messages and How SQL Server 2000...   400 Download 8 mins.
Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best ...   300 Download 11 mins.
Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Ge...   300 Download 10 mins.
How to Return Identity Value for a Just-Inserted Row   200 Download 16 mins.
Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 200...   100 Download 11 mins.
Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL S...   400 Download 11 mins.
Rapid Database Development Using Database Diagrams (SQL Server 2000)   100 Download 9 mins.
Result sets, Recordsets, and the Client Server model   100 Download 9 mins.
Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Th...   200 Download 8 mins.
Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures...   100 Download 16 mins.
Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)   300 Download 17 mins.
Views: Introduction, When and Where to Use, and Using the Create View Wizard   100 Download 17 mins.
Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000)   200 Download 11 mins.
Over 4 hours of SQL Server 2000 tutorials in this category
< Return to list of all videos
Related Links:
Miscellaneous Bits & Pieces:
You can use the "SQL Server 2000 Management Pack Guide" is a helpful guide to managing your SQL Server in the enterprise. Check out Microsoft's Download page and search for "SQL Server 2000 Management Pack Guide" for more
SQL Server 2000 Service Pack 4 Features: Includes a new version of MSXML: MSXML 3.0 SP6
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
Video search
Company News
SQL Server Integration Services tutorials on video
     
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/3/2008 6:26:15 PM