question

Melvyn Harbour 1 avatar image
Melvyn Harbour 1 asked

What's the best T-SQL and SQL Server tutorial

I'm looking for a beginner's tutorial for both T-SQL and SQL Server. Where's the best place to start?

t-sqltutorial
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jay Bonk avatar image
Jay Bonk answered

This would be a good site to start with:

http://www.w3schools.com/SQl/default.asp

as would this:

http://www.microsoft.com/Sqlserver/2005/en/us/learning-resources.aspx

This would be a good choice for a book:

http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=sr_1_3?ie=UTF8&s=books&qid=1257956809&sr=8-3

Also, take advantage of the online forums, post questions... here, also at the MSDN Forums.

Read the articles on SSC, try the question of the day.

Also, Jacob Sebastian runs the http://beyondrelational.com/ web site and just started the TSQL Challenges for Beginners, try and work through them. Follow-up and see the solutions that were picked as winners....

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Jay Bonk

I clicked on the "beyondrelational" link you provided and it's changed a whole lot from years ago... is there a version that's still in English that you know of?

0 Likes 0 ·
dave ballantyne avatar image
dave ballantyne answered

I would suggest you start with RDBMS theory first. The Manga guide to RDBMS is a good starting point Amazon Link. Once upto speed on that many of the concepts that you will encounter will make a lot more sense.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jim Orten avatar image
Jim Orten answered

I would recommend:

http://www.sqlshare.com

It's not organized in lessons for a beginner, but it is definitely helpful for beginners.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The above link asks for username and password! is there a link to sing up or registration?

0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered

... and as always SQL Server Books Online.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yuriy Rozhok avatar image
Yuriy Rozhok answered

If your goal is to improve your practical T-SQL skills, http://www.sql-ex.ru/ is the best.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image
Steve Jones - Editor answered

I think that we have some good basic SQL articles on SQLServerCentral.

Basic joins: http://www.sqlservercentral.com/redirect/articles/65234/ Understanding NULL: http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/ Writing Simple Selects (3 part) - http://www.sqlservercentral.com/redirect/articles/2675/

SQLShare (www.sqlshare.com) has a lot of video content. I own part of that site, so I'll list it first, but MidnightDBA and Database Journal have videos as well.

I would recommend a couple basic books as well. SQL in a Nutshell by Kevin Kline, and Beginning T-SQL 2008 by Kathi Kellenburger are good choices.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.