1

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?

4

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/

| improve this answer | |
1

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

| improve this answer | |
1

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.

| improve this answer | |
1

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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