Home » News-ish »SQLPASS »SQLRally »sqlserverpedia-syndication »SSC »TSQL » Currently Reading:

Learn T-SQL in 5 Minutes

April 29, 2011 News-ish, SQLPASS, SQLRally, sqlserverpedia-syndication, SSC, TSQL 2 Comments

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!

Edit: I can’t help but notice the INSANE number of hits on this blog since I put it up; thanks for visiting!  I hope you’re not dissapointed yet that the content isn’t up.  As soon as possible after May 13, I will put the session recording (or reenactment) up, along with the associated script.  In the meantime, please enjoy the very very useful resources and articles  (most of them freely available here on the interwebz!) that are listed below. -Jen

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

Resources

SQL Server Books Online

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

Articles

Basic

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

Intermediate

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

Tip: OVER and PARTITION BY

SELECT: If ON preceeds JOIN, then how….

Happy Days,
Jen McCown
http://www.MidnightDBA.com/Jen 

Check out http://bit.ly/DBAShow at 11pm CST, the only SQL Server webshow Banned in Canada(TM)!
Seasons 1 and 2 on www.MidnightDBA.com

*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

Currently there are "2 comments" on this Article:

  1. Nic Cain says:

    If you talk about the difference between CHAR and VARCHAR then Sean will have to come up with all new questions for when he interviews folks.

  2. [...] the thing (TWSS) and inviting me along (TWHS), it was a tremendous amount of fun. My 5 minutes was Learn T-SQL in 5 Minutes, and it went [...]

Comment on this Article:







Release Date: Minion by MidnightDBA

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category

DBAs@Midnight

How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!

DBARoadmap.com

The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/