SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Learn T-SQL in 5 Minutes

I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach a n00b T-SQL in 5 minutes. I can guarantee that after my five minute talk, you’ll be an expert in T-SQL to rival the best of the best, or your money (that you spent on reading this free blog) back!

This will be the reference page for all time for the five minute talk. After the fact, I’ll post either a video from the talk or a reenactment, for your learning pleasure. But…if you’re not actually THERE, you’re going to miss out on some other really awesome speakers!

Thanks to Jorge Segarra (Blog, Twitter) for inviting me to present at the Lightning Talk…this is gonna be fun!


SQL Server Books Online

Book: SQL Server 2008 T-SQL Fundamentals*, by Itzik Ben-Gan



Demo: What’s the difference between CHAR and VARCHAR? and String Data Types in SQL Server: VARCHAR vs. CHAR

SQL Math: Whole Numbers, Real Numbers

How to Design and Build SQL Server Tables – (Part 1 , Part 2)

N Things Worth Knowing About SELECT and SELECT, Deconstructed

T-SQL: CASE Statement

Tip: Schema Qualify Objects in SPs

T-SQL for the Absentminded DBA


24 Hours of PASS Spring 2011 Code Sins (includes link to my Spring 2011 24HOP session “Code Sins” & related materials)

Forgotten T-SQL Cheat Sheet (includes links to my Fall 2010 24HOP session “Forgotten T-SQL” & related resources)

T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!

N Things Worth Knowing About CTEs

MERGE Statement Corrected, or, How to Eat Crow in Public


SELECT: If ON preceeds JOIN, then how….

Happy Days,
Jen McCown

*Disclosure: If you buy the book from the above link (my Amazon store), I get a very small percentage of the sale price. But I’m not otherwise affiliated, endorsed or paid by the publisher or author.


 The short link to this article is http://bit.ly/JenSQLin5minutes


No comments.

Leave a Comment

Please register or log in to leave a comment.