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  
Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More - Video Category (all video categories)
Video Image The more you understand the fundamentals of SQL, the better programmer you will be. This category of videos focuses on learning the ins-and-outs of table design including in-depth discussions of datatypes, constraints and even talks about identity column usage and normalization/denormalization.

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 (10 videos) - Data Type Overview - Order of Precendence, Using CAST and C...   300 (Click for Videos) 107 mins.
Series (2 videos) - A Lecture on Using IDENTITY Columns in Table Design and Surr...   100 (Click for Videos) 30 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.
How to Return Identity Value for a Just-Inserted Row   200 Download 16 mins.
Naming Conventions for SQL Server Tables Constraints and Indexes (SQL Server 200...   200 Download 14 mins.
Should I use a Check Constraint or a Foreign Key - Best Practices and Design (SQ...   300 Download 12 mins.
Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000)   200 Download 9 mins.
What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them?   300 Download 10 mins.
Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download 12 mins.
Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000)   200 Download 11 mins.
Over 3 hours of Transact SQL tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
NTFS file and folder compression is not compatible with EFS - Encrypting File System. You can either compress or encrypt but not both
Helpful Keyboard Shortcuts: "Windows key" + "M" minimizes all windows
Book You Should Probably Own: Christopher Date's "An Introduction to Database Systems"
Video search
Company News
SSIS 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:33:20 PM