Iain,
Read Joe Celko's books, starting with the latest edition of "SQL for
Smarties." I read his columns in Database Advisor and other magazines in the
1980s and have read and used almost all his books. You can't go wrong taking
the time to do it correctly from the gitgo.
Rich