moiMusique/iAmOpen — Issue #9: Get familiar with sql queries and make some exercises
Author: moiMusique
Created: 2011-10-26 08:52:29+00:00
State: open

It's time to begin with some practical knowledge, not just planning the database.
So you need to have some practice. The best option is to write as much diferent and complex queries as possible.
I found a very good resourse with different levels of sql practical tasks. There's a whole bunch of excercises, which will develop the sql-way of thinking.
Try to solve as much tasks as you can; you also may need to read something you are not familiar with(about join, foreign keys, indexes etc - you have books and google)
so here is the site with training(you have to register there - it's free)
http://sql-ex.ru/?Lang=0

i also give other resources, just in case:
useful book - http://www.ex.ua/view_storage/326707379367
http://www.sqlservercentral.com/
sql.ru