Basic SQL Exercises - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Basic SQL Exercises

Author

Topic

JacobPressures
Posting Yak Master

112 Posts

Posted - 2009-03-27 : 14:32:06

I'm looking for a good website with practice problems or a good workbook (paper is fine). I've learned SQL but its been a couple of years since I've done a lot of "relational algebra." I would like something challenging enough from basic, intermediate maybe even advanced so i can sharpen my skills and see areas where i need to improve. I want something comprehensive.

I don't know why there aren't books out there like math books where you just have hundreds of practice problems to build skills or refresh your memory.

Thanks!

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-03-27 : 14:50:08

Check out the links in my signature.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-03-27 : 17:35:33

You can try this:

http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-Systems/dp/1558604537

You should also read:

http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/0123693799/ref=pd_bxgy_b_img_b

And if you want to get good at SQL Server:

http://www.amazon.com/Gurus-Guide-SQL-Server-Boxed/dp/0321287509/ref=sr_1_3?ie=UTF8&s=books&qid=1238189415&sr=1-3

There's also:

http://www.amazon.com/Server-2008-Transact-SQL-Recipes-Problem-Solution/dp/1590599802/ref=sr_1_17?ie=UTF8&s=books&qid=1238189486&sr=1-17
http://www.amazon.com/Server-2005-T-SQL-Recipes-Problem-Solution/dp/159059570X/ref=sr_1_11?ie=UTF8&s=books&qid=1238189463&sr=1-11 (probably the same as the above)

Those 2 should have good practical examples. And if you want some theory:

http://www.amazon.com/Applied-Mathematics-Database-Professionals-Experts/dp/1590597451/ref=sr_1_1?ie=UTF8&s=books&qid=1238189660&sr=1-1

I haven't dug too deeply into that one yet but I like it. It should definitely cover relational algebra and such.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources