Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
     
SQL Server 2005 Training Videos             * SQL Programming Training Videos
* SQL Server DBA Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer2005.com 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 querying SQL Server 2005, 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 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
Series (2 videos) - Common Table Expressions (CTEs) in SQL Server 2005   300 (Click for Videos) 26 mins.
COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensi...   300 Download 17 mins.
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys   200 Download 14 mins.
Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your ...   200 Download 7 mins.
EXCEPT and INTERSECT - An Introduction to Syntax and Concepts   300 Download 12 mins.
How to Return Identity Value for a Just-Inserted Row   200 Download 16 mins.
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?   300 Download 7 mins.
Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use...   200 Download 11 mins.
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Com...   300 Download 21 mins.
Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions   200 Download 15 mins.
SET Commands for Performance Tuning and Query Execution Statistics   300 Download 21 mins.
TOP Operator: What's New and Why Life Is much Easier Today   200 Download 13 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.
Variables - Understanding the Difference Between Using SET and SELECT to Assign ...   200 Download 11 mins.
Variables and Scoping - Local Variables and Batch Terminators   200 Download 8 mins.
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Claus...   300 Download 11 mins.
Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download 12 mins.
Over 4 hours of SQL Server 2005 tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
The command-line command "net" can be used to for many administrative tasks such as creating shares, creating mapped drives, and much more. Go to command-line, and execute the command "net help" for more details
Helpful Tools for your SQL Server: Lumigent's Log Explorer is a great tool that allows you to read the transaction log and even undo transactions - very helpful in a crunch
Don't forget that calls to @@ERROR and @@ROWCOUNT change after each statement. Most programmers prefer to store these global variables in a local variable immediately for later processing
Company News
For about the cost of a single technical book you watch our video 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/3/2008 10:09:39 PM