Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The following part that is needed to be improved is:

  • script
  • T-SQL
  • Procedure
  • Function

Problem: Where can I get material to improve my ability in SQL coding? Is there any website for downloading a database with different task/assignment and solution?

Where should I go to review lots of SQL code?

share|improve this question

4 Answers 4

up vote 3 down vote accepted

If you are looking to just improve your SQL coding ability I would go to the following sites:

Here is a list of sample SQL databases for you - http://msftdbprodsamples.codeplex.com/

For some FREE reading on check out - http://www.sqlservercentral.com/articles/books/67441/

share|improve this answer

You can always download the AdventureWorks databases to see samples of stored procedures, functions, databases etc for SQL Server. Then you can chose any or all of the sites and labs listed at this msdn thread

share|improve this answer

If you need to start at the basics this is the best book. Really any book about t-SQL by Itzik Ben-Gan will not steer you wrong.

share|improve this answer

The best way I found to learn more about T-SQL was to try and solve real world problems. Search the web for solutions and, of course, make use of dba.stackexchange and stackoverflow sites.

If you don't have any problems to solve at the moment (lucky you) then pick up a copy of Joe Celko's SQL Puzzles and Answers, that should keep you busy and help you learn T-SQL along the way.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.