Hi,
I want to learn T-SQL but there are so much kinda useless documents around internet. I've been searching tutorials but either most of them are not for beginners or cut off the tutorial at the best part.
I wanna learn it from start to advanced so could you guys please show me a website or something where I can learn it best.
Thanks in advance.
I suggest the w3schools SQL Tutorial.
To that, I would add:
Don't learn cursors.
I subscribe to the feeds from two groups that offer quite a bit of information online specific to SQL Server and T-SQL:
http://www.sqlservercentral.com/
SQL Server Central has somewhere in the neighborhood of 17 gazillion articles online - all focused on SQL Server. If you are going to be using SQL Server a lot, you really owe it to yourself to be part of their community.
SSWUG is an venerable user group with a real focus on learning SQL and real-world tips. It is very good but not SQL Server only (although that does seem to be their focus but it may just be that they have algorithms to tune what they show me).
Finally, of course, you can always ask questions here.
Good luck!
I think the book "Professional Microsoft SQL Server 2005 Programming" by Robert Vieira is great. There is a newer version for SQL Server 2008.
TSQL, while you can get a lot of help from MSDN on the syntax and the usage, you might find a lot of useful articles on
This has been really helpful for me as it covers various key features and also examples of TSQL and troubleshooting various issues.
I've sent a PDF copy of SQL for Dummies to some interns where I work to give them a head start, despite the name it's concise and clearly explains many of the basic concepts common to lots of flavors of SQL.