Free Transact SQL Video Tutorials - LearnTransactSQL.com

Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training

Home
- Free Videos
- Subscriber-Only Videos
- Buy Now (Subscriptions)
- Meet the Author
- Testimonials

Find Videos
- Search for videos
- Tag Cloud
- Arranged by Skill
- Staff Picks

Pricing/Subscriptions
- Subscribe!
- More Sites Like This

Support
- FAQs
- My Account
- Contact Us

About Us
- About Us
- LearnItFirst.com

Quick Links
- Refer a Friend
- Site Map

"Scott Whigham is a first-rate trainer and SQL Server guru." - Brad McGehee, Sql-Server-Performance.com

Pt. 2 - How to Work With Arrays and Split() Functions in SQL Serv...

Creating Database Diagrams in SQL Server Management Studio

Design Pattern for Finding Duplicate Data - A Simple Way to Spot ...

Choosing Between Cursors, Table Variables and Temp Tables (SQL Se...

Pt. 3b - Performance and Our CamelCase Function

Watch our FREE Transact SQL Video Tutorials

These free videos are just randomly chosen videos from our huge online library of Transact SQL video tutorials and these are exactly the same videos you will get if you become a subscriber.

Want to get an email whenever we add new free videos?

Subscribe to our newsletter by creating a new account

FREE VIDEO #1: A Comparison of DISTINCT and GROUP BY: When to Use Each
Author: Scott Whigham Skill level: 200 (Beginner - Intermediate) Length (MM:SS): 09:15 File size: 8.5MB Link to Subscriber-Only Version: here
	Chapter: Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more
	In this video tutorial Scott Whigham will breakdown the differences and similarities between using the DISTINCT and GROUP BY clauses. Highlights from this video: Where do these clauses respectively operate? What kind of relationships are drawn between base table and your result set? Purpose of GROUP BY and DISTINCT and how SQL Server treats them Comparing/Contrasting the two clauses and much more! You can watch this video two ways: (watch a Flash-based version) (note: requires the TSCC codec)

FREE VIDEO #2: Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008
Author: Scott Whigham Skill level: 300 (Intermediate) Length (MM:SS): 14:15 File size: 12.5MB Link to Subscriber-Only Version: here
	Chapter: The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL
	One of the challenging things anyone coming into SQL Server faces is trying to figure out which version of the word 'schema' someone is using at any given time. Example: 'You need to put the Person schema in the People schema inside your database schema' is a perfectly legitimate instruction but the word schema means three different things in that sentence! So which 'version' of the word schema does this video talk about? The second version. :) Okay, okay - this video talks about the container-type of schema (#1 was an Xml schema Collection and #3 was a Database Schema). Highlights from this video: What are schemas? What are containers? How are schemas used? Should I use schemas? What about schemas like db_owner, db_ddladmin, et al - is it safe to remove those? Where should I put my schemas? I'm upgrading from SQL Server 2000 to 2005/2008 - what is different between users, object owners, and schemas? and much more You can watch this video two ways: (watch a Flash-based version) (note: requires the TSCC codec)

View a list of videos available to Subscribers

>> Subscribe here


Home \| About Us \| Advertising \| Become an Author \| Contact Us \| Privacy \| System Req's \| Terms \| Testimonials \| Work for Us! \| \| Site Map
© 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:31:04 PM

You can watch this video two ways:

You can watch this video two ways: