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  
The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL - Video Category (all video categories)
Video Image SQL Server's Transact SQL language is a complex and robust implementation of the ANSI/ISO SQL standard. If you're a newbie to SQL, start here. Even you "old salts" may find a few tips and tricks in here.

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) - An Overview of the AdventureWorks Database   100 (Click for Videos) 29 mins.
Series (3 videos) - An Introduction to Schemas in SQL Server 2005 and SQL Server...   300 (Click for Videos) 34 mins.
An Overview of the AdventureWorksDW Database   200 Download 24 mins.
An Overview of the Northwind Database   100 Download 14 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.
Database Diagrams - An Introduction   100 Download 9 mins.
Model Database - An Overview of How to Use It and When to Use It (SQL Server 200...   300 Download 10 mins.
Pages, Extents, and Blocksizes - What They Are and How They Work   300 Download 10 mins.
Resultsets, Recordsets, and the Client Server model (SQL Server 2000)   100 Download 9 mins.
Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Th...   200 Download 8 mins.
SQL Server Internals - The Steps SQL Server Goes Through to Run a Command   200 Download 8 mins.
SQL Standards - ISO, ANSI, and Transact-SQL's Implementation of the Various Stan...   300 Download 21 mins.
TempDb Database - An Overview of How it Works and When to Use It   300 Download 12 mins.
Over 3 hours of Transact SQL tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Tracert ("trace route") is a great command-line tool that you can use to trace the path that an Internet Protocol (IP) packet takes from the source to the destination. Tracert is a great tool for determining if a hub/router/switch is down or having problems
Helpful Keyboard Shortcuts: "Windows key" + "D" shows the desktop
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
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:43:25 PM