MarkiyanMatsekh / iAmOpen

web application for convenient search of institutions
markiyan.dyndns.biz
1 stars 0 forks source link

Get familiar with sql queries and make some exercises #9

Open MarkiyanMatsekh opened 12 years ago

MarkiyanMatsekh commented 12 years ago

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