Software Engineering Stack Exchange is a question and answer site for professionals, academics, and students working within the systems development life cycle. It only takes a minute to sign up.
Sign up to join this community
I need lots of training in SQL coding in MS SQL server
The following part that is needed to be improved is:
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?
You can download and install the Northwind and Pubs sample database.
This is used in many tutorials and examples on MSDN.
Then, start reading through Books Online about the topics you have difficulties with. Play around with the databases.
This might not be directly realated to your question but if your looking for different SQL problems and techniques to solve them i would suggest having a look at some books by Joe Celko.
He does have some other titles but these should cover most areas in the usage of SQL.
Just try to prepare for MS exam 70-433. Use suggested books.
The textbook I've been using, Microsoft T-SQL Fundamentals, comes with a sample database and sample questions (with solutions). I highly recommend the book.
Browsing StackOverflow for SQL questions has been useful for me. This custom link I use has most of the SQL tags (specifically SQL Server) for easy browsing.
Lastly, try the links mentioned in this question. https://softwareengineering.stackexchange.com/questions/49942/website-with-sql-exercises-and-solutions
If you want to learn about using functions and a lot of other t-sql knowledge, I can't recommend Transact SQL User Defined Functions by Andrew Novick enough. Everything from design to formating. Before starting this book, you should have a basic understanding of sql. Probably one of the better programming books I've ever read.
You can get some help from tutorials such as ones available at Fianga and Function X.
From Fianga:
Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database applications. It is used at different levels and with various goals. This web site provides lessons and topics on how to use Microsoft SQL Server 2008 to create and manage databases.
