Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
LearnSqlServer.com
·
LearnIntegrationServices.com
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
Part 4 - Using EXISTS to Control Execution In an IF Statement
Part 5 - WHILE Loops and Implementing Looping Structure in SQL
Extended Properties in SQL Server 2000 - What They Are and How to...
Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 200...
Scoping of SET Commands - Connections, Stored Procedures, Batches...
Welcome to LearnTransactSQL.com -
We Have
173
TSQL Training Videos Online!
LearnTransactSQL.com is a
video book
of SQL Programming tutorials for learning Transact SQL.
We have over 34 hours of Transact SQL video tutorials online
and our
subscribers
can download every single video
right now
.
GET STARTED
RIGHT NOW
BECOMING A TRANSACT SQL GURU
You Can Download Videos
IMMEDIATELY
Upon Becoming a Subscriber
Once you purchase a subscription to LearnTransactSQL.com you will be able to download videos
immediately
-
you can start learning Transact SQL today
without waiting for a book to arrive in the mail or a class to schedule/run!
Our
SQL Programming tutorials
are small enough to download in seconds and are designed to help you learn specific TSQL tasks quickly
Recorded by an
expert instructor
Video tutorials on all skill levels
Updated monthly - we add new videos every month
Subscriptions as low as
$14.95
(
subscription info
)
No need to miss work to attend training class -
videos can be viewed anywhere, anytime even on portable devices!
Chapters Available for Download Right Now:
1 - The Development Environment - Tools, Code Generation, and More
(13 Videos)
10 - Server-Side Storage: Temp Tables, Table Variables, Cursors and More
(2 Videos)
2 - The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL
(17 Videos)
11 - Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client
(13 Videos)
3 - Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
(21 Videos)
12 - Views in SQL Server
(2 Videos)
4 - SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language
(25 Videos)
13 - User-Defined Functions (UDFs) in SQL Server
(9 Videos)
5 - Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more
(3 Videos)
14 - Dynamic Data Source Queries - How to Write Distributed Data Queries Using Linked Servers and more
(3 Videos)
6 - JOINs and UNIONs - Working with Multiple Tables
(5 Videos)
15 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More
(8 Videos)
7 - Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
(16 Videos)
16 - Design Patterns for Transact-SQL
(10 Videos)
8 - Index Design, Plan Guides, Execution Plans and Query Plans for SQL Server: Performance Tuning Your Queries
(2 Videos)
17 - Misc Stuff That Just Doesn't Fit Anywhere Else
(18 Videos)
9 - Subqueries, Nested Queries, and Derived Tables in Transact SQL
(6 Videos)
Ready to get started?
Search for videos
or browse by tag below:
Transact SQL Tag Cloud
(
What's a tag cloud?
)
Top 100 Tags
@@identity
@RETURN_VALUE
alternate key
And
ANSI-1989
ANSI-1992
ANSI-1999
ANSI-2003
arrays
auto number
bcp
beginning
best practices
bulk insert
bulk operations
BULKINSERT
cast
cast and convert
clause
comma separated values
compare
comparison
convert
convert date to string
converting datatypes
create table
cross tab
crosstab
csv
data type conversion
data types
dbo
decimal
delete
DELETE Statement
distinct
DML
duplicate
excel
float
for xml
format dates
formatting
FROM
function
functions
group by
having
hierarchical query
host_name
identity
if exists
insert
INSERT Statement
INSERT Syntax
int32
int64
introduction
ISO 1992
ISO-2003
iteration
JOIN
management studio
nchar
new feature
numeric
nvarchar
nvarchar(max)
Object Explorer
object owners
OPENROWSET
optimizations
optimizing
Or
output
performance tuning
RANK
report
reports
return @@ERROR
returning error
sample database
select
sequence numbers
SqlParameter
ssms
statement
Stored procedure
Subqueries
SUBQUERY
T-SQL
Transact SQL
transact-sql
TSQL
udf
UPDATE STATEMENT
UPDATE syntax
WHERE
while
xml
What are tags?
You can give videos a "tag", which is like a keyword or category label. Tags help you find videos which have something in common and many people find them essential in helping avoid "information overload" on large websites such as this one.
Large fonts
mean there are lots of videos with this tag and
small fonts
mean there are fewer videos with this tag.
Home
|
About Us
|
Advertising
|
Contact Us
|
Privacy
|
System Requirements
|
Terms and Conditions
|
Testimonials
|
|
Site Map
© Copyright 2004-2007 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.
5/16/2008 1:14:43 AM