Hi
I wanted a website that has ample amount of SQL (SQL Server 2005 or 2008) related queries to practice at home
Please let me know if you have any idea about the same.
thanks
A:
I'd suggest you to practice using Stack Exchange Data Explorer at http://odata.stackexchange.com
Select a StackExchange site and click Compose Query button.
What is Stack Exchange Data Explorer?
Stack Exchange Data Explorer allows you to run arbitrary SQL queries on the Stack Exchange family of sites, share those queries with your friends and explore interesting queries.
For more info, read the FAQ.
I think few people know about this great site.
Leniel Macaferi
2010-07-27 14:59:27
this is cool...
Romil Nagrani
2010-07-27 15:19:23
Yeah... really really cool. You can learn a lot.
Leniel Macaferi
2010-07-27 15:29:20
A:
Check out http://www.sqltree.com/ Also, some sample databases can be found here: http://msftdbprodsamples.codeplex.com/
Vidar Nordnes
2010-07-27 15:02:18
sqltree doesn't allow me to execute the queries nor it has Problems that i could practice and solve it and see whether the solution is correct or not
Romil Nagrani
2010-07-27 15:13:48
+1
A:
Try this one: SQL exercises. The queries are of different difficult from easy to hardest.
Giorgi
2010-07-27 15:03:32
In order to practice queries the first thing you will need is data to run your queries on, hence the sample databases. After that just start reading about different sql statements and trying them out on your sample data.
wshato
2010-07-27 15:29:45
i already have sample db and that too downloaded from site given. If i was able to "start reading........" i wouldn't had posted the question here.. I am looking for site that allows me to practice real world SQL statements, no matter whether that's online/offline
Romil Nagrani
2010-07-27 17:29:42
have you tried the sql tutorials at w3shools?http://www.w3schools.com/sql/default.aspThey have a web tool that lets you practice queries against a small dataset they have provided.
wshato
2010-07-27 18:27:48